-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathquery_pro.php
More file actions
21 lines (18 loc) · 976 Bytes
/
query_pro.php
File metadata and controls
21 lines (18 loc) · 976 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?php
header('Content-Type: application/json; charset=UTF-8');
require_once 'connectMysql2.php';
$query_pro = "SELECT * FROM `project` WHERE id=$_POST[id]";
$query_pro_task = "SELECT * FROM `pro_task` WHERE num = $_POST[id] ";
$query_complete_pro_task = "SELECT * FROM `pro_task` WHERE num = $_POST[id] AND finish=1 ";
$complete_num=count($db_link->query($query_complete_pro_task)->fetchAll());
$all_num=count($db_link->query($query_pro_task)->fetchAll());
$all_pro_task = $db_link->query($query_pro_task);
$pro = $db_link->query($query_pro)->fetch(PDO::FETCH_ASSOC);
// echo json_encode(array('name'=>$pro['name'],'due_date'=>$pro['due_date'],'num'=>$_POST['id']));
if($all_pro_task!==false){
$result = $all_pro_task->fetchAll(PDO::FETCH_ASSOC);
// echo json_encode(array(array('name'=>$pro['name'],'due_date'=>$pro['due_date'],'id'=>$_POST['id']),$result));
echo json_encode(array($pro,$result,array('all'=>$all_num,'complete'=>$complete_num)));
}
// $result =
?>