php与mysql常用的语句_PHP与SQL语句常用大全

$conn=mysql_connect("localhost","root","root");

mysql_select_db("db_database17",$conn);

mysql_query("set names gb2312");

?>

$sql1=mysql_query("select usernc,face,ip,email,qq from tb_user where id='".$info["userid"]."'",$conn);

$info1=mysql_fetch_array($sql1);

echo $info1["face"];

?>

action="savereg.php"

if(mysql_query("insert into tb_user(usernc,userpwd,truename,email,qq,tel,ip,address,face,regtime,sex,usertype) values('".$usernc."','".md5(trim($_POST["userpwd"]))."','".$_POST["truename"]."','".$_POST["email"]."','".$_POST["qq"]."','".$_POST["tel"]."','".$ip."','".$_POST["address"]."','".$_POST["face"]."','".date("Y-m-d H:i:s")."','".$_POST["sex"]."','0')",$conn)){

if($_SESSION["unc"]!=""){

session_unregister("unc");

}

session_register("unc");

$_SESSION["unc"]=$usernc;

echo "";

}else{

echo "";

}

?>

$sql=mysql_query("select count(*) as total from tb_leaveword ",$conn);//把查询的结果存入total中

$info=mysql_fetch_array($sql);

$total=$info[total];

if($total==0){

echo "

对不起，暂无留言！

";

}else{

if(!isset($_GET["page"]) || !is_numeric($_GET["page"])){

$page=1;

}else{

$page=intval($_GET["page"]);

}

$pagesize=3;

if($total%$pagesize==0){

$pagecount=intval($total/$pagesize);

}else{

$pagecount=ceil($total/$pagesize);

}

$sql=mysql_query("select * from tb_leaveword order by createtime desc limit ".($page-1)*$pagesize.",$pagesize ",$conn);

while($info=mysql_fetch_array($sql)){

?>

主  题：<?php echo unhtml($info["title"]);?> function openeditwindow(x){ window.open("editleaveword.php?id="+x,"newframe","top=100,left=200,width=450,height=280,menubar=no,location=no,scrollbars=no,status=no"); } $sqlu=mysql_query("select usernc from tb_user where id='".$info["userid"]."'",$conn); $infou=mysql_fetch_array($sqlu); if($infou["usernc"]==$_SESSION["unc"]){ ?> 编辑 } ?> if($_SESSION["unc"]!=""){ $sqld=mysql_query("select usertype from tb_user where usernc='".$_SESSION["unc"]."'",$conn); $infod=mysql_fetch_array($sqld); if($infod["usertype"]==1){ ?> 删除 } } ?> $info1=mysql_fetch_array($sql1); echo $info1["face"]; ?>" /><?php echo $info1["usernc"];?> <?php echo unhtml($info["content"]);?>

}

}

?>

共有留言 <?php echo $total;?> 条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount;?> 页

?page=1" class="a1">首页  ?page=<?php if($page>1) echo $page-1; else echo 1; ?>" class="a1">上一页   ?page=<?php if($page echo $page+1; else echo $pagecount; ?>