<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("tushu",$con);
$query="select * from library";
$result=mysql_query($query,$con);
$rownumber=mysql_num_rows($result);
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>";
?>
这是tushudis.php
数据加不上,表格却增加了
$con=mysql_connect("localhost","root","");
mysql_select_db("tushu",$con);
$query="select * from library";
$result=mysql_query($query,$con);
$rownumber=mysql_num_rows($result);
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>";
?>
这是tushudis.php
数据加不上,表格却增加了
$quety="insert into library (name,author,id,classname,editdate) values('$name','$author','$id','$classname','$editdate')";
该语句中的变量在赋值了吗?
$result=mysql_query("$query",$con);前面的que“t”y,后面的却是que“r”y,怎么能加进去??
//应该是$query吧
$result=mysql_query("$query",$con);
$name改成$_POST['name'],$id改成$_POST['author'],
$classname改成$_POST['classname'],$editdate改成$_POST['edidate'].
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\www\manage\add1.php on line 9
我改的
$query="insert into library (name,author,id,classname,editdate) values($_POST['name'],$_POST['author'],$_POST['id'],$_POST['classname'],$_POST['editdate'])";
$info = array($_POST['Sno'],$_POST['Name'],$_POST['Sex'],$_POST['Hobby']);
$strSQL="insert into test1 values('$info[0]','$info[1]','$info[2]','$info[3]')";
<?php
$con=mysql_connect("localhost","root","1234");
mysql_select_db("tushu");
$quety="insert into library (name,author,id,classname,editdate) values('$name','$author','$id','$classname','$editdate')";
$result=mysql_query("$query",$con);//此断代码的$quety与$query是不是写错误了.
require("tushudis.php");
?>
//**********************************
再者可以使用
代码mysql_query("$query",$con);改为
$result=mssql_query($query);试一试.