PHP与SQL语句常用大全 - 快网idc优惠网

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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

<?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">编辑</a>

<?php

}

?>

 

<?php

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){

?>

<a href=

"javascript:if(window.confirm('确定删除该留言信息么？')==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语句常用大全，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的，在此也非常感谢大家对快网idc网站的支持！

原文链接：http://www.cnblogs.com/cc18/archive/2016/12/10/6155197.html