谁能救救我,帮我调试一段程序,100分都给你.
我的qq:7458518
实在没法了,一点一点问太慢了.
其实就是添加,删除,查找,等语句,总是有语病.
你留下信箱我发源程序给你也行,今晚必须解决了,要不我就惨了~~~~
一下时核心代码:
添加
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("tushu",$con);
$query="insert into library (name,author,id,classname,editdate) values($_POST['name'],$_POST['author'],$_POST['id'],$_POST['classname'],$_POST['editdate'])";
$result=mysql_query($query,$con);
require("dis.php")
删除
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("tushu");
$query="select name,author,id,classname,editdate from library";
$result=mysql_query("$query",$con);
$rownumber=mysql_num_rows($result);
echo"<center>";
echo"<table border='1'><td>";
echo"<tr>";
echo"<td></td>";
"<td align=center> $id </td>
<td align=center> $name </td>
<td align=center> $author </td>
<td align=center> $classname </td>
<td align=center> $edtidate </td>
</tr>";
?>
<form method="post" action="del1.php">
<?
while ($r=mysql_fetch_array($result))
{
$name=$r["name"];
$author=$r["author"];
$id=$r["id"];
$classname=$r["classname"];
$editdate=$r["editdate"];
echo"<tr>";
搜索
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("tushu");
$query="select * from library where " .$name." like '%".$bookname."%'";
$result=mysql_query($query,$con);
$rownumber=mysql_num_rows($result);
if ($rownumber)
{
echo"<cneter>";
echo"<table border='1'><td>";
echo"<tr>";
echo"<td align=center> id </td>
<td align=center> name </td>
<td align=center> author </td>
<td align=center> classname </td>
<td align=center> edtidate </td>
</tr>";
while ($r=mysql_fetch_array($result))
{
$name=$r["name"];
$author=$r["author"];
$id=$r["id"];
$classname=$r["classname"];
$editdate=$r["editdate"];
echo"<tr>";
echo"<td align='left'><font size='2'>$name</font></td>";
echo"<td align='left'><font size='2'>$author</font></td>";
echo"<td align='left'><font size='2'>$id</font></td>";
echo"<td align='left'><font size='2'>$classname</font></td>";
echo"<td align='left'><font size='2'>$editdate</font></td>";
echo"</th>";
}
echo"</table>";
echo"</table>";