Executing simple non-SELECT queries

…We have seen how to use the query method to submit select queries.…You can also use it for non-select queries but there is another…method called exact that's probably more…useful for insert, update and delete queries.…Let's take a look at both query and exact and see how they differ.…This is query_insert.php, which you can find in the…chapter 2, 02_07 folder of the exercise files.…On lines four and five is an insert statement…that adds a new entry to the names table.…

So, let's submit that using query.…And we'll restore the return value as result.…So, our database connector, db.…Then the query method, and we pass it the SQL.…And to find out what result contains we'll use var_dump and pass it result.…So, if we save that and then load the page into a browser.…The result that we get is objects PDOStatement public queryString and…then the value of the insert statement that we've just used.…

This isn't really very useful because this works only when query succeeds.…If the query fails, it returns false.…But if you do want to inspect the contents of a non-select…