دوال التعامل مع قاعدة بيانات My SQL
توجد مجموعة من الدوال التي تساعد على إجراء العمليات المختلفة مع قاعدة بيانات MySQL نعرضها كما جاءت في الكتيب الخاص بلغة PHP
| Php mysql functions | |
| Php: indicates the earlisest version of php that supports the function. | |
| Description | Function |
| Returns the number of affected 3 rows in the previous mysql operation | mysql_ affected _ rows ( ) |
| Deprecated. Changes the user of 3 the current mysql connection | mysql_ change_ user () |
| Returns the name of the character 4 set for the current connection | mysql_ client _ encoding ( ) |
| Closes a non – persistent Mysql 3 connection | mysql_ close ( ) |
| Opens a non – persistent Mysql 3 connection | mysql_ connect ( ) |
| Deprecated. Creates a new Mysql database. Use mysql_ query ( ) instead | mysql_ create _ db ( ) |
| Moves the record pointer 3 | mysql_ data _ seek ( ) |
| Returns a database name from a 3 call to mysql_ list _ dbs ( ) | mysql_ db _ name ( ) |
| Deprecated. Sends a Mysql 3 query. Use mysql_ select _ db ( ) and mysql_ query ( ) instead | mysql_ db _ query ( ) |
| Deprecated. Deletes a Mysql 3 database. Use mysql_ query ( ) instead | mysql_ drop _ db ( ) |
| Returns the error number of the 3 last Mysql operation | mysql_ errno ( ) |
| Returns the error description of 3 the last Mysql operation | mysql_ error ( ) |
| Deprecated. Escapes a string for 4 use in a mysql _ query. Use mysql _ real_ escape _ string ( ) | mysql_ escape _ string ( ) |
| Returns a row a recordset as 3 an associative array and / or a numeric array | mysql_ fetch _ array ( ) |
| Returns column info from a 3 recordset as an object | mysql_ fetch _ field ( ) |
| Returns the length of the contents 3 of each field in a result row | mysql_ fetch _ lengths ( ) |
| Returns a row from a recordset as 3 an object | mysql_ fetch _ object ( ) |
| Returns a row from a recordset as 3 a numeric array | mysql_ fetch _ row ( ) |
| Returns the flags associated with 3 afield in a recorset | mysql_ field _ flags ( ) |
| Returns the mazimum length of a 3 field in a recordset | mysql_ field _ len ( ) |
| Returns the name of a field in a 3 recordset | mysql_ field _ name ( ) |
| Moves the result pointer to a specified field | mysql_ field _ seek ( ) |
| Returns the name of the table the 3 specified field is in | mysql_ field _ table ( ) |
| Returns the type of a field in a 3 recordset | mysql_ field _ type ( ) |
| Free result memory 3 | mysql_ free _ result ( ) |
| Returns Mysql client info 4 | mysql_ get _ client _ info ( ) |
| Returns Mysql host info 4 | mysql_ get _ host_ info ( ) |
| Returns Mysql protocol info 4 | mysql_ get _ proto _ info ( ) |
| Returns Mysql server info 4 | mysql_ get _ server _ info ( ) |
| Returns information about the 4 last query | mysql_ info ( ) |
| Returns the 3 AUTO _ INCREMENT ID generated from the previous INSERT operation | mysql_ insert _ id ( ) |
| Lists available databases on a 3 Mysql server | mysql_ list _ dbs ( ) |
| Deprecated. Lists Mysql table 3 field. Use mysql_ query ( ) instead | mysql_ list _ fields ( ) |
| Lists MySql processes 4 | mysql_ list _ processes ( ) |
| Deprecated. Lists tables in a 3 MySql database. Use mysql_ query ( ) instead | mysql_ list _ tables ( ) |
| Returns the number of fields in a 3 recordset | mysql_ num _ rows ( ) |
| Returns the number of rows in a 3 recordset | mysql_ num _ rows ( ) |
| Opens a persistent Mysql 3 connection | mysql_ pconnect ( ) |
| Pings a server connection or 4 reconnects if there is no connection | mysql_ ping ( ) |
| Executes a query on a Mysql 3 database | mysql_ query ( ) |
| Escapes a string for use in SQL 4 statements | mysql_ real _ escape _ string ( ) |
| Returns the value of a field in a 3 recordset | mysql_ result ( ) |
| Sets the active Mysql database 3 | mysql_ select_ db ( ) |
| Returns the current system status 4 of the Mysql server | mysql_ stat ( ) |
| Deprecated. Returns the table 3 name of field. Use mysql_ query ( ) instead | mysql_ tablename ( ) |
| Returns the current thread Id 4 | mysql_ thread_ id ( ) |
| Executes a query on a mysql 4 database (without fetching/ buffering the result) | mysql_ unbuffered_ query ( ) |
