Mysql Tutorial – connect to mysql database
Hello Friends,
If you are a learner (new) in PHP / Mysql and dont know how to make connection with mysql database from php file than Here is the easiest and error-free way to make connection with mysql database.
///*** This file will help you to connect with MYSQL using PHP - Rakshit Patel **////
$dbhostname = 'localhost'; // host name
$dbusername = 'root'; // mysql database username
$dbpassword = ''; // mysql database password$connection = mysql_connect($dbhostname, $dbusername, $dbpassword)
or die ('!! can not connect to mysql !!'); // connection with mysql
?>
You just have to change the value as per yours. e.g. Replace ‘localhost’ with your server/host name , Replace ‘root’ with mysql database username , Replace ” with mysql database password.
Note : Please save this file as mysql-connection.php . This will helpful while doing other interaction with database like.. Create database , Drop Database , Select Database , Create table , Select data , Insert data , Update data , Delete data..
Cheers !!
No related posts.
| Print article | This entry was posted by Rakshit Patel on March 8, 2009 at 5:30 am, and is filed under Mysql, PHP, Programming. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
No comments yet.
Tips to create better CSS for your website
about 1 year ago - 2 comments
If you are working as a web designer or web developer than you must interacting with CSS for creating website. Here are some tips to create better Cascading Style Sheets ( CSS ) which might help you.
Mysql Tutorial – create table in database
about 1 year ago - 5 comments
All about how to create table in Mysql database using PHP. If you are a new / Begineer in PHP/Mysql than just go through this article. You will come to know that this is the easiest and error-free way to create table in Mysql database using PHP.
Mysql Tutorial – Insert data in to table
about 1 year ago - 2 comments
All about how to insert / add data in to table using PHP. If you are a new / Begineer in PHP/Mysql than just go through this article. You will come to know that this is the easiest and error-free way to insert / add data in to table using PHP.
Mysql Tutorial – create or drop database
about 1 year ago - 4 comments
All about how to make create / drop database with mysql using PHP. If you are a new / Begineer in PHP/Mysql than just go through this article. You will come to know that this is the easiest and error-free way to create / drop database with Mysql using PHP.
Mysql Tutorial – Update data in to table
about 1 year ago - 1 comment
All about how to update / edit data in to table using PHP. If you are a new / Begineer in PHP/Mysql than just go through this article. You will come to know that this is the easiest and error-free way to update / modify data in to table using PHP.
Mysql Tutorial – Select/Retrieve data from table
about 1 year ago - No comments
All about how to select / retrive data from table using PHP. If you are a new / Begineer in PHP/Mysql than just go through this article. You will come to know that this is the easiest and error-free way to select / retrieve data from table using PHP.
Mysql Tutorial – delete data from table
about 1 year ago - No comments
All about how to delete data from table using PHP. If you are a new / Begineer in PHP/Mysql than just go through this article. You will come to know that this is the easiest and error-free way to delete data from table using PHP.
Mysql database backup from PHP file
about 1 year ago - 1 comment
All we know how to take mysql database backup from phpmyadmin but do you know how to take back-up from php file and after taking back-up , using back-up file load those data in to table by executing OUTFILE sql query from php file.
Mysql Tutorial – Upload files to MYSQL database
about 1 year ago - 6 comments
All we know that how to upload file(e.g. image , pdf) in folder using PHP. But in some web application if you need to upload files into MySQL database than here is your solution.
Mysql Tutorial – Download files from MYSQL database
about 1 year ago - 3 comments
Once we upload file in Mysql database , we need to download file from Mysql database .Here you will find the way to download files from MYSQL database.
I am 
I am Shail Patel studing in MCA and working as PHP developer(Part time) in ahmedabad. I was looking forward to share my internet ideas to people of this beautiful world. I found this site as an ideal one to do this. Now i am author of this site and i hope my articles will be helpful to you guys.