<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
<body>
<?php
//登录
/*
$name=$_POST["uname"];
$password=$_POST["upassword"];
if(!empty($name)&&!empty($password)){
$coon=mysqli_connect('localhost','root','root','myphp');
$sql="select * from userinfo";
$ret=mysqli_query($coon,$sql);
$row=mysqli_fetch_array($ret);
if($name==$row["uname"]&&$password==$row["upassword"]){
echo "登录成功";
}else{
echo "用户名和密码错误";
}
}else{
echo "用户名和密码为空";
}
*/
//添加
/*
$name=$_POST["uname"];
$password=$_POST["upassword"];
if(!empty($name)&&!empty($password)){
$coon=mysqli_connect('localhost','root','root','myphp');
$sql="insert into userinfo (uname,upassword) values('{$name}','{$password}')";
$ret=mysqli_query($coon,$sql);
if(!$ret){
die('Error:' . mysql_error());
}
echo "添加一条记录";
}
mysqli_close($coon);
*/
//查询所有
/*
$coon=mysql_connect('localhost','root','root');
mysql_select_db("myphp", $coon);
$sql="select * from userinfo";
$ret=mysql_query($sql);
$dataCount=mysql_num_rows($ret);
echo $dataCount;
echo "<table>
<tr><td>姓名</><td>密码</td></tr>";
if($dataCount>0){
while($count=mysql_fetch_array($ret)){
echo "<tr><td>$count[1]</><td>$count[2]</td></tr>";
}
echo "</table>";
}
*/
//删除数据
/*
$coon=mysql_connect('localhost','root','root');
mysql_select_db("myphp",$coon);
$sql="delete from userinfo where uid=1";
$ret=mysql_query($sql);
if($ret){
echo "删除成功";
}else{
echo "删除失败";
}
*/
//修改数据
$coon=mysql_connect('localhost','root','root');
mysql_select_db("myphp",$coon);
$sql="update userinfo set uname='zhaotao' where uid=2";
$ret=mysql_query($sql);
if($ret){
echo "修改成功";
}else{
echo "修改失败";
}
?>
</body>
</html>