dt DATETIME)';
$this->_db->exec($sql) or die ($_db->lastErrorMsg());
}
}
function ShowUsers(){
$sql = "SELECT * FROM users";
$res = $this->_db->query($sql);
$arr = array();
while ($row = $res->fetchArray(SQLITE3_ASSOC)){
$arr[] = $row;
}
echo "Всего юзеров ".count ($arr)."<br>";
foreach ($arr as $item){
$id = $item['id'];
$name = $item['name'];
$lastname = $item['lastname'];
$age = $item['age'];
$dt = $item['dt'];
$dt = date('d-m-Y H:i:s');
echo "$id $name $lastname $age $dt<br>";
}
}
}
$user1 = new User;
$array = $user1->ShowUsers();
//var_dump($array);
?>
