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

Question

i have a basic doubt.

i have this example:

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

Its possible to see what this sql command is doing in the browser? To see if it is correct..

Thanks.

Isn't the purpose of doing a query to *see* some result after-all? — samayo, Sep 27 '13 at 16:14
Just assign it to a variable first, and then pass the variable into `mysql_query()` — andrewsi, Sep 27 '13 at 16:15
You could do `var_dump($sql);` which will probably give you an object statement only. — samayo, Sep 27 '13 at 16:15
You are using a deprecated library (mysql_*). You should be using either PDO with Mysql or Mysqli — gview, Sep 27 '13 at 16:16

score 1 · Answer 1 · answered Sep 27 '13 at 16:18

1

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

answered Sep 27 '13 at 16:18

Biswajit Maji

869
13
23

score 0 · Answer 2 · answered Sep 27 '13 at 16:18

if you will print the $sql it will print #resurce #4

you need to do:

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

print_r($q);

and you see it in the network tab on the console or in the browser if you print your request

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

2 Answers2