Complete details Link : http://www.skptricks.com/2017/10/pdofetchclass-vs-pdofetchpropslate.html

PDO::FETCH_CLASS

In our last post we have discussed about PDO::FETCH_CLASS, from which I think you are able to build complete understanding on PDO::FETCH_CLASS. But in this we are going to discuss about few shortcomes about PDO::FETCH_CLASS.

Lets see the below example for PDO::FETCH_CLASS.

<?php
// < Class : user >
// class consists of userdefine functions and variables
class user{
 
 private $USERNAME ;
 private $EMAILID ;
 private $AGE ;
 private $COUNTRY ;
 //get the username
 public function getUSERNAME(){
  return $this->USERNAME ;
 }
 //get the email id
 public function getEMAILID(){
  return $this->EMAILID ;
 }
 //get the age
 public function getAGE(){
  return $this->AGE ;
 }
 //get the country
 public function getCOUNTRY(){
  return $this->COUNTRY ;
 }
 public function __construct(){
  $this->USERNAME = "sumit@gmail.com";
  
 }
 
}

// < Class : DAO >
// Get the data from database...
Class DAO{

//function return the all the data from database...
 public function getAllUserDetails(){

$dbhost ="localhost"; // set the hostname
$dbname ="skptricksdemo" ; // set the database name
$dbuser ="root" ; // set the mysql username
$dbpass ="";  // set the mysql password
 
try { 
$dbConnection = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass); 
$dbConnection->exec("set names utf8";
$dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully.<br>"; 

$stmt = $dbConnection->prepare('SELECT * FROM `userdetails` WHERE `AGE` > 10 ');
$stmt->execute();

$Count = $stmt->rowCount(); 
echo " Total Records Count : $Count .<br>" ;

if ($Count  > 0){
$stmt->setFetchMode(PDO::FETCH_CLASS, "user";

return $obj = $stmt->fetchAll(); 

}

}
catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}
 
}
}


// calling the getAllUserDetails function and retrieve details 
$dao = new DAO();
$allUserDetails =$dao->getAllUserDetails();

//echo print_r($allUserDetails);
foreach($allUserDetails as $user)
{
 //echo print_r ($UneNews);
 echo "<pre>".$user->getUSERNAME()."</pre>" ;
 //echo "<pre>".$user->getEMAILID()."</pre>" ;
 
 
}

?>

OUTPUT:
-------------------------------
Connected successfully.
Total Records Count : 4 .
sumit@gmail.com
sumit@gmail.com
sumit@gmail.com
sumit@gmail.com