- PHP & MySQL - Discussion
- PHP & MySQL - Useful Resources
- PHP & MySQL - Quick Guide
- PHP & MySQL - Database Info
- PHP & MySQL - Handling NULL
- PHP & MySQL - Using Joins
- PHP & MySQL - Sorting Data
- PHP & MySQL - Like Clause
- PHP & MySQL - Where Clause
- PHP & MySQL - Delete Records
- PHP & MySQL - Update Records
- PHP & MySQL - Select Records
- PHP & MySQL - Insert Records
- PHP & MySQL - Drop Tables
- PHP & MySQL - Create Tables
- PHP & MySQL - Select Database
- PHP & MySQL - Drop Database
- PHP & MySQL - Create Database
- PHP & MySQL - Connect Database
- PHP & MySQL - Environment Setup
- PHP & MySQL - Overview
- PHP & MySQL - Home
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
PHP & MySQL - Connect Database Example
PHP provides mysqp contruct or mysqp_connect() function to open a database connection. This function takes six parameters and returns a MySQL pnk identifier on success or FALSE on failure.
Syntax
$mysqp = new mysqp($host, $username, $passwd, $dbName, $port, $socket);
Sr.No. | Parameter & Description |
---|---|
1 |
$host Optional − The host name running the database server. If not specified, then the default value will be localhost:3306. |
2 |
$username Optional − The username accessing the database. If not specified, then the default will be 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 the default will be an empty password. |
4 |
$dbName Optional − database name on which query is to be performed. |
5 |
$port Optional − the port number to attempt to connect to the MySQL server.. |
6 |
$socket Optional − socket or named pipe that should be used. |
You can disconnect from the MySQL database anytime using another PHP function close().
Syntax
$mysqp->close();
Example
Try the following example to connect to a MySQL server −
Copy and paste the following example as mysql_example.php −
<html> <head> <title>Connecting MySQL Server</title> </head> <body> <?php $dbhost = localhost ; $dbuser = root ; $dbpass = root@123 ; $mysqp = new mysqp($dbhost, $dbuser, $dbpass); if($mysqp->connect_errno ) { printf("Connect failed: %s<br />", $mysqp->connect_error); exit(); } printf( Connected successfully.<br /> ); $mysqp->close(); ?> </body> </html>
Output
Access the mysql_example.php deployed on apache web server and verify the output.
Connected successfully.Advertisements