1.安装php对数据库访问的支持
yum install php-mysql
2.连接数据库:
$con = mysql_connect("server","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}else{
echo "connect sucessful\n";
}
3.选择database
mysql_select_db("mr_db", $con);
4.创建表
$sql = "CREATE TABLE media_list
(
Name varchar(40),
size varchar(15),
is_online int
)";
mysql_query($sql,$con);
5.执行查询
$result = mysql_query("SELECT * FROM media_list") or die("no result");
6.遍历执行结果