以前在window下测试的程序可以正常运行,可在linux下确不能向mysql添加数据,也不能删除数据记录。
版本如下:
Fedora core6
Apache/2.2.4
PHP Version 5.1.6
mysql 5.0.27
程序如下<html><body><?php$db = mysql_connect("localhost", "root", "");mysql_select_db("mydb",$db);if ($submit) { // 如果没有ID,则我们是在增加记录,否则我们是在修改记录 if ($id) { $sql = "UPDATE employees SET first='$first',last='$last', address='$address',position='$position' WHERE id=$id"; } else { $sql = "INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position')"; } // 向数据库发出SQL命令 $result = mysql_query($sql); echo "记录修改成功!<>";} elseif ($delete) {// 删除一条记录 $sql = "DELETE FROM employees WHERE id=$id"; $result = mysql_query($sql); echo "记录删除成功!<>";} else { // 如果我们还没有按submit按钮,那么执行下面这部分程序 if (!$id) { // 如果不是修改状态,则显示员工列表 $result = mysql_query("SELECT * FROM employees",$db); while ($myrow = mysql_fetch_array($result)) { printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PATH_INFO, $myrow["id"], $myrow["first"], $myrow["last"]); printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PATH_INFO, $myrow["id"]); } } ?> <> <a href="<?php echo $PATH_INFO?>"> A RECORD</a> <> <form method="post" action="<?php echo $PATH_INFO?>"> <?php if ($id) { // 我们是在编辑修改状态,因些选择一条记录 $sql = "SELECT * FROM employees WHERE id=$id"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $id = $myrow["id"]; $first = $myrow["first"]; $last = $myrow["last"]; $address = $myrow["address"]; $position = $myrow["position"]; // 显示id,供用户编辑修改 ?> <input type=hidden name="id" value="<?php echo $id ?>"> <?php } ?> 名:<input type="Text" name="first" value="<?php echo $first ?>"><br> 姓:<input type="Text" name="last" value="<?php echo $last ?>"><br> 住址:<input type="Text" name="address" value="<?php echo $address ?>"><br> 职位:<input type="Text" name="position" value="<?php echo $position ?>"><br> <input type="Submit" name="submit" value="输入信息"> </form><?php}?></body></html>
版本如下:
Fedora core6
Apache/2.2.4
PHP Version 5.1.6
mysql 5.0.27
程序如下<html><body><?php$db = mysql_connect("localhost", "root", "");mysql_select_db("mydb",$db);if ($submit) { // 如果没有ID,则我们是在增加记录,否则我们是在修改记录 if ($id) { $sql = "UPDATE employees SET first='$first',last='$last', address='$address',position='$position' WHERE id=$id"; } else { $sql = "INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position')"; } // 向数据库发出SQL命令 $result = mysql_query($sql); echo "记录修改成功!<>";} elseif ($delete) {// 删除一条记录 $sql = "DELETE FROM employees WHERE id=$id"; $result = mysql_query($sql); echo "记录删除成功!<>";} else { // 如果我们还没有按submit按钮,那么执行下面这部分程序 if (!$id) { // 如果不是修改状态,则显示员工列表 $result = mysql_query("SELECT * FROM employees",$db); while ($myrow = mysql_fetch_array($result)) { printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PATH_INFO, $myrow["id"], $myrow["first"], $myrow["last"]); printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PATH_INFO, $myrow["id"]); } } ?> <> <a href="<?php echo $PATH_INFO?>"> A RECORD</a> <> <form method="post" action="<?php echo $PATH_INFO?>"> <?php if ($id) { // 我们是在编辑修改状态,因些选择一条记录 $sql = "SELECT * FROM employees WHERE id=$id"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $id = $myrow["id"]; $first = $myrow["first"]; $last = $myrow["last"]; $address = $myrow["address"]; $position = $myrow["position"]; // 显示id,供用户编辑修改 ?> <input type=hidden name="id" value="<?php echo $id ?>"> <?php } ?> 名:<input type="Text" name="first" value="<?php echo $first ?>"><br> 姓:<input type="Text" name="last" value="<?php echo $last ?>"><br> 住址:<input type="Text" name="address" value="<?php echo $address ?>"><br> 职位:<input type="Text" name="position" value="<?php echo $position ?>"><br> <input type="Submit" name="submit" value="输入信息"> </form><?php}?></body></html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货