PHP零基础遍历查询数据库结果集

使用mysql的方式访问

$link = mysql_connect("localhost","root","snowdi");

mysql_select_db("数据库");

mysql_query("set names 操作数据库字符集");

$result = mysql_query("select * from 表名");

while($msg = mysql_fetch_array($result)) {

echo  $msg['列名'] ;

}

 

使用PDO方式访问

$dsn = 'mysql:dbname=数据库名;host=localhost;port=3306';
$user = '用户名';
$password = '密码';
$this->pdo = new PDO ( $dsn, $user, $password );

$sql = "select * from 表名";
$rs = $this->pdo->query ( $sql );

foreach ( $rs as $row ) {

echo $row["列名"];
｝