PHP数据库查询

PHP相关数据库查询语句

mysql_close();#关闭库

exit;

#检测数据库表是否存在

$sql="select TableName from Fatheranclass where TableName='$TableName'"; $result=mysql_fetch_row(mysql_query($sql));

if($result){

echo "";

exit();}

#检测结束

#添加到数据库

$sql="INSERT INTO

Fatheranclass(AdminClassName,TableName,Orders,Optional,Description) VALUES('$AdminClassName','$TableName','$Orders','$Optional','$Description')"; if (!mysql_query($sql,$Frank))

{die('Error: ' . mysql_error());}

echo ("");

exit();

#添加结束

#删除数据库信息

mysql_query("DELETE FROM Fatheranclass WHERE ID='$ID'");

echo ("");

exit();

#删除结束

#分页循环代码

$PageSize=15;

$Pagenow=$_REQUEST[page];//获取当前页面的值

if ($Pagenow==""){

$Page1=1;

}else{

$Page1=$Pagenow;

}

$Page=$Page1-1;

$pageint=$Page*$PageSize;

$sql02 = mysql_query("SELECT ID FROM Fatheranclass limit 0,3000"); $rows=mysql_num_rows($sql02);//总记录数

$Counts=$PageSize*$Page;

if ($Counts>$rows){

echo "页面超出";

exit;

}

// 计算日期datediff(字段,'$d')>=-3

//模糊查询UserName like '%$keyword%'

$CountPage=ceil($rows/$PageSize);//计算出页面数

$d=date("Y-m-d H:i:s");

$sql01 = mysql_query("SELECT ID,AdminClassName,TableName,Orders,Optional FROM Fatheranclass order by Orders desc,ID ASC limit $pageint,$PageSize");

$ling=1;

while($rs = mysql_fetch_array($sql01)){

echo "内容";

$ling++;

}

共查询条记录[首页]

for($count=1;$count<=$CountPage;$count++){

echo "[",$count,"]";

}

?>[尾页]

//分页结束

//修改数据

mysql_query("UPDATE Fatheranclass SET

AdminClassName='$AdminClassName',Orders='$Orders',Description='$Description' where ID='$ID'");

echo ("");

exit();

$ID=$_REQUEST[ID];//获取当前页面ID值

//查询语句

$sql="select * from Fatheranclass where ID='$ID'";

$Frank=mysql_query($sql);

while($rs=mysql_fetch_array($Frank)){

$View->AdminClassName=$rs['AdminClassName'];

$View->TableName=$rs['TableName'];

$View->Orders=$rs['Orders'];

$View->Optional=$rs['Optional'];

$View->Description=$rs['Description'];

}