Prompt The universal PHP error fixer

I am a beginner PHP student working on a [project type, e.g. hospital management system]
running on XAMPP (PHP 8.x, MySQL).

I am getting this error:
[PASTE THE FULL ERROR MESSAGE HERE INCLUDING FILE NAME AND LINE NUMBER]

Here is the code from the relevant section (around the line mentioned):
[PASTE YOUR PHP CODE HERE]

I was trying to: [describe in one sentence what the code should do]

Please:
1. Explain in plain English why this error is happening
2. Show me the corrected code with the fix clearly marked
3. Explain what I should remember to prevent this type of error in future
4. Tell me if there are any other problems in this code I should fix now

Prompt Fix MySQL connection issues on XAMPP

My PHP project cannot connect to the MySQL database on XAMPP.
I am getting: [paste the exact error message]

My database connection code is:
[paste your config.php or connection code]

My XAMPP setup:
- PHP version: [check phpinfo() or XAMPP control panel]
- MySQL is running: Yes / No
- Database name: [your db name]
- I [have / have not] imported the SQL file

Please diagnose why the connection is failing and give me step-by-step
instructions to fix it, including what to check in XAMPP and phpMyAdmin.

Prompt Debug logic errors with no error message

My PHP code runs without any error message, but the output is wrong.

What the code is supposed to do:
[explain clearly — e.g. "Calculate the total bill for a customer by looking up
their internet plan price and multiplying by months owed"]

What is actually happening:
[describe the wrong behaviour — e.g. "The total always shows as 0" or
"All customers are getting the same price regardless of their plan"]

Here is the relevant PHP function:
[paste your code]

And the relevant SQL query:
[paste the query if there is one]

Please trace through the logic step by step and identify where the error is
in my reasoning or code. Do not just tell me the line — explain why the
logic is wrong so I understand it.

Prompt Fix a MySQL query that returns wrong results

My MySQL query is not returning the results I expect.

My database has these relevant tables:
[describe the tables briefly, e.g.:
- customers (id, name, plan_id, status)
- internet_plans (id, plan_name, price)
- bills (id, customer_id, amount, month, status)]

My query:
[paste your SQL query]

What I expect it to return:
[e.g. "All active customers with their plan name and monthly price"]

What it actually returns:
[e.g. "Only 2 rows when there should be 15" or "The price column is always NULL"]

Please:
1. Explain why my query is wrong
2. Show me the corrected query
3. Explain the correct JOIN / WHERE logic so I understand it for next time

Prompt Fix undefined variable / undefined index

I'm getting this PHP Notice/Warning:
[e.g. "Notice: Undefined variable $customer_id" or "Notice: Undefined index: plan_id"]

Here is the code around where it happens:
[paste your PHP code]

This variable/value is supposed to come from:
[e.g. "a form POST submission" or "a previous database query result" or
"a URL parameter like ?id=5"]

Please explain:
1. Why this variable/index is undefined at this point in the code
2. The correct way to check for and handle this situation
3. Whether to use isset(), empty(), or null coalescing (??) — and when to use each

Prompt Fix call to undefined function errors

I'm getting: Fatal error: Call to undefined function [function name]()

My project file structure:
[list your main PHP files, e.g.:
- index.php
- config/dbconnection.php (where my functions are defined)
- pages/billing.php (where the error happens)]

The function is defined in: [file name]
The function is being called in: [file name]

My include/require code at the top of the file with the error:
[paste the require or include lines]

Please explain why PHP cannot find this function and show me the correct
way to include/require files so functions are available where I need them.

PHP The broken code

// Error: Parse error: syntax error, unexpected token "if" in billing.php on line 8
$customer_id = $_GET['id']        // ← Missing semicolon!
if ($customer_id > 0) {
    generateBill($customer_id);
}

AI Fix Correct version with explanation

// The parser was confused because it reached the "if" keyword while
// still expecting the previous statement to end with a semicolon.
// PHP reports the line where it gave up, not where the mistake is —
// always check the line BEFORE the reported line number.
$customer_id = $_GET['id'];        // ← Semicolon added
if ($customer_id > 0) {
    generateBill($customer_id);
}

PHP The bug and the fix side by side

// ❌ WRONG — causes "Notice: Undefined index: customer_name"
// if the form was not submitted or the field was empty
$name = $_POST['customer_name'];
echo $name;

// ✅ CORRECT — safe approach with null coalescing operator (??)
// If customer_name doesn't exist in POST, $name becomes empty string
$name = $_POST['customer_name'] ?? '';

// ✅ ALSO CORRECT — using isset() for PHP 7.3 and below
$name = isset($_POST['customer_name']) ? $_POST['customer_name'] : '';

// When to use each:
// ?? is cleaner and works in PHP 7+ — use this as your default
// isset() needed if you want different handling for null vs not-set

PHP Correct MySQL connection with proper error handling

// Most common cause: MySQL is not running, wrong database name,
// or wrong password (XAMPP default: root with empty password)

$host   = 'localhost';
$dbname = 'your_database_name';  // Exact database name from phpMyAdmin
$user   = 'root';               // XAMPP default — never change this locally
$pass   = '';                    // XAMPP default is blank — no password

$conn = mysqli_connect($host, $user, $pass, $dbname);

// Always check if connection succeeded — this shows you WHAT went wrong
if (mysqli_connect_errno()) {
    die("Connection failed: " . mysqli_connect_error());
}

// AI debugging tip: paste the exact output of mysqli_connect_error()
// into your AI prompt — it tells you much more than "connection failed"

PHP Can you spot the bug? (AI finds it instantly)

// Bug: bill_amount is always 0 even though plans have prices
// No error message — just wrong output. This is where AI earns its value.

function calculateBill($customer_id, $conn) {
    $query = "SELECT p.price FROM customers c
               JOIN internet_plans p ON c.plan_id = p.id
               WHERE c.id = '$customer_id'";

    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);

    $price = 0;           // ← price initialised to 0 (correct)
    if ($row) {
        $price == $row['price']; // ← BUG: == is comparison, not = assignment!
    }                        //   $price stays 0, the comparison result is discarded

    return $price;          // Always returns 0
}

// ✅ FIX: Change == to = for assignment
    $price = $row['price'];  // Correct: assign the value

Copilot Chat Quick commands to type in the chat panel

# With broken code selected:
/fix Fatal error: Call to undefined function getCustomerBill() on line 34

# To understand what selected code does:
/explain

# To ask a specific question about selected code:
Why does this function return 0 when the customer has an active plan?

# To ask for a safer version:
Rewrite this selected code to handle the case where $result is empty or false

# To ask for the security risk:
Does this code have any SQL injection vulnerabilities? Show me the safe version.