PHP Connection Database

PHP simple connection to the database code

$host = "192.168.51.18:3306";

$root = "Login name";

$password = "Login password";

$dbname = "database name";

$connect = mysql_connect ($host, $root, $password, $dbname);

mysql_select_db ("Erp_database", $connect);//erp_database is the name of the library

if (! $connect)

{

Die (' Could not connect: '. Mysql_error ());

}

This is the query

$sql = "SELECT * from Erp_orders where erp_orders_id= ' 1054639851";

Add to

/$sql = "insert INTO .....");

$result = mysql_query ($sql);

Print_r (Mysql_fetch_row ($result));

while ($row = Mysql_fetch_array ($result))

{

echo $row [' erp_orders_id ']. "--". $row [' Buyer_name '];

echo "<br/>";

}

The mysql_connect () function is a connection database

mysql_select_db (' Library name ', mysql_connect (' Address, ' name ', ' Password ', ' Library name ')

Mysql_fetch_array () Converts the queried value to an array. When printing with Print_r () There are numbers and fields as keys, and the values are the same. The difference between mysql_fetch_row () and mysql_fetch_array () is that the key printed by the Mysql_fetch_row () function is a number with no field as the key.

2.mysql_real_escape_string into a string.

PHP Connection Database