php mysql升级出错,升级了PHP，用mysqli之后，mysql_result出错，请问下句怎么改。

建议采用pdo形式链接数据库

示例如下：

//1.连接数据库

try {

$pdo = new PDO("mysql:host=localhost;dbname=school;", "root", MYSQLPASSWORD);

} catch (PDOException $e) {

die("数据库连接失败" . $e->getMessage());

}

//2.解决中文乱码问题

$pdo->query("SET NAMES 'UTF8'");

//3.执行sql语句，并实现解析和遍历

$sql = "SELECT * FROM stu ";

foreach ($pdo->query($sql) as $row) {

echo "

";

echo "

{$row['name']}";

echo "

{$row['number']}";

$sex = $row['sex'] == 'w' ?  '女' : '男';

echo "

{$sex}";

echo "

{$row['age']}";

echo "

{$row['cate']}";

echo "

{$row['class']}";

echo "

{$row['major']}";

echo "

删除

修改

";

echo "

";

}

?>