Mysqli_close() expects parameter 1 to be mysqli

Question

I am working on android app project and in this project, i need to connect my android app with PHP and MySQL everything is fine but I am getting an error in my user registration .php file error like this

Warning: mysqli_close() expects parameter 1 to be myself, null given in C:\xampp\htdocs\panel\UserRegistration.php on line 35

I have tried many things but the error is still there.

Here is what I have tried:

<?php
if($_SERVER['REQUEST_METHOD']=='POST'){

include 'DatabaseConfig.php';

$con = mysqli_connect($HostName,$HostUser,$HostPass,$DatabaseName);

$id_name = $_POST['id'];
$U_name = $_POST['username'];
$password = $_POST['password'];
$cnic = $_POST['cnic'];
$email = $_POST['email'];
$phone = $_POST['phone'];


$CheckSQL = "SELECT * FROM Users WHERE email='$email'";

$check = mysqli_fetch_array(mysqli_query($con,$CheckSQL));

if(isset($check)){

echo 'Email Already Exist';

}
else{ 
$Sql_Query = "INSERT INTO Users (id,username,email,password_cnic,phone) values ('$id','$U_name','$email','$password','$cnic','$phone')";

if(mysqli_query($con,$Sql_Query))
{
echo 'Registration Successfully';
}
}


?>

That's all very heartwarming. But the code as posted here does not even contain `mysqli_close`. (Not that it makes much sense to use it anyway). — mario, Jan 01 '18 at 16:27

score 0 · Answer 1 · answered Jan 01 '18 at 12:54

0

https://secure.php.net/manual/fr/mysqli.close.php

You must do : mysqli_close($con); :)

answered Jan 01 '18 at 12:54

Ben

99
1
4

i have done this but still am getting the same error Warning: mysqli_close() expects parameter 1 to be myself, null given in C:\xampp\htdocs\panel\UserRegistration.php on line 35 – Muhammad Sajid Lakha Jan 01 '18 at 12:59

score 0 · Answer 2 · answered Jan 01 '18 at 13:01

0

Pass Connection object in mysqli_close() function.

Like :

mysqli_close($con);

answered Jan 01 '18 at 13:01

Milan Akabari

124
6

Mysqli_close() expects parameter 1 to be mysqli

2 Answers2