01.
$sql
= "SELECT data_user.*,data_car.*,data_prb.*,data_ins.*
02.
FROM data_user
03.
04.
left JOIN data_car on data_user.id=data_car.id
05.
left JOIN data_prb on data_user.id=data_prb.id
06.
left join data_ins on data_user.id=data_ins.id
07.
08.
09.
WHERE data_user.member_id =
'admin'
".
10.
' LIMIT '
.
$st_rec
.
','
.
$per_page
;
11.
12.
13.
$query
=
$conn
->query(
$sql
)
or
die
(
$conn
->error.
"<br>$sql"
);
14.
15.
$d
=
date
(
"Y-m-d"
);
16.
$dump
=
date
(
"Y-m-d"
,
strtotime
(
"+10 day"
));
17.
18.
19.
20.
?>
21.
22.
<table width=
"100%"
cellpadding=
"5"
align=
"center"
border=
"1"
bgcolor=
"#cccccc"
>
23.
<tr>
24.
25.
26.
<td>ลำดับ</td>
27.
<td>ID</td>
28.
<td>Phone Number</td>
29.
<td>ScheduledDelivery</td>
30.
<td>reset</td>
31.
32.
</tr>
33.
34.
<?php
35.
36.
37.
while
(
$ro
=
$query
->fetch_assoc()):
38.
39.
40.
$car_cha
=
$ro
[
"car_cha"
];
41.
$car_num
=
$ro
[
"car_num"
];
42.
$car_city
=
$ro
[
"car_city"
];
43.
$phone
=
$ro
[
"phone"
];
44.
$car_cha
=
$ro
[
"car_cha"
];
45.
$car_num
=
$ro
[
"car_num"
];
46.
$car_city
=
$ro
[
"car_city"
];
47.
$e_now
=
$ro
[
"e_now"
];
48.
$e_nowthai
= DateThai(
$ro
[
"e_now"
]);
49.
$id
=
$ro
[
'id'
];
50.
51.
52.
53.
54.
55.
56.
57.
?>
58.
59.
<tr>
60.
<td align=
"center"
></td>
61.
<td align=
"center"
><input type=
"text"
name=
"id"
value=
"<?php echo $id ?>"
> </td>
62.
<td><input type=
"text"
id=
"msisdn"
name=
"msisdn"
value=
"<?php echo $phone ?>"
/></td>
63.
64.
<td><input type=
"text"
id=
"ScheduledDelivery"
name=
"ScheduledDelivery"
value=
""
/>
65.
66.
* 1207011545 (ปีเดือนวันชั่วโมงนาที)<br/>
67.
68.
</td>
69.
<td>
70.
<input type=
"submit"
value=
"Send Now"
/>
71.
72.
</td>
73.
</tr>
74.
75.
<?php
endwhile
;?>
76.
77.
</table>
78.
79.
<!--
end
ตารางแสดงข้อมูล-->
80.
81.
82.
</form>