CODEWITHSUNDEEP
phpmysqlconnection
WooLf
WooLf

Reputation: 57

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.

Upvotes: 0

Views: 90

Answers (3)

D Coder
D Coder

Reputation: 572

You should use mysqli because mysql is not supported anymore in PHP latest version. and you are trying to close database connection with mysqli. use like this.

mysql_close($connect);

Upvotes: 0

Edison Biba
Edison Biba

Reputation: 4413

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

Upvotes: 0

Michail M.
Michail M.

Reputation: 745

Try this code

mysql_close($connect);

Upvotes: 1

Related Questions