Php pdo select row using database row id

ساخت وبلاگ

Vote count: 0

Previously am using mysql to loop on users data getting the table row by rws[0], now that i change to pdo i still need to use this rws[0] get each row instead of using the row name like this $id = $rws->id; in pdo how can i make this work in pdo?

OLD MYSQL

<?php
include('conn.php');
$sql="SELECT * FROM users";
$result= mysql_query($sql) or die(mysql_error());
while($rws = mysql_fetch_array($result)){
$id = $rws[0];
$name = $rws[1];
$email = $rws[2];
}
?>

NEW PDO

 <?php $sql = new DBController(); $sql->prepare("SELECT * FROM users"); $sql->execute(); $result = $sql->getAll(); $sql->free(); if(!is_null($result)){ foreach($result as $i => $rws){ $id = $rws->id; // just want it to be this >> $id = $rws[0]; $name = $rws->name; // I tried this $name = $rws->[0]; $email = $rws->email; } } ?>
asked 1 min ago

back soft...
ما را در سایت back soft دنبال می کنید

برچسب : php pdo select,php pdo select example,php pdo select count,php pdo select all,php pdo select statement,php pdo select database,php pdo select rowcount,php pdo select prepared statement,php pdo select one row,php pdo select prepared statement example, نویسنده : استخدام کار backsoft بازدید : 399 تاريخ : سه شنبه 30 شهريور 1395 ساعت: 20:35