Connecting to MySQL through PHP...

Use the following outline to connect and begin querying the MySQL server from within your PHP scripts.

  1. Connect to the MySQL server
    Use the following statement to connect to the database server. Substitute the username, and
    password for ones who have created in the MyAdmin interface and have given adequate
    permissions to this database.
    MYSQL_CONNECT('localhost','USERNAME','PASSWORD');
  2. Select Your Database
    Use the following statement to select the database you wish to connect to. Make sure you
    substitute the example with your database name.
    @mysql_select_db("DATABASENAME");
  3. Executing A Query
    You are now ready to execute your queries. Remember that the databases and users used must be created in the MyAdmin interface in your CP. Most problems that arise with your scripts will be due to incorrect permission settings.
  • 1 Χρήστες που βρήκαν αυτό χρήσιμο
Ήταν χρήσιμη αυτήν την απάντηση;

Related Articles

Can I connect to MySQL remotely?

Yes, you can connect to your MySQL database remotely. Remember to enter the IP address or...

How do I backup & restore a MySQL database using phpMyAdmin?

How to back up a mySQL database using phpMyAdmin: You can backup your database using the...

What is the number of maximum connections allowed to a single MySQL database?

We allow up to 50 simultaneous connections per MySQL user, and up to 1500 simultaneous...

How to I create a MySQL Database?

To create a mysql database, log into your control panel and select the 'MySQL Databases' link....

What version of mySQL are you currently running?

The latest stable build of mySQL. Generally we do not include the version information on the...