php - 数据库没有更新，但没有出现错误。 MySQL 和 PHP

Question

我正在为一位 friend 创建一个网站，基本上有 15 个可根据用户类型进行编辑的字段。基本上，我的代码将行回显到字段中，但是当我去更改它并更新数据库时，什么也没有发生。我没有收到任何错误消息，所以我认为这与我的条件语句有关。我的函数工作正常，但我的查询似乎不喜欢我。

<?php
//end of function
}

// connect to the database
$server = 'localhost';
$user = 'root';
$pass = '';
$database = 'bubbles';

//Connect to the database
$connection = mysql_connect($server, $user, $pass) or die ("Could not connect to server ... \n" . mysql_error ());

//Select the database name
$select = mysql_select_db($database) or die ("Could not connect to database ... \n" . mysql_error ());

// check if the form has been submitted. If it has, process the form and save it to the database
if ($_SERVER['REQUEST_METHOD'] === 'POST')
{ 

    // confirm that the 'id' value is a valid integer before getting the form data
    if (is_numeric($_POST['id']))
    {

        //Get form data to make sure it's valid
        $id = $_POST["id"];
        $name = mysql_real_escape_string(htmlspecialchars($_POST['name']));
        $dueDate = mysql_real_escape_string(htmlspecialchars($_POST['dueDate']));
        $numOfPages = mysql_real_escape_string(htmlspecialchars($_POST['numOfPages']));
        $numOfCopies = mysql_real_escape_string(htmlspecialchars($_POST['numOfCopies']));
        $paperSize = mysql_real_escape_string(htmlspecialchars($_POST['paperSize']));
        $paperColor = mysql_real_escape_string(htmlspecialchars($_POST['paperColor']));
        $weight = mysql_real_escape_string(htmlspecialchars($_POST['weight']));
        $finishing = mysql_real_escape_string(htmlspecialchars($_POST['finishing']));
        $paymentMethod = mysql_real_escape_string(htmlspecialchars($_POST['paymentMethod']));
        $printColor = mysql_real_escape_string(htmlspecialchars($_POST['printColor']));
        $status = mysql_real_escape_string(htmlspecialchars($_POST['status']));
        $comment = mysql_real_escape_string(htmlspecialchars($_POST['comment']));

        // check that firstname/lastname fields are both filled in
        if ($name == '' || $dueDate == '' || $numOfPages == '' || $numOfCopies == '' || $comment == '')
        {
            // generate error message
            $error = 'Please fill in all required fields!';

            //error, display form
            displayForm($id,
                       $name,
                       $dueDate,
                       $numOfPages,
                       $numOfCopies,
                       $paperSize,
                       $paperColor,
                       $weight,
                       $finishing,
                       $paymentMethod,
                       $printColor,
                       $comment,
                       $status,
                       $error);
        }
        else
        {

            //Insert form data into the database or die if there is an error
        print $sql;

        $sql = ("UPDATE orders SET `name` = '".$name."',
                                   due_date = '".$dueDate."',
                                   numOfPages = '".$numOfPages."',
                                   numOfCopies = '".$numOfCopies."',
                                   paper_size = '".$paperSize."',
                                   paper_color = '".$paperColor."',
                                   weight = '".$weight."',
                                   finishing = '".$finishing."',
                                   payment_method = '".$paymentMethod."',
                                   color = '".$printColor."',
                                   comments = '".$comment."',
                                  `status` = '".$status."' WHERE id = '".$id."'");

        $result = mysql_query($sql) or die (mysql_error());

            // once saved, redirect back to the view page
            header("Location: http://localhost/Bubbles/view-orders.php"); 
        }
    }
    else
    {
        // if the 'id' isn't valid, display an error
        echo 'Error!';
    }
}
else
{
    // if the form hasn't been submitted, get the data from the db and display the form

    // get the 'id' value from the URL (if it exists), making sure that it is valid 
    if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
    {
        // query db
        $id = $_GET['id'];
        $result = mysql_query("SELECT * FROM orders WHERE id = '$id'") or die(mysql_error()); 
        $row = mysql_fetch_array($result);

        // check that the 'id' matches up with a row in the databse
        if($row)
        {

            // get data from db
            $id = $row['id'];
            $name = $row['name'];
            $dueDate = $row['due_date'];
            $numOfPages = $row['numOfPages'];
            $numOfCopies = $row['numOfCopies'];
            $paperSize = $row['paper_size'];
            $paperColor = $row['paper_color'];
            $weight = $row['weight'];
            $finishing = $row['finishing'];
            $paymentMethod = $row['payment_method'];
            $printColor = $row['color'];
            $status = $row['status'];
            $comment = $row['comments'];

            // show form
            displayForm($id,
                       $name,
                       $dueDate,
                       $numOfPages,
                       $numOfCopies,
                       $paperSize,
                       $paperColor,
                       $weight,
                       $finishing,
                       $paymentMethod,
                       $printColor,
                       $comment,
                       $status,
                       '');
        }
        else
        {
            // if no match, display result
            echo "No results!";
        }
    }
    else
    {
        // if the 'id' in the URL isn't valid, or if there is no 'id' value, display an error
        echo 'Error!';
    }
}
?>

使用 HTML 进行更新

 <html>
 <head>
 </head>
 <body>
 <form action"" method="post">
    <input type="hidden" name="id" value="<?php echo $id; ?>"/>
    <div class="floatLeft">
                    <p>Name:                            <br /> <input type="text" name="name" value="<?php echo $name; ?>"/></p>
                    <p>Due Date (ex: yyyy-mm-dd):       <br /> <input type="datetime" name="dueDate" value="<?php echo $dueDate; ?>" /></p>
                    <p># of Pages                       <br /> <input type="number" name="numOfPages" value="<?php echo $numOfPages; ?>"/></p>
                    <p># of Copies                      <br /> <input type="number" name="numOfCopies" value="<?php echo $numOfCopies; ?>"/></p>
                </div>
                <div class="floatLeft"> 
                    <p>Paper Size<br /> 
                    <select name = "paperSize" value="<?php echo $paperSize; ?>">
                        <option value="8.5 x 11in">8.5 x 11 inches</option>
                        <option value="8.5 x 14in">8.5 x 14 inches</option>
                        <option value="11 x 17in">11 x 17 inches</option>
                    </select>           
                    </p>
                    <p>Paper Color<br /> 
                    <select name = "paperColor" value="<?php echo $paperColor; ?>">
                        <option value = "pulsar pink">Pulsar Pink</option>
                        <option value = "fireball fuchsia">Fireball Fuchsia</option>
                        <option value = "plasma pink">Plasma Pink</option>
                        <option value = "re-entry red">Re-entry Red</option>
                        <option value = "rocket red">Rocket Red</option>
                        <option value = "cosmic orange">Cosmic Orange</option>
                        <option value = "galaxy gold">Galaxy Gold</option>
                        <option value = "solar yellow">Solar Yellow</option>
                        <option value = "venus violet">Venus Violet</option>
                        <option value = "planetary purple">Planetary Purple</option>
                        <option value = "celestial blue">Celestial Blue</option>
                        <option value = "lunar blue">Lunar Blue</option>
                        <option value = "gamma green">Gamma Green</option>
                        <option value = "martian green">Martian Green</option>
                        <option value = "terra green">Terra Green</option>
                        <option value = "lift-off lemmon">Lift-off Lemon</option>
                    </select>           
                    </p>
                    <p>Weight<br/> 
                    <select name = "weight" value="<?php echo $weight; ?>">
                    <option value="20lbs">20lbs</option>
                    <option value="60lbs">60lbs</option>
                    <option value="65lbs">65lbs</option>
                    </select>           
                    </p>
                    <p>Finishing<br /> 
                <select name = "finishing" value="<?php echo $finishing; ?>">
                    <option value="none">None</option>
                    <option value="cutting">Cutting</option>
                    <option value="folding">Folding</option>
                    <option value="quaters">Quaters</option>
                    <option value="binding">Bindings</option>
                </select>           
                </p>
                <p>Payment method<br /> 
                <select name = "paymentMethod" value="<?php echo $paymentMethod; ?>">
                    <option value="Cash">Cash</option>
                    <option value="Credit">Credit</option>
                    <option value="Check">Check</option>
                    <option value="Wilscard">Wilscard</option>
                </select>           
                </p>
                <p>Print BW/C<br /> 
                <select name = "printColor" value="<?php echo $printColor; ?>">
                    <option value="Black">Black</option>
                    <option value="White">White</option>
                    <option value="Color">Color</option>
                </select>
                </p>            
                </p>
                </div>
                <div class="floatLeft">
                <p>Status<br /> 
                <select name = "status" value="<?php echo $row['status']; ?>">
                    <option value="Recieved">Received</option>
                    <option value="In Progress">In Progress</option>
                    <option value="Completed">Completed</option>
                </select>   
                <p>Comment (Cannot exceed 200 characters):<br />
                <textarea name="comment" value="<?php echo $comment; ?>"></textarea><br />
                </p>
                <input type="submit" value="Edit Order" />
 </div>
 </body>
 </html> 

更新:我修复了代码，感谢大家的帮助，但我的错误是，当我检查空字段时，注释框中没有写任何内容，因此它认为所有字段都是空的，而实际上它们不是't。我用这段代码更新了字段检查，现在工作正常。

我更新了 if 语句:

if ($name == '' || $dueDate == '' || $numOfPages == '' || $numOfCopies == '' || $comment == '')

对此:

if ($name == '' || $dueDate == '' || $numOfPages == '' || $numOfCopies == '')

Answer 1

在 $sql 变量中创建查询后，您似乎并未运行该查询。您需要像稍后在代码中执行的那样执行查询:

$result = mysql_query($sql) or die(mysql_error());

成功时返回true，失败时返回false(并死亡)。