Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/admin

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: verify_price_optional.php

<?php
include '../db.php';

echo "Verifying optional price insertion...\n";

// Test data
$brand_id = 1; // Assuming brand with ID 1 exists
$category_id = 1; // Assuming category with ID 1 exists
$series_id = null;
$name = "Test Product No Price " . uniqid();
$image_path = "";
$description = "Test Description";
$price = null; // This is what we are testing

// Ensure valid brand and category exists for foreign key constraint
$check_brand = $conn->query("SELECT id FROM brands LIMIT 1");
if ($check_brand->num_rows > 0) {
    $brand_id = $check_brand->fetch_assoc()['id'];
} else {
    die("No brands found. Cannot test.\n");
}

$check_cat = $conn->query("SELECT id FROM categories LIMIT 1");
if ($check_cat->num_rows > 0) {
    $category_id = $check_cat->fetch_assoc()['id'];
} else {
    die("No categories found. Cannot test.\n");
}

$sql = "INSERT INTO products (brand_id, category_id, series_id, name, image, description, price) VALUES (?, ?, ?, ?, ?, ?, ?)";
$stmt = $conn->prepare($sql);

if (!$stmt) {
    die("Prepare failed: " . $conn->error . "\n");
}

// Bind param: price is the last one, type 'd'
$stmt->bind_param("iiisssd", $brand_id, $category_id, $series_id, $name, $image_path, $description, $price);

if ($stmt->execute()) {
    $last_id = $stmt->insert_id;
    echo "Product inserted successfully with ID: $last_id\n";
    
    // Verify the insertion
    $result = $conn->query("SELECT price FROM products WHERE id = $last_id");
    if ($row = $result->fetch_assoc()) {
        if ($row['price'] === null) {
            echo "SUCCESS: Price is NULL in database.\n";
        } else {
            echo "FAILURE: Price is NOT NULL. Value: " . var_export($row['price'], true) . "\n";
        }
    }
    
    // Clean up
    $conn->query("DELETE FROM products WHERE id = $last_id");
    echo "Test data deleted.\n";
    
} else {
    echo "Error executing statement: " . $stmt->error . "\n";
}

$stmt->close();
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: verify_price_optional.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation