read.php
<?php
require_once('../dao/config.php');
require_once('../dao/crudDAO.php');
$list = crudDAO::read();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CRUD
<div>
<div>
<?php foreach($list as $key => $value) { ?>
<?php } ?>
<table><tbody><tr> <td>id</td> <td>Name</td> <td>Email</td> <td>Address</td> <td>Mobile number</td> </tr><tr><td><?= $value['id'] ?></td> <td><?= $value['name'] ?></td> <td><?= $value['email'] ?></td> <td><?= $value['address'] ?></td> <td><?= $value['mob'] ?></td> </tr></tbody></table>
</div>
</div>
error:
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\crud_php\oop_crud\pages\read.php on line 25
id Name Email Address Mobile number
crudDAO.php
<?php
class CrudDAO {
public function create($name, $email, $address, $mob) {
global $db;
$sql = "INSERT INTO users SET name = '$name', email = '$email', address = '$address', mob = '$mob'";
$result = $db->query($sql);
if($result) {
return $result;
} else {
return false;
}
}
public function read() {
global $db;
$sql = "SELECT * FROM users ORDER BY id";
$result = $db->query($sql);
if($result->num_rows > 0) {
$i = 0;
$list = " ";
while($row = $result->fetch_assoc()) {
$list[$i] = $row;
$i++;
}
return $list;
} else {
return false;
}
}
public function update() {
global $db;
}
public function delete() {
global $db;
}
}
?>
error:
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
What I have tried:
Find solution on internet
Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\crud_php\oop_crud\pages\read.php on line 25
id Name Email Address Mobile number
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24
Notice: Array to string conversion in C:\xampp\htdocs\crud_php\oop_crud\dao\crudDAO.php on line 24