I have inserted a row in a phpmyadmin table but when i run any of following commands it returns:
Showing rows 0 - 0 (1 total, Query took 0.0008 seconds.)
SELECT * FROM library_info WHERE 1
SELECT * FROM library_info
SELECT * FROM library_info WHERE 1
SELECT * FROM library_info
HOW THE DATA IS STORED IN THE TABLE
I need to use the same in my login page of php code for php page is
<?php
require('connect.inc.php');
// User is not logged in.
session_start();
if (isset($_POST['cmdlogin'])) {
$u = strip_tags($_POST['username']);
$p = strip_tags($_POST['password']);
$query = "SELECT * FROM user_details WHERE USERNAME = '$u' AND PASSWORD = '$p'";
echo $query;
$result = mysql_query($query, $conn);
if ($result) {
echo "Valid";
} else {
echo "Invalid";
}
} else {
echo "2";
include 'index.php';
}
?>
Result:
SELECT * FROM user_details WHERE USERNAME = 'Admin' and PASSWORD = 'JainLibrary'
Invalid