PHP MySQL Integration (Step 2)

Lets run MySQL Queries on PHP codes

1. Making a Connection ( step 1 )
2. This Article ( step 2 )

Prerequisites

• PHP MySQL Connection ( Described in STEP 1 Article )
• MySQL Database with few/more data ( read my get strated with MYSQL CLI Article )

Movies Table structure

PHP CODE to select all (*) from movies table

Use fetch_assoc() instead of fetch_object() to hold your SQL result in a associative Array, As shown below

http://php.net/manual/en/mysqli-result.fetch-assoc.php

References

http://php.net/manual/en/mysqli.query.php

http://php.net/manual/en/mysqli-result.fetch-object.php

http://php.net/manual/en/mysqli-result.free.php