-
Notifications
You must be signed in to change notification settings - Fork 0
/
updatesql.php
70 lines (63 loc) · 1.83 KB
/
updatesql.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
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
<?php
session_start();
function updateIndex() {
$news = array();
for ($i = 1; $i <= 5; $i++) {
if (!isset($_POST["$i-news-preview-text"])) {
return;
}
$preview = filter_input(INPUT_POST, "$i-news-preview-text");
$news[$i] = $preview;
}
try {
for ($i = 1; $i <= sizeof($news); $i++) {
$conn = new PDO("mysql:host=localhost;dbname=website;charset=utf8", "root", "LEDLighting");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("UPDATE news SET preview = ? WHERE newsId = ?");
$stmt->execute(array($news[$i], $i));
}
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}
}
function updateNews() {
$newsId = "";
$content = "";
foreach ($_POST as $key => $val) {
$newsId = $key;
$content = $val;
}
try {
$conn = new PDO("mysql:host=localhost;dbname=website;charset=utf8", "root", "LEDLighting");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("UPDATE news SET content = ? WHERE newsId = ?");
$stmt->execute(array($content, $newsId));
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}
}
function updateProducts() {
foreach ($_POST as $key => $val) {
$productId = $key;
$content = $val;
}
try {
$conn = new PDO("mysql:host=localhost;dbname=website;charset=utf8", "root", "LEDLighting");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare("UPDATE products SET content = ? WHERE productId = ?");
$stmt->execute(array($content, $productId));
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}
}
if (isset($_SESSION["authorized"])) {
$sentFrom = $_SESSION["sentFrom"];
if ($sentFrom === "index.php") {
updateIndex();
} else if ($sentFrom === "news.php") {
updateNews();
} else if ($sentFrom === "products.php") {
updateProducts();
}
}
?>