Everthing About Internet

Technically there is no “fetch matrix” according to MySQL. PHP is a feature that interacts with a MySQL database. MySQL databases are not very useful if the application code can not have easy access to the data returned. PHP offers some features easy to get into the data returned by .

of MySQL database query MySQL

Open a connection to MySQL. It is a simple call to mysql_connect, which returns a resource for MySQL. Store this resource in one variable. Example: $ mysql = mysql_connect ( “localhost”, “my_user”, “my_password “);

Select a database. This requires a call to mysql_shutdown. Example: mysql_shutdown ($ mysql, “customers_db “);

a form of consultation. Often, the questions are not trivial, as you may have several variables are expanding in a very long query string. It’s best to format the chain outside of the call to mysql_query. It’s best to use sprintf mysql_escape_string and to prevent such mistakes as failures or query data compromises. In this example, the name and variable $ $ ph_number have come from a web form. Example: $ query = sprintf ( “SELECT * FROM Customers WHERE name = ‘% s’ AND ph_numbers =’% s’”, mysql_escape_string ($ name), mysql_escape_string ($ ph_number) );

Send query . This is done with the role mysql_query. It takes an action for MySQL and a query string as an argument and returns a result handle MySQL. In this drive, you can get the rows one by one. Should not the query, mysql_query will return FALSE and you will be able to access an error by calling the function mysql_error. Example: $ result = mysql_query ($ mysql, $ query); if ($ result) (die ( “Invalid query:”. Mysql_error () );}

Bring the result as a numerical matrix

Bringing the result as a numerical matrix with mysql_fetch_array. The columns of the result will be in order, the first column with a rate of 0 .

call this function several times to get the next row . If there are no more rows remaining in the outcome of resources, are mysql_fetch_array return false. Example: $ row = mysql_fetch_array ($ result );

Bring the result as an associative array

Bring the result as an associative array with mysql_fetch_assoc. This function returns an associative array with the keys equal to the column names. For example, if you wanted to access the name field in a row, you simply need to call $ row [ "name" ].

Realize that this will not change if the number or the order of columns in the table changes through an SQL ALTER. Like all other functions mysql_fetch_, * you you can call repeatedly to get more rows of the result. Then return false if there are no more rows in the result. Example: $ row = mysql_fetch_assoc ($ result );

Featured Links: