![]() ![]() For example, if such processing is the only action that needs to be taken, or if the data needs to be pre-processed somehow before use.īut the most preferred way to fetch multiple rows which would to be shown on a web-page is calling the great helper method called fetchAll(). This method could be recommended if rows have to be processed one by one. The most traditional way is to use the fetch() method within a while loop: $stmt = $pdo -> query ( "SELECT * FROM users" ) There are two ways to fetch multiple rows returned by a query. Note that in PHP you can "chain" method calls, calling a method of the returned object already, like: $user = $pdo -> query ( "SELECT * FROM users ORDER BY id DESC LIMIT 1" )-> fetch () Selecting multiple rows $stmt = $pdo -> query ( "SELECT * FROM users ORDER BY id DESC LIMIT 1" ) ![]() If a query is supposed to return just a single row, then you can just call fetch() method of the $stmt variable: // getting the last registered user This will give us an $stmt object that can be used to fetch the actual rows. $stmt = $pdo -> query ( "SELECT * FROM users" ) If there are no variables going to be used in the query, we can use a conventional query() method instead of prepare and execute. Just make sure you've got a properly configured PDO connection variable that needs in order to run SQL queries with PDO and to inform you of the possible errors. I will show examples for the every case so you can choose one that suits you best. There are several ways to run a SELECT query using PDO, that differ mainly by the presence of parameters, type of parameters, and the result type. ![]() SELECT query with positional placeholders. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |