Tuesday, February 10, 2009

PHP and MYSQL basic syntax

To connect server:
mysql_connect("server_name","user","password");

To connect to the database:
mysql_select_db("database_name");

To query SQL :
mysql_query("SQL_SYNTAX");

To list data from table :
mysql_fetch_array("result_query");
mysq_fetch_assoc("result_query");

To get a result row as an enumerated array:

mysql_fetch_row("reult_query");

To close connection to the server:
mysql_close("connect_information or source link");

To view error syntax:
mysql_error();

To escapes a string for use in a mysql_query:
mysql_escape_string ();

To get number of rows in result:

msql_num_rows ( resource query_identifier )

No comments: