php连接mysql截图_数据库截图也

[php]代码库<?php

header("content-type:text/html;charset=utf-8");

//开启session

session_start();

//接收表单传递的用户名和密码

$name=$_POST['username'];

$pwd=$_POST['password'];

//通过php连接到mysql数据库

$conn=mysql_connect("localhost","","");

//选择数据库

mysql_select_db("test");

//设置客户端和连接字符集

mysql_query("set names utf8");

//通过php进行insert操作

$sqlinsert="insert into t1(username,password) values('{$name}','{$pwd}')";

//通过php进行select操作

$sqlselect="select * from t1 order by id";

//添加用户信息到数据库

mysql_query($sqlinsert);

//返回用户信息字符集

$result=mysql_query($sqlselect);

echo "

USER INFORMATION

";

echo "

---

";

echo "

//从结果中拿出一行

echo "

";

echo "

IDUSERNAMEPASSWORD";

echo "

";

while($row=mysql_fetch_assoc($result)){

echo "

";

//打印出$row这一行

echo "

{$row['id']}{$row['username']}{$row['password']}";

echo "

";

}

echo "

";

//释放连接资源

mysql_close($conn);

}

}

?>