How to Run MySQL Queries with PHP?

[Rob Dizzle]

I am very used-to with the SQL. I find very easy for SQL statements that are used to obtain data from database. Now the problem I am facing is that I don't know how to Run MySQL Queries with PHP? Since I am not having much knowledge about the PHP, can someone tell me the solution for running the MySQL in an easy way. any coding related to the topic will be greatly appreciable.!!

[Solitario]

Since you know the SQL in better way, you should be knowing that when you run a select statement and receive a response, the data types of your response will be a string regardless of the data type of the column. Also you will have to make PHP interact with MySQL on your web site to deliver instant content. One thing I would like to tell you that Interacting with MySQL makes PHP a far more powerful tool. Usually most of the work done with MySQL involves pulling down data from a MySQL database. SQL queries can be used for data definition and manipulation and also used for data retrieval.

[Deabelos]

The first thing for running MySQL Queries with PHP, is to create a database table. You can use the following code for creating the database table :

CREATE TABLE friends (name VARCHAR(30), fav_color VARCHAR(30), brands VARCHAR(30));
INSERT INTO friends VALUES ( "Anna", "Red", "Adidas" ), ( "Tush", "Blue", "Reebok" ), ( "Kena", "Black", "Lewis" ), ( "Gaba", "Orange", "Koutons" )

the above code will create a table for us to work with, that has friends' names, favorite colors, and brands. The first thing we need to do in our PHP file is connect to the database. We do that using this code :

?php
// Connects to your Database
mysql_connect("your.host.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());
?> 

[kyosang]

By using the mysql_connect() function, you can open a connection to your MySQL database from PHP. Just have a look on the coding which demonstrates the same.

<?php
mysql_connect("www.address.com", "username", "password") or die(mysql_error()) ;
mysql_select_db("Database_Name") or die(mysql_error()) ;
?>

[void]

I have provided you with an example of PHP and MySQL code.

<?php
// Make a MySQL Connection
mysql_connect("localhost", "admin", "admin1") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

$result = mysql_query("SELECT * FROM demo")
or die(mysql_error());  

$row = mysql_fetch_array( $result );

echo "ID: ".$row['id'];
echo " Place: ".$row['place'];

?>