WooLf WooLf - 3 months ago 26
MySQL Question

PHP close MySQL connection

I have a file config.php

<?php

$dbhost = "*****";
$dbname = "*****";
$dbuser = "*****";
$dbpassword = "*****";

$connect = mysql_connect("$dbhost","$dbuser","$dbpassword");
mysql_select_db("$dbname",$connect);

mysql_query("SET NAMES 'utf-8'");
?>


And i have file insert.php with inserting form values into MySql.
At the end of this file i am trying to close database connection with:

mysql_close($connection);


but it gives me error, please advise.

P.S: I am very new to php so please don't blame.

Answer

You are using mysqli_close($connect) instead of mysql_close($connect);

$connect = mysql_connect("$dbhost","$dbuser","$dbpassword");
mysql_close($connect);

I would suggest you to move your code to mysqli because mysql is not supported anymore in php7