<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if($lianjie)
{
mysql_select_db("xiaolie");
if(!$_GET)
{
$xuanbiao = "select * from zhuce";
$fasong = mysql_query($xuanbiao) or die(mysql_error());
echo "<table border=1>
<tr>
<td>编号</td>
<td>用户名称</td>
<td>性别</td>
<td>年龄</td>
<td>注册时间</td>
<td>操作</td>
</tr>";
while($nr=mysql_fetch_array($fasong))
{
echo "<tr>
<td>".$nr["id"]."</td>
<td>".$nr["name"]."</td>
<td>".$nr["xingbie"]."</td>
<td>".$nr["nianling"]."</td>
<td>".$nr["zc_shijian"]."</td>
<td><a href=gx_my.php?id=".$nr["id"].">编辑</a></td>
</tr>";
}
echo "</table>";
}
else
{
if(!$_POST)
{
$xianid = "select * from zhuce where id=".$_GET["id"];
$fasong = mysql_query($xianid) or die(mysql_error());
$nr = mysql_fetch_array($fasong);
?>
<form method=post action="gx_my.php?id=<?php echo $_GET["id"];?>">
<?php
echo $nr["id"]."<br>";
?>
<input type="hidden" name="id" value=<?php echo $nr["id"];?>>
姓名<input type="text" name="name" value=<?php echo $nr["name"];?>><br>
性别<input type="text" name="xingbie" value=<?php echo $nr["xingbie"];?>><br>
年龄<input type="text" name="nianling" value=<?php echo $nr["nianling"];?>><br>
注册时间<input type="text" name="zc_shijian" value=<?php echo $nr["zc_shijian"];?>><br>
<input type="submit" name="ok" value="提交">
</form>
<?php
}
else
{
$gx = "update zhuce set name='".$_POST["name"]."',xingbie='".$_POST["xingbie"]."',nianling='".$_POST["nianling"]."',zc_shijian='".$_POST["zc_shijian"]."' where id='".$_POST["id"]."'";
$fasong = mysql_query($gx);
if($fasong){
echo "记录已经成功修改<br><a href=gx_my.php>继续修改记录</a>";}
else{
echo "记录修改失败<br><a href=gx_my.php?id=".$_POST["id"].">返回</a>"; }
}
}
}
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if($lianjie)
{
mysql_select_db("xiaolie");
if(!@$_GET["id"])
{
$jieguo = "select * from zhuce";
$fasong = mysql_query($jieguo) or die(mysql_error());
echo "<table border=1>
<tr>
<td>编号</td>
<td>用户名称</td>
<td>性别</td>
<td>年龄</td>
<td>注册时间</td>
<td>详细信息</td>
</tr>";
while($nr=mysql_fetch_array($fasong))
{
echo "<tr>
<td>".$nr["id"]."</td>
<td>".$nr["name"]."</td>
<td>".$nr["xingbie"]."</td>
<td>".$nr["nianling"]."</td>
<td>".$nr["zc_shijian"]."</td>
<td><a href=ck_my.php?id=".$nr["id"].">查看</a></td>
</tr>";
}
echo "</table>";
}
else
{
$jieguo = "select * from zhuce where id=".$_GET["id"];
$fasong = mysql_query($jieguo);
$nr = mysql_fetch_array($fasong);
echo "编号:".$nr["id"]."<br>用户名称:".$nr["name"]."<br>性别:".$nr["xingbie"]."<br>年龄:".$nr["nianling"]."<br>注册时间:".$nr["zc_shijian"]."<br>";
echo "<br><br><a href=ck_my.php>继续查询</a>";
}
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if($lianjie)
{
mysql_select_db("xiaolie");
if($_GET)
{
$a = $_GET["id"];
$sc = "delete from zhuce where id=$a";
$fasong = mysql_query($sc) or die(mysql_error());
if($fasong)
echo "记录已经成功删除<a href=sc_my.php>继续删除记录</a>";
else
echo "删除记录失败<br><a href=sc_my.php>返回</a>";
}
else
{
$fasong = mysql_query("select * from zhuce") or die(mysql_error());
echo "<table border=1>
<tr>
<td>编号</td>
<td>用户名称</td>
<td>性别</td>
<td>年龄</td>
<td>注册时间</td>
<td>操作</td>
</tr>";
while($nr = mysql_fetch_array($fasong))
{
echo "<tr>
<td>".$nr["id"]."</td>
<td>".$nr["name"]."</td>
<td>".$nr["xingbie"]."</td>
<td>".$nr["nianling"]."</td>
<td>".$nr["zc_shijian"]."</td>
<td><a href=sc_my.php?id=".$nr["id"].">删除</a></td>
</tr>";
}
echo "</table>";
}
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
$lianjie = mysql_connect("localhost","root","xiaolie") or die("连接失败");
mysql_query("set names utf8");
if(@$_POST["ok"])
{
mysql_select_db("xiaolie");
//插入数据
$shuju = " insert into hao (name,neirong,shijian) values ('".$_POST["name"]."','".$_POST["neirong"]."','".date("Y-m-d H:m:s")."')";
$fasong = mysql_query($shuju) or die(mysql_error());
if($fasong)
{
header("location:/a2/ly.php");
}
else
{
echo "内容发表失败<br><a href=fb_my.php>返回</a>";
}
}
else
{
/* mysql_select_db("xiaolie");
//发送查询
$fasong = mysql_query("select * from hao") or die(mysql_error());
while($nr = mysql_fetch_array($fasong))
{
echo "<table border=1>
<tr>
<td width='60'>第 ".$nr["id"]." 楼</td>
<td width='140'>发表用户:".$nr["name"]."</td>
<td width='230'>发表时间:".$nr["shijian"]."</td>
</tr>
<tr><td colspan='3' width='430'>".$nr["neirong"]."</td></tr>
</table>";
}
*/
?>
<form method=post action=fb_my.php>
姓名<input type=text name="name" /><br>
发表<br><textarea name="neirong" cols="50" rows="5"></textarea><br>
<input type=submit name="ok" value="好的" />
</form>
<?php
}
?>
以了计数器的漂亮,我们经常会用图片做统计的数字1,2到10我们只要做0,9的图片数字,然后用下面的方法就来做出漂亮的计数器出来哦。 $fp = fopen ($countfile, "r"); //以只读模式打开文件
$array_count = 1; //定义一个表示数组元素位置的变量,下面要用
while (! feof($fp)) {
$current_number = fgetc($fp);
$counter_array[$array_count] = $current_number;
$array_elements = count ($counter_array);
$array_count = $array_count + 1;
}
//显示代码
echo ("<table border="0" height="5" align="left"><tr><td align="center">欢迎您,第");
for ($array_id = 1;$array_id < $array_elements; ++ $array_id) {
echo ("<img" width=100% src="./img/$counter_array[$array_id].gif" align=absmiddle>");
}