PHP close MySQL connection

Question

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.

Mixing mysql with mysqli!!

Saty
– Saty

2016-08-17 12:43:53 +00:00
Commented Aug 17, 2016 at 12:43 — Saty
– Saty, Commented Aug 17, 2016 at 12:43
Additionally, using $connect and $connection?

t.h3ads
– t.h3ads

2016-08-17 12:45:05 +00:00
Commented Aug 17, 2016 at 12:45 — t.h3ads
– t.h3ads, Commented Aug 17, 2016 at 12:45
what is the error message?

wau
– wau

2016-08-17 13:13:54 +00:00
Commented Aug 17, 2016 at 13:13 — wau
– wau, Commented Aug 17, 2016 at 13:13

Michail M. · Accepted Answer · 2016-08-17 12:45:21Z

1

Try this code

mysql_close($connect);

answered Aug 17, 2016 at 12:45

Michail M.

7555 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Edison Biba · Accepted Answer · 2016-08-17 12:50:25Z

0

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

edited Aug 17, 2016 at 12:50

answered Aug 17, 2016 at 12:45

Edison Biba

4,4833 gold badges20 silver badges36 bronze badges

Comments

D Coder · Accepted Answer · 2016-08-17 13:00:40Z

0

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);

answered Aug 17, 2016 at 13:00

D Coder

5724 silver badges16 bronze badges

Collectives™ on Stack Overflow

PHP close MySQL connection

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related