concrete5 Cookbook by Unknown

Author:Unknown
Language: eng
Format: epub
Publisher: Packt Publishing

There's more...

If you are performing a query where you are only selecting one column and expect one result (for instance, a COUNT query) you can use the getOne method to get the exact value that you need as shown in the following code snippet:

$count = $db->getOne('SELECT COUNT(*) FROM Users');

See also

The Writing data to the database recipe

Writing data to the database

Of course, the majority of queries that can be performed on a MySQL database don't return any data. What if a developer needs to insert a row into a table? For that, we can use the execute method of the database object.

In this recipe, we will insert a new row into a table called CustomTable.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.