I want to use foreach for looping instead of while loop in the below code. But for some reason the foreach loop is not working as I expected. Can please help me with this.
class MyDB extends SQLite3
{
function __construct()
{
$this->open('test.db');
}
}
$db = new MyDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Opened database successfully
";
}
$sql =<<<EOF
SELECT * from COMPANY;
EOF;
$ret = $db->query($sql);
$newArray = array_chunk($links['data'], 12, false);
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
echo "ID = ". $row['ID'] . "
";
echo "NAME = ". $row['NAME'] ."
";
echo "ADDRESS = ". $row['ADDRESS'] ."
";
echo "SALARY = ".$row['SALARY'] ."
";
}
echo "Operation done successfully
";
$db->close();
THis is the code I Used.
$ret = $db->query($sql);
$value = $ret->fetchArray(SQLITE3_ASSOC);
foreach($value as $row){
echo "ID = ". $row['ID'] . "
";
echo "NAME = ". $row['NAME'] ."
";
echo "ADDRESS = ". $row['ADDRESS'] ."
";
echo "SALARY = ".$row['SALARY'] ."
";
}
echo "Operation done successfully
";
$db->close();