1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
<?php
include('_init.php');
if($_POST){
$course_id = aes_crypt($_POST['course_id'],2);
if($course_id){
$sql = "select *,
(select count(*) from `order` where job_id = tb.id and (status = 'process' or status = 'paid') and deleted = 0) as count,
(select count(*) from `order` where job_id = tb.id and (status = 'process' or status = 'paid') and studentmain_id = '".$row_profile['id']."' and deleted = 0) as studentcount
from tutor_postjob as tb where id = ? and deleted = ? and approved = ? and status = ? and (NOW() between start_date and end_date)";
$parameters = array($course_id,0,1,1);
$row_detail = bind_pdo($sql, $parameters, "selectone");
$sql = "select name_cn as name
from master_type_code where id = ? and typeid = ? and deleted = ? LIMIT 1";
$parameters = array($row_detail["mas_instrument"], 'INSTRUMENT', 0);
$row_instrument = bind_pdo($sql, $parameters, "selectone");
$msg = '課堂名稱: <a href="../course_detail.php?id='.$course_id.'">'.$row_instrument["name"] . ' ' . $row_detail["people_count"] . '人班</a><br>
電郵: '.$_POST['email'].'<br>
電話: '.$_POST['tel'];
unset($data);
$data['type'] = 'course';
$data['msg'] = $msg;
$data['lastupdate'] = date('Y-m-d H:i:s');
$data['status'] = 1;
$data['deleted'] = 0;
$sql = mysql_install($data, 'admin_msg', 'add');
$arraykey = array_keys($data);
unset($parameters);
for ($i = 0; $i < count($arraykey); $i++) {
$parameters[$i] = $data[$arraykey[$i]];
}
bind_pdo($sql, $parameters);
$path = $_SERVER['HTTP_REFERER'];
$_SESSION['course_msg'] = true;
@header("Location: {$path}");
echo "<script language='JavaScript'>window.location='{$path}'</script>";
exit();
}
}
exit();
?>
|