List of all SQL mentioned in the code..
Value | Count | File:Line |
---|---|---|
"SELECT * FROM `user` WHERE `rno` LIKE '$uid'" | 1 |
|
"SELECT *
FROM `user` WHERE `rno` LIKE '$uid' AND `pass` LIKE '$password'" | 1 |
|
"delete from book where bid='$delete_id'" | 1 |
|
"INSERT INTO `library`.`user` (`id` ,`name` ,`rno` ,`pass` ,`gender`)VALUES (NULL , '$name', '$id', '$password1', '$sex')" | 1 |
|
"SELECT * FROM `user` WHERE `rno` LIKE '$id'" | 1 |
|
"INSERT INTO `library`.`issue` (`id`, `rollno`, `bid`, `date`, `fine`) VALUES (NULL, '$usernm', '$id', '$date', '0')" | 1 |
|
"DELETE FROM `library`.`issue` WHERE `issue`.`id` = $del" | 1 |
|
"SELECT *
FROM `issue` WHERE `rollno` = '$usernm' AND `bid` = '$id'" | 1 |
|
"UPDATE `library`.`issue` SET `status` = 'YES' WHERE id='$confirm_id'" | 1 |
|
"select * from user" | 1 |
|
"delete from user where id='$delete_id'" | 1 |
|
"SELECT * FROM `issue` WHERE `status` LIKE 'YES' " | 1 |
|
"SELECT * FROM `issue` WHERE `status` NOT LIKE 'YES' " | 1 |
|
"SELECT *
FROM `admin` WHERE `email` LIKE '$uid' AND `pass` LIKE '$password'" | 1 |
|
"INSERT INTO `library`.`book` (`bid`, `bname`, `author`, `pub`, `bran`, `no`, `bimage`) VALUES (NULL, '$name', '$author', '$pub', '$brn', '$no', '')" | 1 |
|
"delete from issue where id='$delete_id'" | 2 |
|
"select * from book" | 2 |
|
"SELECT * FROM `issue` WHERE `rollno` LIKE '$usernm'" | 3 |
|
"SELECT * FROM `book` WHERE `bid` = $bookid " | 4 |
|