PHP 将 mysql_connection 转换为 PDO

Question

我正在尝试将使用 mysql_connect 的代码转换为 pdo，但是我不知道这之后要做什么。应该放置“mysql_result”。

$query = "select * from tbl_usuarios where login = '$cliente_username' and senha = '$cliente_password'";
$result = $conexao->query($query);
$number = $result->fetch();

if ($number==0) { ?><script>alert('Dados incorretos! Tente novamente.');</script>
<?php
    exit;
} else {
    $_SESSION['usuario_id'] = mysql_result($result,0,'id');
    $_SESSION['usuario_nome'] = mysql_result($result,0,'nome');
    ?><script>document.location = '../principal.php'</script><?php
}
mysql_close($conexao);  

} 
?>

Answer 1

mysql_result($result,0,'id')

成为

$number->id

和

mysql_result($result,0,'nome')

成为

$number->nome

也许你应该为你的查询添加一个限制 1:

$query = "select * from tbl_usuarios where login = '$cliente_username' and senha = '$cliente_password' limit 1";