Opening Database Connection
Syntax
connection mysql_connect(server,user,passwd,new_link,client_flag);
Parameter Details
Sr.No | Parameter & Description |
---|---|
1 | server Optional − The host name running database server. If not specified then default value is localhost:3306. |
2 | user Optional − The username accessing the database. If not specified then default is the name of the user that owns the server process. |
3 | passwd Optional − The password of the user accessing the database. If not specified then default is an empty password. |
4 | new_link Optional − If a second call is made to mysql_connect() with the same arguments, no new connection will be established; instead, the identifier of the already opened connection will be returned. |
5 | client_flags Optional − A combination of the following constants −
|
Closing Database Connection
Syntax
bool mysql_close ( resource $link_identifier );
Example
<?php $dbhost = 'localhost:3036'; $dbuser = 'guest'; $dbpass = 'guest1234'; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($conn); ?>
Feel free to ask your questions where necessary and we will attend to them as soon as possible. If this tutorial was helpful to you, you can use the share button to share this tutorial.
Follow us on our various social media platforms to stay updated with our latest tutorials. You can also subscribe to our newsletter in order to get our tutorials delivered directly to your emails.
Thanks for reading and bye for now.