使用mysqli select时出现错误 [英] I get error when i use mysqli select

问题描述

<?php if($_POST) {  
$username = htmlspecialchars($_POST['username']);
$password = htmlspecialchars($_POST['password']);
$mysqli = new mysqli('localhost','root','','movie_posters');
$query = $mysqli->query("SELECT password FROM users WHERE username = '"$username"'");

} ?>

当我在WAMP上尝试此代码时，出现类似以下错误；此 http://i.stack.imgur.com/qcifR.jpg 我该怎么办?

When I try this code on WAMP, I get error like; this http://i.stack.imgur.com/qcifR.jpg What can I do ?

推荐答案

请勿在查询中使用单引号和双引号. 这是正确的方法:

Do not use single and double quotes in your query. This is the right way:

$query = $mysqli->query("SELECT password FROM users WHERE username = '$username'");

否则，您将不会打印$ username的值.

Otherwise, you will not print $username's value.

这篇关于使用mysqli select时出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！