MySQL_面向过程访问.php_mysql 面向过程-CSDN博客

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title> MySQL_Process.php </title>
<meta charset="UTF-8">
<meta name="Keywords" content="">
<meta name="Description" content="">
</head>

<body>
首先，我先做出如下假设（也适用与方法二和方法三）
<?php
$username="root";
$userpass="";
$dbhost="127.0.0.1";
$dbdatabase="forphptest";
//下面是关键步骤：

//生成一个连接
$db_connect=@mysql_connect($dbhost,$username,$userpass) or die("Unable to connect to the MySQL!");
mysql_query('SET NAMES UTF8');
//选择一个需要操作的数据库
mysql_select_db($dbdatabase,$db_connect);

//执行MySQL语句
$result=mysql_query("SELECT id,first_name,last_name FROM testtable");

//提取数据
     // 循环取出记录
    while ($row=mysql_fetch_row($result))
    {
       var_dump($row);
    }
    // 释放资源
    mysql_free_result($result);
    // 关闭连接
    mysql_close($db_connect);
?>

</body>
</html>