我想从表“account”中查询一行数据。由于MYSQLI使用方面我有点混乱,因此需要一些建议。我该如何做到这一点?
$link = mysqli_connect("localhost","root","","database") or die("Error " . mysqli_error($link));
$query = "SELECT * FROM account WHERE username='".$user."' AND password='".$passcode."' LIMIT 1";
$result = $link->query($query) or die("Error " . mysqli_error($link));
$numrow = $result->num_rows;
$res = $result->fetch_assoc();
查询后我想将数据复制到一个会话中,我是这样做的:
session_start();
$tableau = array($res['cod_acc'],$res['username'],$res['password']);
$_SESSION['tableau'] = $tableau;
在这之后,我该如何打印数据?
$tableau = $_SESSION['tableau'];
echo "$tableau['username']";