Code for mysql connection with php
|
1 2 3 4 5 6 7 8 |
<?php define('DB_SERVER','localhost'); define('DB_USER','root'); define('DB_PASS' ,''); define('DB_NAME', 'demos'); $conn = mysql_connect(DB_SERVER,DB_USER,DB_PASS) or die('localhost connection problem'.mysql_error()); mysql_select_db(DB_NAME, $conn); ?> |
1. In the below we can deifne our host name. For local you can use localhost. If you want to acces the other host then put that host name or Server IP here
|
1 |
define('DB_SERVER','localhost'); |
2.This code for db user name. For local we use root. But you can create db user name whatever you want.
|
1 |
define('DB_USER','root'); |
3. Here we can define db password. For local you should leave blank.
|
1 |
define('DB_PASS' ,''); |
4.Here we define our database name
|
1 |
define('DB_NAME', 'demos'); |
5. mysql_connect is a in built function for connect to mysql Database
|
1 |
$conn = mysql_connect(DB_SERVER,DB_USER,DB_PASS) |
6.For perform operationon database, we need to select database. By using mysql_select_db
|
1 |
mysql_select_db(DB_NAME, $conn); |
Note : die use for print a message and exit the current script.
In this article
Join the Conversation