File Manager

✏️ Edit File: /home/u625410797/domains/iooi.co.th/public_html/admin/debug_gallery_direct.php

<?php
require_once("conn.php");

// Get portfolio info for ID 6
$portfolioNo = 6;
$portfolioQuery = "SELECT no, portfolioName FROM portfolio WHERE no = $portfolioNo";
$portfolioResult = $conn->query($portfolioQuery);
$portfolioData = $portfolioResult ? $portfolioResult->fetch_assoc() : null;

$output = "=== PORTFOLIO ID 6 ===\n";
if ($portfolioData) {
    $output .= "PortfolioName: '" . $portfolioData['portfolioName'] . "'\n";
    $output .= "Length: " . strlen($portfolioData['portfolioName']) . "\n";
    $output .= "Hex: " . bin2hex($portfolioData['portfolioName']) . "\n";
} else {
    $output .= "No portfolio found\n";
}

// Get all portfoliodetail records
$output .= "\n=== ALL PORTFOLIODETAIL RECORDS ===\n";
$selectImages = "SELECT idNo, portfoliogroup, imgname, urllink, status FROM portfoliodetail ORDER BY idNo DESC LIMIT 10";
$resultImages = $conn->query($selectImages);

if ($resultImages && $resultImages->num_rows > 0) {
    while ($row = $resultImages->fetch_assoc()) {
        $output .= "ID: " . $row['idNo'] . "\n";
        $output .= "  portfoliogroup: '" . $row['portfoliogroup'] . "' (len=" . strlen($row['portfoliogroup']) . ")\n";
        $output .= "  imgname: '" . $row['imgname'] . "'\n";
        $output .= "  urllink: '" . $row['urllink'] . "'\n";
        $output .= "  status: " . $row['status'] . "\n";
        $output .= "---\n";
    }
} else {
    $output .= "No records\n";
}

// Check exact match
if ($portfolioData) {
    $portfolioName = $conn->real_escape_string($portfolioData['portfolioName']);
    $output .= "\n=== EXACT MATCH QUERY ===\n";
    $output .= "Query: WHERE portfoliogroup = '$portfolioName'\n";
    
    $checkQuery = "SELECT COUNT(*) as count FROM portfoliodetail WHERE portfoliogroup = '$portfolioName'";
    $checkResult = $conn->query($checkQuery);
    $checkRow = $checkResult ? $checkResult->fetch_assoc() : null;
    $output .= "Count: " . ($checkRow ? $checkRow['count'] : 0) . "\n";
    
    // Show matching records
    $matchQuery = "SELECT idNo, portfoliogroup, imgname, urllink FROM portfoliodetail WHERE portfoliogroup = '$portfolioName'";
    $matchResult = $conn->query($matchQuery);
    if ($matchResult && $matchResult->num_rows > 0) {
        $output .= "Matching records:\n";
        while ($row = $matchResult->fetch_assoc()) {
            $output .= "  ID: " . $row['idNo'] . ", group: '" . $row['portfoliogroup'] . "', img: '" . $row['imgname'] . "'\n";
        }
    } else {
        $output .= "NO MATCHES\n";
    }
}

file_put_contents('gallery_debug_output.txt', $output);
echo $output;
?>

Batal

⬅ Naik ke public_html 148 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁bootstrap	dir	—	2026-05-19 07:20	📂 Buka
📁css	dir	—	2026-05-19 07:20	📂 Buka
📁file export	dir	—	2026-05-19 07:20	📂 Buka
📁fileupload	dir	—	2026-05-19 07:20	📂 Buka
📁img	dir	—	2026-05-19 07:20	📂 Buka
📁js	dir	—	2026-05-19 07:20	📂 Buka
📁scss	dir	—	2026-05-19 07:20	📂 Buka
📁upload	dir	—	2026-05-19 07:20	📂 Buka
📁vendor	dir	—	2026-05-19 07:20	📂 Buka
📝README.md	md	4.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️S11157507.jpg	jpg	208.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️Solarcell.png	png	378.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘about_us_manager.php	php	16.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘actionuser.php	php	2.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘add_file_db.php	php	4.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘ajax_solution_details_manager.php	php	8.9 KB	2026-06-05 12:22	✏️ Edit 👁️ View
🐘ajax_solution_manager.php	php	8.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘ajaxfile.php	php	510 B	2026-06-03 06:33	✏️ Edit 👁️ View
🐘alertnoti.php	php	2.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘byProductDetail.php	php	4.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️c-01-1(1).png	png	18.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️c-01.png	png	141.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘check_conn.php	php	1004 B	2026-06-04 10:50	✏️ Edit 👁️ View
🐘check_delete_status.php	php	2.8 KB	2026-06-04 11:04	✏️ Edit 👁️ View
🐘check_footer_db.php	php	9.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘check_footer_qr_path.php	php	1.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘check_gallery_db.php	php	3 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘check_gd.php	php	751 B	2026-06-03 06:33	✏️ Edit 👁️ View
🐘check_home_portfolio_table.php	php	4.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘check_oth_img_structure.php	php	3.1 KB	2026-06-03 06:44	✏️ Edit 👁️ View
🐘check_portfolio_gallery.php	php	4.5 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘check_portfolio_query.php	php	2.9 KB	2026-06-03 06:43	✏️ Edit 👁️ View
🐘check_portfolio_table.php	php	2.7 KB	2026-06-03 06:58	✏️ Edit 👁️ View
🐘cleanup_duplicates.php	php	1.1 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘conn.php	php	1 KB	2026-06-05 12:22	✏️ Edit 👁️ View
🐘contact_manager.php	php	43.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘debug_gallery_direct.php	php	2.5 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘debug_server.php	php	3.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘delete_gallery_image.php	php	1.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️des-iooi.png	png	183.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️des_NEON.jpg	jpg	4.1 MB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘device.php	php	14.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘devicetoscene.php	php	9.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘devicetosceneedit.php	php	8.8 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘diagnose_production.php	php	5.9 KB	2026-06-04 11:08	✏️ Edit 👁️ View
📝error_log.txt	txt	13.2 KB	2026-06-05 07:15	✏️ Edit 👁️ View
🐘execute_gallery_insert.php	php	2.2 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘fix_auto_increment.php	php	1.3 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘fix_db_connection.php	php	1.4 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘fix_footer_paths.php	php	1.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘fix_gallery_insert.php	php	1.9 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘fix_portfoliodetail_table.php	php	3.2 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘fix_qr_path.php	php	796 B	2026-06-03 06:33	✏️ Edit 👁️ View
🐘fix_qr_path_v2.php	php	2.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘floating_widget.php	php	19.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️footer-qr.png	png	6.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘footer.php	php	258 B	2026-06-03 06:33	✏️ Edit 👁️ View
🐘footer_manager.php	php	44.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘force_db_insert.php	php	2.1 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘function.php	php	947 B	2026-06-03 06:33	✏️ Edit 👁️ View
📝gallery_debug_output.txt	txt	2.6 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘get_gallery_image.php	php	712 B	2026-06-03 06:33	✏️ Edit 👁️ View
📜gulpfile.js	js	3.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘home_portfolio_section.php	php	87 KB	2026-06-03 06:45	✏️ Edit 👁️ View
🐘home_product_section.php	php	69.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘home_solution_section.php	php	70.5 KB	2026-06-05 12:22	✏️ Edit 👁️ View
🐘homepage.php	php	59.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
📕i-INL-418.pdf	pdf	1.2 MB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️i-INL-418.png	png	152.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
📕i-INL-419.pdf	pdf	1.3 MB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️i-INL-419.png	png	174.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
📕i-INL-420.pdf	pdf	1.1 MB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️i-INL-420.png	png	196.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
📕i-INL-421.pdf	pdf	1.3 MB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️i-INL-421.png	png	220.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
📕i-INL-422.pdf	pdf	1.3 MB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️i-INL-422.png	png	209 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️i-SVG+AHF.png	png	237.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️i-SVG-AHF.png	png	237.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️images.jpg	jpg	15.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘importdata.php	php	497 B	2026-06-03 06:33	✏️ Edit 👁️ View
🖼️index-3.png	png	638.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘index.php	php	14 KB	2026-06-04 11:04	✏️ Edit 👁️ View
🗃️insert_gallery_direct.sql	sql	1.7 KB	2026-06-04 10:50	✏️ Edit 👁️ View
📜jquery-3.1.1.min.js	js	84.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘lastupdate.php	php	9.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘loaddevice.php	php	558 B	2026-06-03 06:33	✏️ Edit 👁️ View
🐘login.php	php	2.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘logout.php	php	86 B	2026-06-03 06:33	✏️ Edit 👁️ View
🐘manage_solution_details.php	php	40.6 KB	2026-06-05 12:22	✏️ Edit 👁️ View
🐘manageportfoliocategories.php	php	12.8 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘manageportfoliogallery.php	php	25.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘manual_gallery_insert.php	php	2.6 KB	2026-06-04 10:50	✏️ Edit 👁️ View
📝manual_insert_log.txt	txt	2.9 KB	2026-06-04 10:50	✏️ Edit 👁️ View
🐘menu.php	php	6.3 KB	2026-06-04 11:04	✏️ Edit 👁️ View
🐘navigation_menu.php	php	33 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘pdpa_manager.php	php	23.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘php.php	php	531 B	2026-06-03 06:33	✏️ Edit 👁️ View
🐘portfolio_admin_dashboard.php	php	21.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🗃️pro_stl.sql	sql	8.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘product_categories.php	php	23.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘reset_admin.php	php	1.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘reset_home_product_section.php	php	2.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_floating_widget.php	php	2.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_footer.php	php	7.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_gallery_image.php	php	3.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_home_portfolio_section.php	php	12.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_home_product_section.php	php	11.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_home_solution_section.php	php	12.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_homepage.php	php	14.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_navigation_menu.php	php	7.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘save_solution_page.php	php	19.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘savedata.php	php	3.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘scene.php	php	8 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘schedule.php	php	9.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘settingalert.php	php	14 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘solution_page.php	php	37.6 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘test_delete_function.php	php	1.9 KB	2026-06-04 11:04	✏️ Edit 👁️ View
🐘test_insert.php	php	911 B	2026-06-04 10:50	✏️ Edit 👁️ View
🐘test_portfolio_page.php	php	3.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘test_session.php	php	1.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘test_upload.php	php	2.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘test_write.php	php	1.4 KB	2026-06-03 06:33	✏️ Edit 👁️ View
📋testdata.json	json	513 B	2026-06-03 06:33	✏️ Edit 👁️ View
📋testjson.json	json	1.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘themes.php	php	25.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘updata.php	php	64 KB	2026-06-05 12:22	✏️ Edit 👁️ View
🐘update_category_link.php	php	2.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘update_gallery_image.php	php	1.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘upload.php	php	1.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘upload_category_image.php	php	4.8 KB	2026-06-03 06:33	✏️ Edit 👁️ View
📋upload_debug.log	log	77.8 KB	2026-06-05 04:18	✏️ Edit 👁️ View
🐘upload_floating_image.php	php	3.2 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘upload_footer_image.php	php	6.8 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadall.php	php	15.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadcatalogue.php	php	25.7 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadfile.php	php	2.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadimg.php	php	31.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadindex.php	php	15.3 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadmainmenu.php	php	17.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadmenu.php	php	12.9 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘uploadportfolio.php	php	45 KB	2026-06-03 06:58	✏️ Edit 👁️ View
🐘uploadsolution.php	php	44.9 KB	2026-06-05 12:22	✏️ Edit 👁️ View
🐘uploadsubmenu.php	php	16 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘usageerport.php	php	9.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘usagepower.php	php	9.5 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘user.php	php	17.1 KB	2026-06-03 06:33	✏️ Edit 👁️ View
🐘useract.php	php	1.1 KB	2026-06-04 11:04	✏️ Edit 👁️ View