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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90

<?php require("configure.php");
 
$CoursesCatId             = $_POST["CoursesCatId"];
$CoursesDetailId        = $_POST["CoursesDetailId"];
$CoursesDetailNameen    = htmlspecialchars($_POST["CoursesDetailNameen"],ENT_QUOTES);
$CoursesDetailAgeen        = htmlspecialchars($_POST["CoursesDetailAgeen"],ENT_QUOTES);
$CoursesDetailFeeen        = htmlspecialchars($_POST["CoursesDetailFeeen"],ENT_QUOTES);
$CoursesDetailTimeen    = htmlspecialchars($_POST["CoursesDetailTimeen"],ENT_QUOTES);
$CoursesDetailDescen    = preg_replace("/'/","\'",$_POST["CoursesDetailDescen"]);

$CoursesDetailNametc    = htmlspecialchars($_POST["CoursesDetailNametc"],ENT_QUOTES);
$CoursesDetailAgetc        = htmlspecialchars($_POST["CoursesDetailAgetc"],ENT_QUOTES);
$CoursesDetailFeetc        = htmlspecialchars($_POST["CoursesDetailFeetc"],ENT_QUOTES);
$CoursesDetailTimetc    = htmlspecialchars($_POST["CoursesDetailTimetc"],ENT_QUOTES);
$CoursesDetailDesctc    = preg_replace("/'/","\'",$_POST["CoursesDetailDesctc"]);

$CoursesDetailNamesc    = htmlspecialchars($_POST["CoursesDetailNamesc"],ENT_QUOTES);
$CoursesDetailAgesc        = htmlspecialchars($_POST["CoursesDetailAgesc"],ENT_QUOTES);
$CoursesDetailFeesc        = htmlspecialchars($_POST["CoursesDetailFeesc"],ENT_QUOTES);
$CoursesDetailTimesc    = htmlspecialchars($_POST["CoursesDetailTimesc"],ENT_QUOTES);
$CoursesDetailDescsc    = preg_replace("/'/","\'",$_POST["CoursesDetailDescsc"]);

//print_r($_POST);

// copy image 
if ($_FILES['CoursesDetailScheduleen']['name'] <> '')
{
    copy ($_FILES['CoursesDetailScheduleen']['tmp_name'], "coursesschedule/".$CoursesDetailId."_en_".$_FILES['CoursesDetailScheduleen']['name']) 
        or die ("Could not copy");
    
    $CoursesDetailScheduleen = $CoursesDetailId."_en_".$_FILES['CoursesDetailScheduleen']['name'];
    $CoursesDetailScheduleen    = htmlspecialchars($CoursesDetailScheduleen,ENT_QUOTES);
}
else
{
    $CoursesDetailScheduleen = "";
}
// End upload image code

// copy image 
if ($_FILES['CoursesDetailScheduletc']['name'] <> '')
{
    copy ($_FILES['CoursesDetailScheduletc']['tmp_name'], "coursesschedule/".$CoursesDetailId."_tc_".$_FILES['CoursesDetailScheduletc']['name']) 
        or die ("Could not copy");
    
    $CoursesDetailScheduletc = $CoursesDetailId."_tc_".$_FILES['CoursesDetailScheduletc']['name'];
    $CoursesDetailScheduletc    = htmlspecialchars($CoursesDetailScheduletc,ENT_QUOTES);
}
else
{
    $CoursesDetailScheduletc = "";
}
// End upload image code

// copy image 
if ($_FILES['CoursesDetailSchedulesc']['name'] <> '')
{
    copy ($_FILES['CoursesDetailSchedulesc']['tmp_name'], "coursesschedule/".$CoursesDetailId."_sc_".$_FILES['CoursesDetailSchedulesc']['name']) 
        or die ("Could not copy");
    
    $CoursesDetailSchedulesc = $CoursesDetailId."_sc_".$_FILES['CoursesDetailSchedulesc']['name'];
    $CoursesDetailSchedulesc    = htmlspecialchars($CoursesDetailSchedulesc,ENT_QUOTES);
}
else
{
    $CoursesDetailSchedulesc = "";
}
// End upload image code

// Modify 
$sql = "update CoursesDetail set CoursesCatId='$CoursesCatId', CoursesDetailNameen='$CoursesDetailNameen', CoursesDetailAgeen='$CoursesDetailAgeen', CoursesDetailFeeen='$CoursesDetailFeeen', CoursesDetailTimeen='$CoursesDetailTimeen', CoursesDetailDescen='$CoursesDetailDescen', CoursesDetailNametc='$CoursesDetailNametc', CoursesDetailAgetc='$CoursesDetailAgetc', CoursesDetailFeetc='$CoursesDetailFeetc', CoursesDetailTimetc='$CoursesDetailTimetc', CoursesDetailDesctc='$CoursesDetailDesctc', CoursesDetailNamesc='$CoursesDetailNamesc', CoursesDetailAgesc='$CoursesDetailAgesc', CoursesDetailFeesc='$CoursesDetailFeesc', CoursesDetailTimesc='$CoursesDetailTimesc', CoursesDetailDescsc='$CoursesDetailDescsc' ";
if ($CoursesDetailScheduleen <> '')
    $sql .= ", CoursesDetailScheduleen='$CoursesDetailScheduleen' ";
if ($CoursesDetailScheduletc <> '')
    $sql .= ", CoursesDetailScheduletc='$CoursesDetailScheduletc' ";
if ($CoursesDetailSchedulesc <> '')
    $sql .= ", CoursesDetailSchedulesc='$CoursesDetailSchedulesc' ";
$sql .= " where CoursesDetailId=". $CoursesDetailId ." ";
mysql_query($sql);

if( mysql_errno() > 0 ){
    echo 'Courses Detail Modify Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
    exit;
}

    
mysql_close($dbh);

header("Location: coursesdetail_index.php?CoursesCatId=".$CoursesCatId."&msg=Modify Successful");
?>