Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Thread Tools Search this Thread
Old 17-07-2011
Join Date: Jun 2009
Posts: 230
How to connect PHP to mySQL Database

PHP syntax is very similar to the syntax of C or Perl. People familiar with programming will be able to very quickly begin to write programs in PHP. In this language there is no strict data typing and there is no need for action on allocation / freeing memory. MySQL - compact multi-threaded database server. MySQL is characterized by a high speed, stability and ease of use. MySQL is the ideal solution for small and medium-sized applications. MySQL supports a query language in the ANSI SQL 92, and in addition has a set of extensions to this standard are not found in any other database. MySQL is really a very fast server.

Retrieving Records from a MySQL database using PHP is one of the most common tasks is presented every web developer.
  • First Create a Database. To save, read, modify, or delete data, you must first establish a connection to MySQL as described above via a file-like connexion.php.
  • To get the data from MySQL need a connection (a form of link or communication), which will allow us to extract data from it. This PHP has a number of unique features to interact with mysql . Then to connect use the function mysql_connect mysql_select_db which then allows us to define which database server you want to connect.
  • Now the other part is obtaining records from the database. Once you had made a connection to extract the data, you will need to send SQL queries using mysql_query function. By this you can also get the total number of records returned by your query.
  • Behind these two terms are hidden concepts. The dataset is a direct response to a query in MySQL. The dataset contains 0, 1, 2 ... No records. Each record is a DataRow as the data line. In fact, when asked MySQL, it returns a block of responses (dataset) that we will peel with php (DataRow DataRow by).
  • To use PHP via this line, we use the command mysql_fetch_array ($ dataset): This command creates an associative array where each key corresponds to each column of the table, and each value for each value read from the dataset.
  • print_r will display the source code.
  • Remember that array keys are case-sensitive, if the column is called MySQL Manufacturer or producer, this is not the same. It only remains to show the information required in PHP (sample code in a html page named pieces.php).
Connection to Server
  • To send queries to MySQL, you must first have access, that is to say, have been registered by the administrator of the mysql database.
  • It should then connect to the server using the mysql_connect (all functions php / mysql start with mysql_).
  • This function calls as arguments the name of the host machine where the MySQL server, the name of the authorized user and the password for that user.
  • This will attempt to connect to the MySQL database server which runs on the host INFRES under the username.
  • It is obvious that in practice, the password should never be placed in a plain php script: the arguments of this function will be entered in the first place by a form whose implementation will start by trying the log with the information provided by the user. Once the connection is established, you can use the manipulation of databases.
Reply With Quote
Old 17-07-2011
Join Date: Mar 2010
Posts: 144
Re: How to connect PHP to mySQL Databse

The base function to connect database is mysql_connect (). This function accepts three input arguments: the host name, user name, password. The function returns a link that must store messages and nicknames in a variable for use later. To close the connection, use mysql_close (). This function takes as argument the variable connection to close. In the same way to connect database - mysql_select_db (). This function takes as argument the name of a database and a variable returned by mysql_connect () in our example $ connection. If this variable is not provided, then the function utlise the last established connection.
Reply With Quote
Old 17-07-2011
Join Date: May 2009
Posts: 503
Re: How to connect PHP to mySQL Databse

I use a different method on my system to integrate both. The first thing we need is to get the DLLs to connect to a SQL Server, by default these DLLs in the package will not install automatically, so you're down, if you have not already, the packet with the complete installation. You must tell PHP to have a new library and that should be used. So edit the php.ini in Notepad, usually php.ini is in C: \ WINNT. Find the line that says extension_dir = and modify it to point to the directory where we copied the DLL. With This tells PHP where the extension DLL. Now find the line extension = php_mssql.dll and modify it by removing the principle. Save the file php.ini and you're done.
Reply With Quote

  TechArena Community > Software > Tips & Tweaks
Tags: , , , , , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads for: "How to connect PHP to mySQL Database"
Thread Thread Starter Forum Replies Last Post
Connecting C# with MySQL database Quattro Software Development 5 05-03-2010 10:13 PM
Need MySQL database directory Osman84 Software Development 4 27-02-2010 05:18 AM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
How to Connect to MySQL database on my website? Zombi Software Development 3 24-09-2009 01:23 PM
How to Connect MySQL database from PHP Booth Software Development 3 21-01-2009 09:12 PM

All times are GMT +5.5. The time now is 02:35 PM.