PHP & MySQL

1. Connect to the database

Shell:

Mysql-U $ user-P [$ database]

PHP:

$ Con = mysql_connect ($ host, $ dbauser, $ dbapassword );

2. display the database and select the database

Show databases;

Show tables;

Describe table;

Shell:

Use MySQL

PHP:

$ Db_selected = mysql_select_db ($ database, $ con );

3. query data

MySQL sub-command:

Select * from table where

PHP:

$ SQL = "select * From showlimits _ $ dtime order by r_rate DESC ";

$ Result = mysql_query ($ SQL, $ con );

Allow a host to access the database

MySQL sub-command:

Grant all privileges on *. * To 'root' @ '10. 26.170.14 'identified by 'mypassword' with grant option;
Flush privileges;

Mysql Data Type: http://www.cnblogs.com/bukudekong/archive/2011/06/27/2091590.html

Select now (); obtains the current time.

Phpadmin installation process: http://www.51099.com/comp/damy/20101012/353921.html