php访问mysql

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.遍历执行结果