个人中心
gpt4 book ai didi

php - 无法在 MySQL PHP 表单中显示记录字段更新结果

转载 作者：太空宇宙 更新时间：2023-11-03 12:14:13 24 4
gpt4 key购买 nike

按下“更新”按钮后，它应该更新，然后显示更新记录记录的结果(具有选定列的单个更新记录)。但是该页面只显示表列名，没有任何记录和一些错误。请帮忙。

<html>
<head>
<strong><font size="6">Sales Log - Main</font><font size="5"><br />
(Transaction Status Update)</font></strong>
</head>
<body bgcolor="#6E6E6E" text="Azure">

<?php
if(isset($_POST['update']))
{
$dbhost = 'localhost';
$dbuser = 'jack';
$dbpass = 'somepassword';
$myDBname = 'sales';
$conn = mysql_connect($dbhost, $dbuser, $dbpass, $myDBname);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}

$FileNumber = mysql_real_escape_string($_POST['FileNumber']);
$Status = mysql_real_escape_string($_POST['Status']);

//$sql = "UPDATE saleslog SET Status = '".$Status."' WHERE FileNumber = '".$FileNumber."'"; //this worked fine then code below was introduced

$sql = "UPDATE saleslog 
       SET Status = '$Status'
       WHERE FileNumber = '$FileNumber'" ;

mysql_select_db('realestate');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not update data: ' . mysql_error());
}
echo "Updated data successfully!\n";
mysql_close($conn);
}
else
{
?>
<form method="post" action="<?php $_PHP_SELF ?>">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<br />
<br />
<td width="100">File Number</td>
<td><input name="FileNumber" type="text" id="FileNumber"></td>
</tr>
<tr>
<td width="100">Status</td>
<td><input name="Status" type="text" id="Status" value="Closed"></td>
</tr>
<tr>
<td width="100"> </td>
<td> </td>
</tr>
<tr>
<td width="100"> </td>
<td>
<input name="update" type="submit" id="update" value="Update">
<input name="reset" type="reset" onclick="resetForm(''); return false;" />
</td>
</tr>
</table>
</form>
<?php
}
?>


$sql="SELECT FileNumber, Address, Status FROM $tbl_name";
$result=mysql_query($sql);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="center"><strong>FileNumber</strong></td>
<td align="center"><strong>Address</strong></td>
<td align="center"><strong>Status</strong></td>
</tr>

<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td><? echo $rows['FileNumber']; ?></td>
<td><? echo $rows['Address']; ?></td>
<td><? echo $rows['Status']; ?></td>

</tr>

<?php
}
?>

</table>
</td>
</tr>
</table>

<?php
mysql_close();
?>

最佳答案

代码中的各种错误。

直接转换为'mysqli'。我没有以任何方式改变逻辑。

测试代码:PHP 5.3.18。 mysql 5.5 window xp.

添加了表格布局。

无需删除任何行，因为我已将它们转换为注释。只需复制和粘贴即可。

<!DOCTYPE HTML">
<html>
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF8">
    <title>
    </title>
  </head>
<strong><font size="6">Sales Log - Main</font><font size="5"><br />
(Transaction Status Update)</font></strong>
</head>
<body bgcolor="#6E6E6E" text="Azure">
<?php
    // always connect to the database...
    $mysqlhost   = 'localhost';
    $mysqluser   = 'jack';
    $mysqlpass   = 'test';
    $myDBname    = 'sales'; // should this be 'realestate'


    // why select a different database then when you connected? was 'sales'
    //  mysql_select_db('realestate'); /* why? */

    $mysqli = new mysqli($mysqlhost, $mysqluser, $mysqlpass, $myDBname);

    if(mysqli_connect_errno())
    {
      die('Could not connect: ' . mysqli_connect_error());
    }

    // set the database table to use...
    $tbl_name = "`saleslog`";


    if (isset($_POST['update'])) // we have some record to change...
    {
        // do not need to escape input as we will use prepared query and bind variables
        $FileNumber = $_POST['FileNumber'];
        $Status     = $_POST['Status'];

        //$sql = "UPDATE saleslog SET Status = '".$Status."' WHERE FileNumber = '".$FileNumber."'"; //this worked fine then code below was introduced

        $sql = "UPDATE $tbl_name
                SET `Status` = ?
                WHERE `FileNumber` = ?" ;

        $updateQuery =  $mysqli->prepare($sql);
        if ($updateQuery === false) { // drat
            die('updateQuery: '. $mysqli->error);
        }

        // bind the variables to the query
        $updateQuery->bind_param('si', $Status, $FileNumber);

        $allOk = $updateQuery->execute();
        if (!$allOk) { // drat
            die('updateQuery: '. $updateQuery->error);
        }

        if ($mysqli->affected_rows >= 1) {
            echo "Updated data successfully!<br />";
        }
        else {
            echo "FileNumber: $FileNumber was not changed<br />";
        }
    }
    else
    {
    ?>
    <form method="post" action="<?php $_PHP_SELF ?>">
      <table width="400" border="0" cellspacing="1" cellpadding="2">
        <tr><br /><br />
          <td width="100">File Number</td><td>
            <input name="FileNumber" type="text" id="FileNumber"></td>
        </tr>
        <tr>
          <td width="100">Status</td><td>
            <input name="Status" type="text" id="Status" value="Closed"></td>
        </tr>
        <tr>
          <td width="100"> </td><td> </td>
        </tr>
        <tr>
          <td width="100"> </td><td>
            <input name="update" type="submit" id="update" value="Update">
            <input name="reset" type="reset" onclick="resetForm(''); return false;" /></td>
        </tr>
      </table>
    </form>
<?php

}

// always use 'prepare'
if (!empty($FileNumber)) {
    $whereClause = " WHERE `FileNumber` = ?";
}
else {
    $whereClause = " ORDER BY `FileNumber`";
}

$sql = "SELECT `FileNumber`, `Address`, `Status`
       FROM $tbl_name
       $whereClause";

$selectQuery = $mysqli->prepare($sql);
if (!empty($FileNumber)) {
    $selectQuery->bind_param('i', $FileNumber);
    $originalFileNumber = $FileNumber;
}

$allOk = $selectQuery->execute();
if (!$allOk) { // drat
    die('selectQuery: '. $selectQuery->error);
}

// results will be placed in these three variables when we fetch the row later
$selectQuery->bind_result($FileNumber, $Address, $Status);

?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
    <td>
        <table width="400" border="1" cellspacing="0" cellpadding="3">
        <tr>
            <td colspan="4"><strong>List data from mysql </strong> </td>
        </tr>

        <tr>
            <td align="center"><strong>FileNumber</strong></td>
            <td align="center"><strong>Address</strong></td>
            <td align="center"><strong>Status</strong></td>
        </tr>

        <?php $rowCount = 0; ?>
        <?php while($selectQuery->fetch()):  // the data will be in the 'bind_result' variables ?>
          <tr>
            <td><?= $FileNumber ?></td>
            <td><?= $Address; ?></td>
            <td><?= $Status; ?></td>
          </tr>
          <?php $rowCount++; ?>
        <?php endwhile; ?>
        </table>
    </td>
</tr>
<td>
    <?php if ($rowCount >= 1): ?>
      <strong><?php echo $rowCount; echo $rowCount == 1 ? ' row found' : ' rows found'; ?></strong>
    <?php elseif (!empty($originalFileNumber)): ?>
      <strong>No rows found for FileNumber: <?php echo $originalFileNumber; ?></strong>
    <?php else: ?>
      <strong>No rows found in the table!!!></strong>
    <?php endif ?>
</td>
</table>
</body>
</html>
<?php
$mysqli->close(); // free the database connection -- not needed but harmless
?>

表格数据:

FileNumber  Status  Address        
----------  ------  ---------------
         1  open    here at home!  
         2  Closed  what ever

表格布局:

*DDL Information*/
-------------------

CREATE TABLE `saleslog` (
  `FileNumber` int(11) NOT NULL,
  `Status` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `Address` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`FileNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

关于php - 无法在 MySQL PHP 表单中显示记录字段更新结果，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/22885632/

24 4 0
文章推荐： mysql - 检查需要升级、损坏或未完全关闭的表
文章推荐： android - 使用 FirebaseAuth 电话号码验证进行测试
文章推荐： android - qemu-系统-i386 : Could not allocate clusters for qcow2 header and refcount table: Bad address
文章推荐： java - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException | JAVA
太空宇宙
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com