- 16, May 2024
- #1
<?php
session_start();
$conection = mysqli_connect("<login for database and sql)");
if(isset($_POST["submit"]))
// Define $username and $password
$username=$_POST['username'];
$password=$_POST['password'];
// To protect from MySQL injection
$username = stripslashes($username);
$password = stripslashes($password);
//Check username and password from database
$result = mysqli_query($connection, "SELECT * FROM usertbl WHERE username='$username' and password='$password'");
$row=mysqli_fetch_array($result);
if(mysqli_num_rows($result) == 1)
{
$_SESSION['username'] = $login_user; // Initializing Session
header("<succes>"); // Redirecting To Other Page
}else
{
$error = "<failure>";
}
?>
PHP:
this doesnt work, and at this point losing my patience (after solving a lot of problems, still got a few)
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/u470788761/public_html/login.php on line 16
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/u470788761/public_html/login.php on line 17
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/u470788761/public_html/login.php on line 19 could somebody tell me what is wrong? (and if possible fix it)