1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
<?php
function createProject($name, $desc, $dl) {
$db = getData();
$req = $db->prepare('INSERT INTO project (name, description, deadline) VALUES (:name, :desc, :deadline)');
$req->execute([
'name' => $name,
'desc' => $desc,
'deadline' => $dl
]);
}
function getProjects() {
$db = getData();
$req = $db->query('SELECT project.id, project.name, COUNT(list.id) AS list_count
FROM project
LEFT JOIN list ON (list.project_id = project.id)
GROUP BY project.id DESC');
return $projects = $req->fetchAll();
} |
Partager