PHP与SQL语句常用大全
本文给大家介绍PHP与SQL语句常用大全，具体代码如下所述：
<?php
$conn=mysql_connect("localhost","root","root");
mysql_select_db("db_database17",$conn);
mysql_query("setnamesgb2312");
?>
<?php
$sql1=mysql_query("selectusernc,face,ip,email,qqfromtb_userwhereid='".$info["userid"]."'",$conn);
$info1=mysql_fetch_array($sql1);
echo$info1["face"];
?>
action="savereg.php"
<inputtype="text"name="usernc"
<inputtype="text"name="userpwd"
<inputtype="text"name="truename"
<?php
if(mysql_query("insertintotb_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-dH:i:s")."','".$_POST["sex"]."','0')",$conn)){
if($_SESSION["unc"]!=""){
session_unregister("unc");
}
session_register("unc");
$_SESSION["unc"]=$usernc;
echo"<script>alert('注册成功！');history.back();</script>";
}else{
echo"<script>alert('注册失败！');history.back();</script>";
}
?>
<?php
$sql=mysql_query("selectcount(*)astotalfromtb_leaveword",$conn);//把查询的结果存入total中
$info=mysql_fetch_array($sql);
$total=$info[total];
if($total==0){
echo"<divalign=center>对不起，暂无留言！</div>";
}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*fromtb_leavewordorderbycreatetimedesclimit".($page-1)*$pagesize.",$pagesize",$conn);
while($info=mysql_fetch_array($sql)){
?>
<tablewidth="520"height="5"border="0"align="center"cellpadding="0"cellspacing="0">
<tr>
<td></td>
</tr>
</table>
<tablewidth="550"height="155"border="0"align="center"cellpadding="0"cellspacing="1"bgcolor="#FCD424">
<tr>
<tdbgcolor="#FFFFFF"valign="top"><tablewidth="550"height="24"border="0"align="center"cellpadding="0"cellspacing="0">
<tr>
<tdwidth="450"background="images/dh_back_1.gif"> 主 题：<?phpechounhtml($info["title"]);?></td>
<tdwidth="100"background="images/dh_back_1.gif"><divalign="center">
<scriptlanguage="javascript">
functionopeneditwindow(x){
window.open("editleaveword.php?id="+x,"newframe","top=100,left=200,width=450,height=280,menubar=no,location=no,scrollbars=no,status=no");
}
</script>
<?php
$sqlu=mysql_query("selectuserncfromtb_userwhereid='".$info["userid"]."'",$conn);
$infou=mysql_fetch_array($sqlu);
if($infou["usernc"]==$_SESSION["unc"]){
?>
<ahref="javascript:openeditwindow(<?phpecho$info[id];?>)"class="a1">编辑</a>
<?php
}
?>
<?php
if($_SESSION["unc"]!=""){
$sqld=mysql_query("selectusertypefromtb_userwhereusernc='".$_SESSION["unc"]."'",$conn);
$infod=mysql_fetch_array($sqld);
if($infod["usertype"]==1){
?>
<ahref="javascript:if(window.confirm('确定删除该留言信息么？')==true){window.location.href='deleteleaveword.php?id=<?phpecho$info[id];?>';}"class="a1">删除</a>
<?php
}
}
?>
</div></td>
</tr>
</table>
<tablewidth="550"height="5"border="0"align="center"cellpadding="0"cellspacing="0">
<tr>
<td></td>
</tr>
</table>
<tablewidth="550"height="120"border="0"align="center"cellpadding="0"cellspacing="0">
<tr>
<tdwidth="150"height="90"><divalign="center"><imgsrc="<?php
$sql1=mysql_query("selectusernc,face,ip,email,qqfromtb_userwhereid='".$info["userid"]."'",$conn);
$info1=mysql_fetch_array($sql1);
echo$info1["face"];
?>"/><br><?phpecho$info1["usernc"];?></div></td>
<tdwidth="10"background="images/line_down.gif"></td>
<tdwidth="390"rowspan="2"><?phpechounhtml($info["content"]);?></td>
</tr>
<tr>
<tdheight="30"><divalign="center"><imgsrc="images/email.gif"width="45"height="16"alt="<?phpecho$info1[email];?>"/><imgsrc="images/ip.gif"width="55"height="16"alt="<?phpecho$info1[ip];?>"/><imgsrc="images/qq.gif"width="45"height="16"alt="<?phpecho$info1[qq];?>"/></div></td>
<tdwidth="10"background="images/line_down.gif"></td>
</tr>
</table>
</td>
</tr>
</table>
<?php
}
}
?>
<tablewidth="550"height="25"border="0"align="center"cellpadding="0"cellspacing="0">
<tr>
<tdwidth="351"><divalign="left">共有留言 <?phpecho$total;?> 条 每页显示 <?phpecho$pagesize;?> 条 第 <?phpecho$page;?> 页/共 <?phpecho$pagecount;?> 页</div></td>
<tdwidth="199"><divalign="right"><ahref="<?phpecho$_SERVER["PHP_SELF"]?>?page=1"class="a1">首页</a> <ahref="<?phpecho$_SERVER["PHP_SELF"]?>?page=<?php
if($page>1)
echo$page-1;
else
echo1;
?>"class="a1">上一页</a> <ahref="<?phpecho$_SERVER["PHP_SELF"]?>?page=<?php
if($page<$pagecount)
echo$page+1;
else
echo$pagecount;
?>
以上所述是小编给大家介绍的PHP与SQL语句常用大全，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的，在此也非常感谢大家对毛票票网站的支持！