Getting Started: combining PHP with MYSQL

, Connect to the database

<? Php

$ Dbhost = localhost;
$ Dbuser = root; // your mysql user name
$ Dbpass = 123456; // your mysql password
$ Dbname = data; // your mysql Database Name

// Connect to the local database
$ GLOBALS ["conn"] = mysql_connect ($ dbhost, $ dbuser, $ dbpass );

// Open the database
Mysql_select_db ($ dbname, $ GLOBALS ["conn"]);

?>

2. Read a field value from the database.

<? Php

// Read a column of data
$ SQL = "select * from ec_admin ";
$ Result = mysql_query ($ SQL, $ GLOBALS ["conn"]);

Printf ("UserName: % s <br>", mysql_result ($ result, 3, "UserName "));
Printf ("Password: % s <br>", mysql_result ($ result, 3, "UserPass "));

?>

3. Insert a data entry

<? Php

$ SQL = "insert into ec_admin (UserName, UserPass) values (liugongxun2, jakemary2 )";
$ Result = mysql_query ($ SQL, $ GLOBALS ["conn"]) or die (mysql_error ());

?>

4. while Loop

<? Php

$ SQL = "select * from ec_admin ";
$ Result = mysql_query ($ SQL, $ GLOBALS ["conn"]);
While ($ myrow = mysql_fetch_row ($ result ))
{
Printf ("username % s password <br/>", $ myrow [1], $ myrow [2]);
}

?>

5. do while LOOP

<? Php

$ SQL = "select * from ec_admin ";
$ Result = mysql_query ($ SQL, $ GLOBALS ["conn"]);
If ($ myrow = mysql_fetch_array ($ result ))
{
Do
{
Printf ("UserName % s password <br/>", $ myrow ["UserName"], $ myrow ["UserPass"]);
} While ($ myrow = mysql_fetch_array ($ result ));
}
?>

6. Determine whether the form is submitted.

<? Php

If ($ submit)

{}

?>