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
|
<?php require("configure.php");
$CoursesCatId = $_POST["CoursesCatId"];
$CoursesCatTitleen = htmlspecialchars($_POST["CoursesCatTitleen"],ENT_QUOTES);
$CoursesCatIntroen = preg_replace("/'/","\'",$_POST["CoursesCatIntroen"]);
$CoursesCatTitletc = htmlspecialchars($_POST["CoursesCatTitletc"],ENT_QUOTES);
$CoursesCatIntrotc = preg_replace("/'/","\'",$_POST["CoursesCatIntrotc"]);
$CoursesCatTitlesc = htmlspecialchars($_POST["CoursesCatTitlesc"],ENT_QUOTES);
$CoursesCatIntrosc = preg_replace("/'/","\'",$_POST["CoursesCatIntrosc"]);
//print_r($_POST);
// copy image
if ($_FILES['CoursesCatImage']['name'] <> '')
{
if (($_FILES["CoursesCatImage"]["type"] == "image/bmp") || ($_FILES["CoursesCatImage"]["type"] == "image/gif") || ($_FILES["CoursesCatImage"]["type"] == "image/jpg") || ($_FILES["CoursesCatImage"]["type"] == "image/jpeg") || ($_FILES["CoursesCatImage"]["type"] == "image/pjpeg") || ($_FILES["CoursesCatImage"]["type"] == "image/png"))
{
copy ($_FILES['CoursesCatImage']['tmp_name'], "coursesimg/id".$CoursesCatId."_".$_FILES['CoursesCatImage']['name'])
or die ("Could not copy");
$CoursesCatImage = "id".$CoursesCatId."_".$_FILES['CoursesCatImage']['name'];
$CoursesCatImage = htmlspecialchars($CoursesCatImage,ENT_QUOTES);
}
else
{
// upload error
?>
<script language="javascript">
alert("Files must be BMP, JPEG, GIF, or PNG");
history.back();
</script>
<?php
exit;
}
}
else
{
$CoursesCatImage = "";
}
// End upload image code
// Modify
$sql = "update CoursesCat set CoursesCatTitleen='$CoursesCatTitleen', CoursesCatIntroen='$CoursesCatIntroen', CoursesCatTitletc='$CoursesCatTitletc', CoursesCatIntrotc='$CoursesCatIntrotc', CoursesCatTitlesc='$CoursesCatTitlesc', CoursesCatIntrosc='$CoursesCatIntrosc' ";
if ($CoursesCatImage <> '')
$sql .= ", CoursesCatImage='$CoursesCatImage' ";
$sql .= " where CoursesCatId=". $CoursesCatId ." ";
mysql_query($sql);
if( mysql_errno() > 0 ){
echo 'Courses Category Modify Error:<br />'. mysql_error() .'<br />SQL: '. $sql;
exit;
}
mysql_close($dbh);
header("Location: coursescat_index.php?msg=Modify Successful");
?>
|