Don't be afraid of source code

Mysql • PHP

How to Connect php with mysql Database

2 Comments

1 min read

Code for mysql connection with php

<?php

define('DB_SERVER','localhost');

define('DB_USER','root');

define('DB_PASS' ,'');

define('DB_NAME', 'dbname');

$con = mysqli_connect(DB_SERVER,DB_USER,DB_PASS,DB_NAME);

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

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', 'dbname');

5. The mysqli_connect() function opens a new connection to the MySQL server.

1	$con = mysqli_connect(DB_SERVER,DB_USER,DB_PASS,DB_NAME);

About the author

Anuj kumar

I'm Anuj kumar a web developer with 4+ year experience .I write blogs in my free time. I love to learn new technologies and share with others. I founded PHPGurukul in September 2015. The main aim of this website to is provide php , jquery , mysql , phpoops and other web development tutorials. I am trying best effort to make PHPGurukul useful for every single moment spend on this website. If you think this website is useful to visit please share with your friend and buddies.

View all posts

2 Comments

How to fetch data from mysql using PHP - PHPGurukul says:

December 22, 2017 at 6:59 pm

[…] Code for mysql connection with php(config.php) […]

Reply
How to insert data into MySql using PHP - PHPGurukul says:

December 22, 2017 at 6:34 pm

[…] Code for mysql connection with php […]

Reply