Basic PHP MYSQL Functions

[linux tech]

Following are some <a href="http://www.bodhosting.com/ " target="_blank" title=" PHP MYSQL " style="color:#000000;text-decoration:none;">PHP MYSQL</a> functions -

a)mysql_connect(MySQL server name,username,password) - opens a connection to a MySQL server.

b)mysql_select_db(database name,connection identifier) - selects a database residing on the MySQL server. The database name parameter referes to an active database on the MySQL server that was opened with the mysql_connect function. The connection identifier is a reference to the current MySQL connection.

c)mysql_query(sql query) - sends a query to the currently active database.

d)mysql_fetch_array(resourse result) - Returns an array that corresponds to the fetched row and moves the internal data pointer ahead.

e)mysql_affected_rows(resourse result) - determines the number of rows affected by the previous SQL operation.

f) mysql_close(link_identifier) - closes MySQL connection.

[Sean]

Thanks Tech

Informative basics

[deepak11627]

hi,
PHP supports so many mysql functions. some of them are as follows
mysql_connect()
mysql_select_db()
mysql_query()
mysql_fetch_assoc()
and list is long.

Thanks
CoreIT Developers
Picspeaks | Home