PHP与SQL语句常用大全

　　本文给大家介绍PHP与SQL语句常用大全，具体代码如下所述：

　　 <?php $conn=mysql_connect(localhost,root,root); mysql_select_db(db_database17,$conn); mysql_query(set names gb2312); ?> <?php $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 <input type=text name=usernc <input type=text name=userpwd <input type=text name=truename <?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 <script>alert(注册成功！);history.back();</script>; }else{ echo <script>alert(注册失败！);history.back();</script>; } ?> <?php $sql=mysql_query(select count(*) as total from tb_leaveword ,$conn);//把查询的结果存入total中 $info=mysql_fetch_array($sql); $total=$info[total]; if($total==0){ echo <div align=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 * from tb_leaveword order by createtime desc limit .($page-1)*$pagesize.,$pagesize ,$conn); while($info=mysql_fetch_array($sql)){ ?> <table width=520 height=5 border=0 align=center cellpadding=0 cellspacing=0> <tr> <td></td> </tr> </table> <table width=550 height=155 border=0 align=center cellpadding=0 cellspacing=1 bgcolor=#FCD424> <tr> <td bgcolor=#FFFFFF valign=top><table width=550 height=24 border=0 align=center cellpadding=0 cellspacing=0> <tr> <td width=450 background=images/dh_back_1.gif>主题：<?php echo unhtml($info[title]);?></td> <td width=100 background=images/dh_back_1.gif><div align=center> <script language=javascript> 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); } </script> <?php $sqlu=mysql_query(select usernc from tb_user where id=.$info[userid].,$conn); $infou=mysql_fetch_array($sqlu); if($infou[usernc]==$_SESSION[unc]){ ?> <a href=javascript:openeditwindow(<?php echo $info[id];?>) class=a1>编辑firm(确定删除该留言信息么？)==true){window.location.href=deleteleaveword.php?id=<?php echo $info[id];?>;} class=a1>删除</a> <?php } } ?> </div></td> </tr> </table> <table width=550 height=5 border=0 align=center cellpadding=0 cellspacing=0> <tr> <td></td> </tr> </table> <table width=550 height=120 border=0 align=center cellpadding=0 cellspacing=0> <tr> <td width=150 height=90><div align=center><img src=<?php $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]; ?> /><br><?php echo $info1[usernc];?></div></td> <td width=10 background=images/line_down.gif></td> <td width=390 rowspan=2><?php echo unhtml($info[content]);?></td> </tr> <tr> <td height=30><div align=center><img src=images/email.gif width=45 height=16 alt=<?php echo $info1[email];?>/><img src=images/ip.gif width=55 height=16 alt=<?php echo $info1[ip];?>/><img src=images/qq.gif width=45 height=16 alt=<?php echo $info1[qq];?>/></div></td> <td width=10 background=images/line_down.gif></td> </tr> </table> </td> </tr> </table> <?php } } ?> <table width=550 height=25 border=0 align=center cellpadding=0 cellspacing=0> <tr> <td width=351><div align=left>共有留言<?php echo $total;?>条每页显示<?php echo $pagesize;?>条第<?php echo $page;?>页/共<?php echo $pagecount;?>页</div></td> <td width=199><div align=right><a href=<?php echo $_SERVER[PHP_SELF]?>?page=1 class=a1>首页</a><a href=<?php echo $_SERVER[PHP_SELF]?>?page=<?php if($page>1) echo $page-1; else echo 1; ?> class=a1>上一页</a><a href=<?php echo $_SERVER[PHP_SELF]?>?page=<?php if($page<$pagecount) echo $page+1; else echo $pagecount; ?>

　　以上所述是小编给大家介绍的PHP与SQL语句常用大全，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的，在此也非常感谢大家对脚本之家网站的支持！