个人中心
gpt4 book ai didi

php - 无法通过 PHP session 更新 MySQL 表

转载 作者：行者123 更新时间：2023-11-28 23:25:30 25 4
gpt4 key购买 nike

我无法通过从 PHP session 获取的值更新 MySQL 表。我测试了 PHP session 获取的值是可以的，我也发现我的代码中的 $sql_query1 有问题，但我无法修复它。

代码如下:

MySQL 模式↓

CREATE TABLE `test` (
  `class` int(50) DEFAULT NULL ,
  `class_group` int(50) DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `addr` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seq` int(50) NOT NULL,
  `survey` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `survey_status` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `survey_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `test` (`class`, `class_group`, `name`, `addr`, `seq`, `survey`, `survey_status`, `survey_date`) VALUES
(1, 0, 'Michael　　', 'USA', 10, '', '', '0000-00-00'),
(1, 0, 'Jordan　　', 'CAN', 20, '', '', '0000-00-00');

ALTER TABLE `test`
  ADD PRIMARY KEY (`seq`);

index.php↓

<?php
session_start();
?>

<!DOCTYPE html>
<html>
<body>

  <h2 align="center">Update_System</h2>

<form action="2_update.php" method="get">
  <fieldset>
  <legend><h2>System</h2></legend><br/>
  seq： <input type="text" name="seq"><br/>
  survey： <input type="text" name="survey"></br>
  survey_status： <input type="text" name="survey_status"><br/>
  survey_date： <input type="text" name="survey_date"><br/>
  </fieldset>
  <br>
  <input type="submit" name="submit" value="submit">
</form>
<br>
<form action="1_test_preview.php" method="POST">
<input type="submit" name="submit_preview" value="preview list">
</form>

</body>
</html>

preview.php↓

<!DOCTYPE html>
<html>
<body>
<h2 align="center">Result</h2>

<?php
if(isset($_POST['submit_preview'])){

$conn=mysql_connect("localhost","root","");
if (!$conn){die ("can not connect" . mysql_error());}
mysql_select_db("fs_change",$conn);
mysql_query("SET NAMES 'UTF8'");
mysql_query("set character set 'utf8'");

//set db connection
$sql_query1="select * from test";
$sql_nrow="select count(*) from test";
$result=mysql_query($sql_query1, $conn); 
$row_result=mysql_fetch_assoc($result); 
}
?>
<form id="form1" name="form1">
<table border="1" align="center">
<tr>
<td>class</td>
<td>class_group</td>
<td>name</td>
<td>addr</td>
<td>seq</td>
<td>survey</td>
<td>survey_status</td>
<td>survey_date</td>
</tr>

<?php do { ?>

<tr>
<td><?php echo $row_result['class']; ?></td>
<td><?php echo $row_result['class_group']; ?></td>
<td><?php echo $row_result['name']; ?></td>
<td><?php echo $row_result['addr']; ?></td>
<td><?php echo $row_result['seq']; ?></td>
<td><?php echo $row_result['survey']; ?></td>
<td><?php echo $row_result['survey_status']; ?></td>
<td><?php echo $row_result['survey_date']; ?></td>

<?php } while ($row_result = mysql_fetch_assoc($result));?>
<tr>

</table>
</form> 

<?php
mysql_free_result($result); 
?>
</body>
</html>

update.php↓

<?php
//get the data from session
session_start();
if(isset($_GET['seq'])){$_SESSION['seq']=$_GET['seq'];}
if(isset($_GET['survey'])){$_SESSION['survey']=$_GET['survey'];}
if(isset($_GET['survey_status'])){$_SESSION['survey_status']=$_GET['survey_status'];}
if(isset($_GET['survey_date'])){$_SESSION['survey_date']=$_GET['survey_date'];}



//set variables
    $seq = $_SESSION['seq'];
    $survey = $_SESSION['survey'];
    $survey_status = $_SESSION['survey_status'];
    $survey_date = $_SESSION['survey_date'];

//set db connection  
if(isset($_GET['submit'])){

$conn=mysql_connect("localhost","root","");
if (!$conn){die ("can not connect" . mysql_error());}
mysql_select_db("fs_change",$conn);
mysql_query("SET NAMES 'UTF8'");
mysql_query("set character set 'utf8'");

//set sql query
$sql_query1="UPDATE fs SET survey = $survey, survey_status = $survey_status, survey_date = $survey_date WHERE seq = $seq";
mysql_query($sql_query1, $conn);
mysql_close($conn);
} 
?>

<!DOCTYPE html>
<html>
  <body>
    test sql_query1：
    <?php 
    if ($sql_query1 === TRUE) {
    echo 'Updated Successfully'
    ;}
    else {echo "Update Failed";}
    ?> <br>
    seq：<?php echo $seq?><br>
    survey：<?php echo $survey?><br>
    survey_state：<?php echo $survey_status?><br>
    survey_date：<?php echo $survey_date?><br>
    <input type = "button" name = "return" value = "back" onclick= "history.back()"> &nbsp;
    </form>
  </body>
</html>

最佳答案

您缺少对值的单引号。使用以下更新 SQL 和 HTML 获取成功或失败消息。

$sql_query1="UPDATE fs SET survey = '$survey', survey_status = '$survey_status', survey_date = '$survey_date' WHERE seq = '$seq'";

$query_result = mysql_query($sql_query1, $conn);
mysql_close($conn);
} 
?>

<!DOCTYPE html>
<html>
  <body>
    test sql_query1：
    <?php 
    if ($query_result) {
    echo 'Updated Successfully'
    ;}
    else {echo "Update Failed";}
    ?> <br>

关于php - 无法通过 PHP session 更新 MySQL 表，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/39565122/

25 4 0
文章推荐： ios - UIScrollview 中的 UITextView 在 iPhone 5S 的可见屏幕下方
文章推荐： java - Tomcat 找不到 Spring Controller
文章推荐： javascript - 在不刷新网页的情况下加载 MySQL 数据
文章推荐： php - 如何删除mysql表中的空格？
行者123
个人简介

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

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