How many ways to retrieve data in the result set of MYSQL using PHP?

[lindanancy]

how many ways we can retrieve data in the result set of MYSQL using PHP?

 

[hoangvu]

how many ways we can retrieve data in the result set of MYSQL using PHP?

Hi,

I think that we have more than 2 ways to retieve data using PHP
using mysql_fetch_array or mysql_fetch_assoc.
using Php array to fetch database from mysql.
can you give some good ideas than me

 

[Inquestor]

Hey,

The mysql_... extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used.

You should use prepared statements to avoid SQL Injections. See php.net mysqli for more information