Sign in Get Started

pdo fetch

Kurt Tappe 

<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Exercise PDOStatement::fetch styles */
print("PDO::FETCH_ASSOC: ");
print("Return next row as an array indexed by column name\n");
$result = $sth->fetch(PDO::FETCH_ASSOC);
print_r($result);
print("\n");

print("PDO::FETCH_BOTH: ");
print("Return next row as an array indexed by both column name and number\n");
$result = $sth->fetch(PDO::FETCH_BOTH);
print_r($result);
print("\n");

print("PDO::FETCH_LAZY: ");
print("Return next row as an anonymous object with column names as properties\n");
$result = $sth->fetch(PDO::FETCH_LAZY);
print_r($result);
print("\n");

print("PDO::FETCH_OBJ: ");
print("Return next row as an anonymous object with column names as properties\n");
$result = $sth->fetch(PDO::FETCH_OBJ);
print $result->name;
print("\n");
?>
View another examples Add Own solution
Log in, to leave a comment

0
7
Satoh 130 points 

                                    $stmt&nbsp;=&nbsp;$pdo-&gt;prepare(&quot;SELECT&nbsp;*&nbsp;FROM&nbsp;users&nbsp;LIMIT&nbsp;:limit,&nbsp;:offset&quot;);$stmt-&gt;execute(['limit'&nbsp;=&gt;&nbsp;$limit,&nbsp;'offset'&nbsp;=&gt;&nbsp;$offset]);&nbsp;$data&nbsp;=&nbsp;$stmt-&gt;fetchAll();//&nbsp;and&nbsp;somewhere&nbsp;later:foreach&nbsp;($data&nbsp;as&nbsp;$row)&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;$row['name'].&quot;&lt;br&nbsp;/&gt;\n&quot;;}

0
0
3.9
11
Johnno Nolan 125 points 

                                    $pdo = new PDO('mysql:host=$host; dbname=$database;', $user, $pass);
$stmt = $pdo-&gt;prepare('SELECT * FROM auction WHERE name = :name');
$stmt-&gt;bindParam(':name', $_GET['searchdivebay']);
$stmt-&gt;execute(array(':name' =&gt; $name);

3.9 (10 Votes)
0
4.75
4
Sam Healey 115 points 

                                     while ($row = mysqli_fetch_assoc( $result)) {}

4.75 (4 Votes)
0
0
0
Beta Decay 85 points 

                                    
It should be mentioned that this method can set even non-public properties. It may sound strange but it can actually be very useful when creating an object based on mysql result.
Consider a User class:

&lt;?php
class User {
&nbsp;&nbsp; // Private properties
&nbsp;&nbsp; private $id, $name;

&nbsp;&nbsp; private function __construct () {}

&nbsp;&nbsp; public static function load_by_id ($id) {
&nbsp; &nbsp; &nbsp; $stmt = $pdo-&gt;prepare('SELECT id, name FROM users WHERE id=?');
&nbsp; &nbsp; &nbsp; $stmt-&gt;execute([$id]);
&nbsp; &nbsp; &nbsp; return $stmt-&gt;fetchObject(__CLASS__);
&nbsp;&nbsp; }
&nbsp;&nbsp; /* same method can be written with the &quot;name&quot; column/property */
}

$user = User::load_by_id(1);
var_dump($user);
?&gt;

fetchObject() doesn't care about properties being public or not. It just passes the result to the object. Output is like:

object(User)#3 (2) {
&nbsp; [&quot;id&quot;:&quot;User&quot;:private]=&gt;
&nbsp; string(1) &quot;1&quot;
&nbsp; [&quot;name&quot;:&quot;User&quot;:private]=&gt;
&nbsp; string(10) &quot;John Smith&quot;
}

0
0
3.67
3
Jim MacA 120 points 

                                    $dbhost = @mysql_connect($host, $user, $pass) or die('Unable to connect to server');

@mysql_select_db('divebay') or die('Unable to select database');
$search = $_GET['searchdivebay'];
$query = trim($search);

$sql = &quot;SELECT * FROM auction WHERE name LIKE '%&quot; . $query . &quot;%'&quot;;



if(!isset($query)){
echo 'Your search was invalid';
exit;
} //line 18

$result = mysql_query($trim);
$numrows = mysql_num_rows($result);
mysql_close($dbhost);

3.67 (3 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category PHP
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
fetching data php how to fetch array in pdo php how to fetch results in PDO php pdo get and fetch fetch request method in php method php fetch fetch single data from database in php pdo pdo fetch request api fetch php Use PDO to fetch data from pgsql db pdo most efficient fetch pdo sql fetch in while pdo $db-&gt;prepare fetch() use of fetch in php fetch EN PHP mysql fetch syn php how to get data with pdo in php pdo fetch to object PDO::FETCH_OBJ as default PDO::fetch php fetchAll(PDO::FETCH_OBJ); how to fetch data using pdo in php fetch table in php pdo fetch assoc php pdo mysql pdo fetch prepare php what does fetch() return what is in pdo fetch() php -&gt;fetch(); pdo fetch_class pdo fetch to entity pdo fetch foreach php oci fetch query php fetch php mysql_fetch fetch request php php pdo fetchall example get data php pdo how to fetch data from database using pdo in php fetch get php pdo advance fetch style fetch data php url pdo pdo set default fetch mode in php PDO Fetch or FetchAll php fetch and fetchall pdo execute fetchall php pdo prepare execute fetch pdo fetch number fetch data from api pdo query PDO:FETCH as array PDO:FETCH array how to fetch data use prepare pdo fetch in php pdo select pdo fetch php PDO FETCH CLASS exampl fetch attributes pdo php pdo fetch return false PHP 8 PDO fetch all fetch mysql php php fetch then use how to fetch records in object in php in PDO pdo select fetch assoc all fetch api inn php fetch pdo as sting in php methode fetch php fetch string php what does fetch do on php use query pdo to fetch data into a table php equivalent fetch method pdo fetch where no result fetchAll(PDO::FETCH_OBJ) php array fetch how to fetch data record using pdo in php javascript fetch from php php fetch sql mysql pdo fetch pdo fetch methods pdo fetchall vs fetch fetch all php pdo fetch sql response in php php pdo fetch as object how to fetch data from database in php using pdo pdo fetch statements how to get data from database php pdo fetching techiniques using PDO fetch from api in php fetch row in pdo statement in php pdo fetch value php fetch query pdo statment fetch pdo fetch return false fetch(PDO::FETCH_OBJ) how to fetch result pdo fetch assoc pdo php kind of fetch in pdo php kind of fetches in pdo php fetch data in php pdo fetchinto php fetch php mysql $query-&gt;fetchAll(PDO::FETCH_OBJ); what is mysql fetch object in php fetch in php mysql fetch js php fetch php pdo php mysql fetch php fetch with PDO php stmt fetch php return type of PDO fetch result php return PDO fetch result type pdo fetch from database php fetch data fetch datawith php pdo options fetch mode pdo fetch assoc array fetch mehtod in php pdo :fetch methods fetch(PDO::FETCH_OBJ); not working FETCH_OBJ pdo php pdo fetch assoc data fetch result pdo odbc fetch statement in php how to fetch data from mysql database using php pdo how to fetch data from database using pdo php PDO get data php pdo fetch mode pdo table php fetch fetching result assending php pdo fetch api with php php pdo mysql fetch array javascript php fetch pdo fetch vs pdo query php pdo $stmt-&gt;fetch() result php pdo fetch() result pdo fetch true false fetch code in php mysql fetch result PDO php pdo fetchall fetch_into php sql fetch pdo fetch obj fetch alternative in pdo php -&gt;fetch() in php pdo db fetch how to fetch data in pdo fetch assoc for pdo pdo fetchobject pdo fetch returns false fetchall pdo example fetching in pdo how to fetch in pdo php pdo fetch object php pdo select from database php pdo while fetch get data from database php pdo pdo set fetch mode pdo fetch style fetch api using php fetch data from mysql in php using pdo and store in variable pdo fetch count api data fetch in php fetch () php PDO while loop fetch while pdo fetch pdo fetch() and fetchall() js fetch() to php js fetch php pdo execute fetch PHP API with js fetch PHP-API with js fetch php sql fetch() php pdo default fetch mode between in sql and pdo php and fetch data php pdo fetchone pdo fetch_func example pdo fetch func example how to fetch data from database in php pdo pdo -&gt;fetch() pdo fetch() pdo fetch php php pdo fetch_class fetch from api php sql query fetch object pdo what is PDO default fetch mode php pdo fetch column one record fetch with pdo in php mysql pdo select fetch php fetcha;; FETCH_CLASS PDO fetch js php get php api fetch fetch value pdo example php fetch mysql php fetch request php pdo fetch data with where clause php pdo fetch data with filter PHP API for fetch pdo query fetch Fetch data from database in PHP PDO php query fetch how to fetch as value in php pdo from database php fetch from database pdo fetch shorthand pdo fetch shortcut sql pdo fetch modes php and fetch php and fetch api array fetch in php php fetch api php fetch sql request fetch php js php PDO fetch ass php fetch all pdo php pdo retrieve data from database php return to fetch fetch row in pdo php fetch data with pdo fetch array in pdo php function fetch php how to fetch data from database in php and display in html table using pdo pdo fetch with while mysql fetch method in php Fetch Results in PDO with Fetch Column PHP PDO fetchall PHP PDO with while fetchall PHP PDO with while and fetchall PHP PDO with while and fetch sql use PDO to fetch results How to use PDO to fetch results fetch sql php pdo fetch all contnt php pdo fetch all contnt pdo fetch options pdo fetch option php query -&gt; fetch -&gt;fetch() pdo -&gt;fetch() php how to fetch the data in php using pdo in table format how to fetch the data in php using pdo how to fetch data in the form of pdo with example how to fetch data in the form of PDO pdo select $stmt-&gt;fetch php pdo fetch for loop fetch_obj in pdo fetch all at once pdo php php fetch methods pdo php fetch methods fetch reacords in php pdo php fetch return one result php pdo sql fetch returns nothing php sql data pdo fetch into table $stmt-&gt;fetch pdo php pdo microsoft sql server fetch data from database php pdo fetch all php pdo get data from database pdo fetchall what does it pdo fetchall what is it query fetch php fetch object php how to prepare a pdo statement and fetch data fetch array php php fetch array with pdo javascript fetch in php PDO::FETCH_OBJ) sql fetch from pdo fetch api in php php net pdo fetch statement js php fetch php pdo::fetch_obj fetch results using pdo in php pdo fetch as array php PDO fetch_obj fetching data from database using php pdo -&gt;fetchAll(***PDO::FETCH_OBJ php pdo prepare execute fetch select php pdo fetch single value php fetch info fetch api and php php pdo fetch vs fetchall pdo fetch and fetchall PDO select FETCH OBJ php fetch result php fetch object use fetch with php function pdo get 1d fetch pdo fetchall example pdo fetch only one fetch every result pdo php fetch() in pdo php fetcher mysql php fetch() pdo fetch query in php php pdo fetch array fetch pdo mysql php pdo fetch row fetch pdo fetch_assoc pdo fetch all pdo fetchmode api fetch in php fetch datatable php pdo apcu_fetch php php fetch_a fetch api php pdo fetch object pdo and fetch api what is fetch method php pdo fetch adn query when to use fetch and fetch and pdo fetch and pdo definer run pdo fetch fetch php sql fetch data using pdo in php javascript fetch with php php fetch call how to fetch values based on selected option in php using pdo fetch in js php fetch in javascript &amp; php fetch php javascript while row fetch php pdo pdo fetchAll pdo fetch one pdo fetch data from database and return into object pdo fetch data from database fetch(PDO::FETCH_ASSOC) statement fetch php FETCH_BOUND example php $fetch_style php values int $fetch_style php values int $fetch_style php table php fetch popup fetch all php php fetch javascript php fetch array fetch data ajax php pdo fetch array pdo fetch volver al inicio php pdo select where php pdo mysql fetch php pdo fetch assocc pdo named array query :id fetch one php pdo pdo fetch name php getrow attributes pdo fetch ass PDO fetch row fetch() php pdo why use fetch assoc pdo fetch assoc pdo how to get pdo data php fatch fetch in php how to PDO fetch assoc pdo select from database select foreach php pdo -&gt;fetch(PDO::FETCH_ASSOC) fetch all necesary for query php pdo php pdo fetch_assoc vs fetch_assoc in php pdo array search query pdo php pdoData array to query pdo php php pdo get sql result fetch with php pdo fetchall assoc fetch_assoc in pdo php pdo fetchall opp fetch php pdo select results php pdo php query fetch fetch all in php object methods and fetch data $statement-&gt;fetchAll(PDO::FETCH_ASSOC); php pdo mysql query php pdo prepare fetch_assoc what is prepared statement fetchAll PDO pdo read from database pdo fetchassoc php .net fetch pdo statement what value fetch() return in php what fetch() return in php class const fetch php fetch(PDO::FETCH_ASSOC); PDO fetch(PDO:: difference between fetch and fetchall in php fetch in pdo php fetch in pdo by id php fetch query in background while fiorst 100 show pdo::fetch(PDO::FETCH_ASSOC) PDOStatement-&gt;fetch() #1 {main} thrown in make use of php pdo from database array with foreach pdo statement fetch pdo fetchorfirst pdo fetch_assoc foreach fetch all pdo php fetch the different run qyery in pdo fetch data in pdo 'fetch' =&gt; pdo::fetch_obj, while ( $row = $stmt-&gt;fetch query loop fetc each 10 php mysql query fetc each 10 php mysql -&gt;fetchAll(PDO::FETCH_ASSOC); $stmt-&gt;fetch(PDO::FETCH_ASSOC); PDOStatement-&gt;fetch() does fetch work with php pdo fetch assoc select in pdo php get result from pdo mssql insert and select postgres php pdo select $stmt-&gt;fetch(PDO::FETCH_ASSOC) num row hoe to fetch row pdo fetch row pdo fetch_assoc pdo php php pdo fetch assoc pdo fetch after query pdo query select all php pdo how to get data by select statement in php using pdo php fetch() php fetch() function recho result of pdo php pdo result access fetch pdo php select pdo phppdo fetch update result while fetch pdo $row = $stmt-&gt;fetch update this $row = $stmt-&gt;fetch get row id $stmt-&gt;fetch pdo get $stmt-&gt;fetch pdo get row $stmt-&gt;fetch get row id PDO::FETCH_ASSOC PHP pdo result fetch while fetch pdo hpp fetch() php php fetch_num php select pdo php fetch get can we use fetch in php php pdo statement fetch php fetch data from mysql PDO what is fetch in php how to search mysql pdo result set for a record with one field matching a string value $data = $q-&gt;fetch(PDO::FETCH_ASSOC); fetch com php query-&gt;fetch pdo object php query-&gt;fetch php query fetch pgp fetch method php $user = $stmt-&gt;fetch(); php pdo how to fech one php pdo get select result as object php pdo get select statement as object pdo fetch modes getting results from execute in pdo fetch both in pdo select all in php using pdo pdo query select all fetch in pdo pdo fetch query pdo -&gt;fetch class php for fetch data pdo get data in select ll in pdo display the fetch in pdo get rows from database pdo pdo fetch returns true fetchrow pdo how to use pdo fetch assoc pdo getRow fetch(pokemon::FETCH_CLASS); $db-&gt;fetch(pokemon::FETCH_CLASS); fetch(PDO::FETCH_CLASS) PDO::FETCH_CLASS) get results of pdo query pdo fetch method php fetch then pdo while fetch row index number -index.php pdo while fetch row index number fetch pdo while row index pdo fetch_assoc view result with result position example pdo fetch_assoc view result with result position pdo fetch_assoc view result with result index pdo fetch_assoc view result with index number pdo fetch_assoc view result with index stmt fetch array index php extract pdo index fetch php type pdo select where php $query- execute()-&gt;fetch pdo select query in php type fetch in pdo php statement fetch fetch to php fetch parameters php php pdo display all data from database pdo fetch mode php select data pdo pdo fect style pdo while fetch $row = $stmt-&gt;fetch(PDO::FETCH_ASSOC); php pdo get result fetch and echo results in pdo la methode fetch php methodes fetch php pdo prepared statement fetch php pdo select php pdo fetch &lt;? from mysql php pdo pdo while fetch get or fetch php get result from pdo how to fetch data from server PDO fetch pdo php pdo get row data pdo fetch in php pdo fetch single php PDO::FETCH mysql pdo select query fetch_assoc pdo using fetch in php pdo fetch WHERE sql pdo fetch sql fetch id pdo pdo fetch certain data from database pdo fetch certain data data from database php fetch all false control wont work php7 mysql fetch pod php fetch row pdo fetch php fetch_assoc php pdo php catch qurey fetch error while fetch pdo php php while ($fetchdata=$queryResult-&gt;fetch(PDO::FETCH_BOTH)) fetch data with PDO php php pdo select query pdo select query php mysql fetch default php pdo fetch data php pdo get query result mysql PDO::FETCH_ASSOC fetch all data from database in php pdo php pdo select rows php pdo fetch_assoc PDO::FETCH_INTO object where naming convenssion is different in php and mysql php fetch equivalent php PDO $result-&gt;fetch_array(); pdo fetch_assoc php pdo fetch_assoc example php+mysql+pdo+fetch(PDO::FETCH_OBJ) single column php fetch_assoc pdo fetchAll php pdo select query php pdo fetch mother cuking object php pdo fetch fetch record from database in php pdo select data using pdo in php php pdo statement select 2 prams php pdo fetch from db php pdo result to array fetch() in php fech assoc pdo fech in pdo pdo fetch_assoc pdo fetch php fetch
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source