-
Notifications
You must be signed in to change notification settings - Fork 0
/
editphotos2.php
38 lines (30 loc) · 896 Bytes
/
editphotos2.php
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
<?php
require('settings.php');
require('check.php');
$ImageID = ereg_replace("[^0-9]", "", $_GET['ImageID']);
$ImageTitle = $_GET['ImageTitle'];
$ImageCaption = $_GET['ImageCaption'];
function filterFunction ($var) {
$var = nl2br(htmlspecialchars($var));
$var = eregi_replace("'", "'", $var);
$var = eregi_replace("`", "'", $var);
return $var;
}
$ImageTitle = filterFunction($ImageTitle);
$ImageCaption = filterFunction($ImageCaption);
require_once "../scripts/connect.php";
$sql = <<<SQL
UPDATE
tblPhotos
SET imageTitle = "$ImageTitle", captionText = "$ImageCaption" WHERE imageID = "$ImageID" LIMIT 1
SQL;
if (!$result = $db->query($sql))
{
die('There was an error running the query [' . $db->error . ']');
$result->free();
$db->close();
}
$_SESSION['UpdateImage'] = "True";
//header("Location: $AdminUrl/admin-gallery-photos/". $GalleryID);
//exit();
?>