PHP SQL Array is the set of collection of one or more similar variable under single name. Usually we have different type of values whose datatypes are same, Array is used as substitute for those variable, which have the same datatypes and store the data as element in array.
Understand with Example
This example illustrates how to create array in the operation of sql for php application. To start with the example, we create a emp_table with given required fieldnames and values. The Select query fetches all the records from table 'emp_table'.
To execute the sql query in PHP, we create sql_array.php. The sql_array.php starts with the <?php and end with ?>, which consists of con variable. The con var is used to initialized with the mysql_connect ( ) function, which accept the parameter local host, user and password in order to authenticate the connection between the PHP and MySQL. In case the specified parameter are not valid, the con fail to establish the connection between the PHP and MySQL. Otherwise the connection bridge is built successfully between the PHP and MySQL. In this example we create a $emp_name and $emp_designation of array type. In this array type variable we put the value of row and row which fetched records from database table. The echo print the record details of table 'emp_table' whose emp_id is "1" in the HTML table.
Source Code of sql_array.php