-
Notifications
You must be signed in to change notification settings - Fork 0
/
edit_record.php
104 lines (81 loc) · 3.76 KB
/
edit_record.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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<head>
<link href="style.css" rel="stylesheet">
</head>
<div class="productList">
<?php
include 'my_memcache.php';
function changeRecord($id)
{
$ath = sqlGet("SELECT * FROM goods WHERE id = ".$id.";", $id);
echo '<form action="edit_record.php" method = "post">';
echo '<table>';
echo '<input type="hidden" name="id" value="'.$ath[0]['id'].'"/>';
echo '<tr><td>Íàçâàíèå òîâàðà*: </td><td><input type="text" size="30" name="name" value="'.$ath[0]['name'].'"/></td></tr>';
echo '<tr><td>Îïèñàíèå òîâàðà: </td><td><input type="text" size="30" name="description" value="'.$ath[0]['description'].'"/></td></tr>';
echo '<tr><td>Öåíà: </td><td><input type="text" size="30" name="price" value="'.$ath[0]['price'].'"/></td></tr>';
echo '<tr><td>Êàðòèíêà: </td><td><input type="text" size="30" name="pic" value="'.$ath[0]['pic'].'"/></td></tr>';
echo '<tr><td><input type="submit" class="my_button" value="Ñîõðàíèòü èçìåíåíèÿ"></td></tr>';
echo '</table>';
echo '</form>';
}
$link = mysql_connect('localhost', 'nfuogibo', 'T6iT0i0a1j') or die('Íå óäàëîñü ñîåäèíèòüñÿ: ' . mysql_error());
mysql_select_db('nfuogibo_goods') or die('Íå óäàëîñü âûáðàòü áàçó äàííûõ nfuogibo_goods');
$memcache_host='localhost';
$memcache_port=11211;
$memcache = new Memcache;
if(!$memcache->pconnect($memcache_host,$memcache_port))
die("Memcached íå äîñòóïåí: $memcache_host:$memcache_port");
echo '<div class = "header">';
echo '<table class = "menu"><tr>';
echo '<td class = "menu">';
echo '<a href="index.php">Âåðíóòüñÿ ê ñïèñêó òîâàðîâ</a>';
echo '</td>';
echo '</tr></table>';
echo '</div>';
echo '<div class = "product">';
if(isset($_POST['name']))
{
$oldID = $_POST["id"];
$newName = $_POST["name"];
$newDescription = $_POST["description"];
$newPrice = $_POST["price"];
$newPic = $_POST["pic"];
if($newName != "" and is_numeric($newPrice))
{
$newReqest = 'UPDATE goods SET name = "'.$newName.'"';
$newReqest .= ', description = "'.$newDescription.'"';
if($newPrice != "")
$newReqest .= ', price = '.$newPrice;
$newReqest .= ', pic = "'.$newPic.'"';
$newReqest.=' WHERE id = '.$oldID.';';
echo 'Èçìåíåíèÿ ñîõðàíåíû.<br>';
#echo $newReqest;
$ath = sqlSet($newReqest, $oldID);
exit();
}
else
{
if($newName == "")
echo 'Âû íå ââåëè íàçâàíèå òîâàðà.<br>';
if(!is_numeric ($newPrice))
echo 'Öåíà äîëæíà áûòü ÷èñëîì.<br>';
echo '<form action="edit_record.php" method = "post">';
echo '<table>';
echo '<input type="hidden" name="id" value="'.$oldID.'"/>';
echo '<tr><td>Íàçâàíèå òîâàðà*: </td><td><input type="text" size="30" name="name" value="'.$newName.'"/></td></tr>';
echo '<tr><td>Îïèñàíèå òîâàðà: </td><td><input type="text" size="30" name="description" value="'.$newDescription.'"/></td></tr>';
echo '<tr><td>Öåíà: </td><td><input type="text" size="30" name="price" value="'.$newPrice.'"/></td></tr>';
echo '<tr><td>Êàðòèíêà: </td><td><input type="text" size="30" name="pic" value="'.$newPic.'"/></td></tr>';
echo '<tr><td><input type="submit" class="my_button" value="Ñîõðàíèòü èçìåíåíèÿ"></td></tr>';
echo '</table>';
echo '</form>';
exit();
}
}
if(isset($_GET['value']))
{
changeRecord($_GET['value']);
}
?>
</div>