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:
Post a Comment