Am trying to access the result of SQL query in SQLite using PHP from another class. I have read similar questions here and here. But still have not found a solution to my problem. This is what I have done.
Connect.php
<?php
$dsn = 'sqlite:leDB.db';
$db = new PDO($dsn);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
?>
DBMan.php
<?php
Class DBMan{
private $dsn = 'sqlite:leDB.db';
private $db;
public function __construct(){
$this->db = new PDO($this->dsn);
$this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
public function showData(){
try{
$sql = 'SELECT * FROM fruits';
$stmt= $this->db->query(sql);
if(!$stmt){
throw new PDOException('Error displaying fruits');
}
$data = $stmt->fetchAll(FETCH_ASSOC);
return $data;
}
catch (PDOException $e){
echo 'Error\n';
echo '$e->getMessage()';
}
}
}
?>
MaView.php
<?php
class MaView{
function __autoload($class){
include_once($class.".php");
}
$db=new DBMan();
<?php
$val = $dat->showData();
foreach ($val as $row) {?>
<H1><? echo row['fruit_name']?></H1>
<? }?>
}
?>
Can someone please show me where I have blundered?
Aucun commentaire:
Enregistrer un commentaire