InfinityQuest - Programming Code Tutorials and Examples with Python, C++, Java, PHP, C#, JavaScript, Swift and more

Menu
  • Home
  • Sitemap

Python Programming Language Best Tutorials and Code Examples

Learn Python Right Now!
Home
PHP
Retrieving Rows Without a Loop in PHP
PHP

Retrieving Rows Without a Loop in PHP

InfinityCoder December 1, 2016

You want a concise way to execute a query and retrieve the data it returns.

Use fetchAll() to get all the results from a query at once, as shown in Example 10-13.
Example 10-13. Getting all results at once

1
2
3
4
5
$st = $db->query('SELECT planet, element FROM zodiac');
$results = $st->fetchAll();
foreach ($results as $i => $result) {
    print "Planet $i is {$result['planet']} <br/>\n";
}

The fetchAll() method is useful when you need to do something that depends on all the rows a query returns, such as counting how many rows there are or handling rows out of order.

Like fetch(), fetchAll() defaults to representing each row as an array with both numeric and string keys and accepts the various PDO::FETCH_* constants to change that behavior.

fetchAll() also accepts a few other constants that affect the results it returns.

To retrieve just a single column from the results, pass PDO::FETCH_COLUMN and a second argument, the index of the column you want. The first column is 0, not 1.

Share
Tweet
Email
Prev Article
Next Article

Related Articles

Getting and Setting File Timestamps in PHP
You want to know when a file was last accessed …

Getting and Setting File Timestamps in PHP

Calculating Trigonometric Functions in PHP
You want to use trigonometric functions, such as sine, cosine, …

Calculating Trigonometric Functions in PHP

About The Author

InfinityCoder
InfinityCoder

Leave a Reply

Cancel reply

Recent Tutorials InfinityQuest

  • Adding New Features to bash Using Loadable Built-ins in bash
    Adding New Features to bash Using Loadable …
    June 27, 2017 0
  • Getting to the Bottom of Things in bash
    Getting to the Bottom of Things in …
    June 27, 2017 0

Recent Comments

  • fer on Turning a Dictionary into XML in Python
  • mahesh on Turning a Dictionary into XML in Python

Categories

  • Bash
  • PHP
  • Python
  • Uncategorized

InfinityQuest - Programming Code Tutorials and Examples with Python, C++, Java, PHP, C#, JavaScript, Swift and more

About Us

Start learning your desired programming language with InfinityQuest.com.

On our website you can access any tutorial that you want with video and code examples.

We are very happy and honored that InfinityQuest.com has been listed as a recommended learning website for students.

Popular Tags

binary data python CIDR convert string into datetime python create xml from dict python dictionary into xml python how to create xml with dict in Python how to write binary data in Python IP Address read binary data python tutorial string as date object python string to datetime python

Archives

  • June 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
Copyright © 2021 InfinityQuest - Programming Code Tutorials and Examples with Python, C++, Java, PHP, C#, JavaScript, Swift and more
Programming Tutorials | Sitemap