PHP Questions Home

Categories

Arrays
Files
Forms
Functions
Images
MySQL
Numbers
Others
Strings
Website


PHP Functions

PHP Functions


More PHP

Top Questions
Ask a Question

How do I connect to mySQL from PHP?


The first thing you will need to do when using PHP and mySQL is to connect to the mySQL database from PHP.

Luckily there are a couple of functions in PHP that make it easy. Once you get it working you can just copy and paste at the top of each script that requires the database or use a template or include file of some sort to include the details.

<?php
$db 
mysql_connect("HOST""USERNAME""PASSWORD");
mysql_select_db("DATABASE_NAME",$db);
?>


And that's all there is to it - use your username, host, password and database name and this will establish the connection.

The most common problem is that you get the password wrong so double check it's right if you get errors.



More mysql PHP Questions

How do I return the date with mySQL?
How do I insert the date into my table?
How do I delete a row from a table?
How do I order the results of my query?
How do I limit the number of rows returned?