可以看到我们在浏览器中执行的sql查询


Its possible to see the sql query that we are doing in browser?

我有一个基本的疑问。

我有这个例子:

$sql = mysql_query("SELECT * FROM admin where id =  username='$username' and password = '$password' LIMIT 1");

可以看到这个sql命令在浏览器中做什么吗?看看它是否正确..

谢谢。

$a = "SELECT * FROM admin where id =  username='$username' and password = '$password' LIMIT 1";
echo $a;
$sql = mysql_query($a); // use mysqli instead 

如果你要打印$sql,它将打印 #resurce#4

您需要执行以下操作:

$q = "SELECT * FROM admin where id =  username='$username' and password = '$password' LIMIT 1";
print_r($q);

您可以在控制台的"网络"选项卡中看到它,或者如果您打印请求,则会在浏览器中看到它