<?php
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta charset="WINDOWS-1251">
<BODY BACKGROUND="background.jpg">
<title>Изменение характеристик часов</title>
</head>
<body>
<table align='center'>
<tr><td align='center' ><a href="index.php?zZ=<?php echo $_SESSION['ID'];?>"><b> <button>Назад</button> <b></a>
</td>
</tr>
</table>
<?php
if ($_SESSION['num']==1) {
include_once('check.php');
$db = get_bd();
$button = NULL;
if (isset($_GET['ID'])) {
$ID = $_GET['ID'];
if ($_GET['del']=='ok') {
mysql_query("DELETE FROM watch WHERE ID='$ID'",$db);
mysql_query("DELETE FROM ccount WHERE ID='$ID'",$db);
echo "
<h3 align='center'> Часы удалены <br><br></h3>
";
} else {
$query = mysql_query("SELECT * FROM watch c LEFT JOIN ccount cc ON c.ID = cc.ID WHERE c.ID='$ID'",$db);
$data = mysql_fetch_array($query);
$button = forma($data['name'], $data['material'],$data['waterproof'],$data['diameter'],$data['mechanism'],$data['gender'],$data['glass'],$data['countwatch'],$data['price']);
}
} else {
$button = forma();
}
} else {
echo "
<h3 align='center'>У вас недостаточно прав.<br><br><a href='index.php?zZ=".$_SESSION['ID']."'>Вернуться назад</a></h3>
";
}
function forma($name='',$material='',$waterproof='',$diameter='',$mechanism='',$gender='',$glass='',$countwatch='',$price=''){
$res = "
<br><br>
<table align=center>
<form method='post' enctype='multipart/form-data'>
<tr>
<td valign=top>
<label>Название</label><br>
<textarea name='name' cols=20 rows='2'>".$name."</textarea><br><br>
<label>Материал</label><br>
<textarea name='material' cols=20 rows='2'>".$material."</textarea><br><br>
<label>Водостойкость</label><br>
<textarea name='waterproof' cols=20 rows='2'>".$waterproof."</textarea><br><br>
<label>Диаметр</label><br>
<textarea name='diameter' cols=20 rows='2'>".$diameter."</textarea><br><br>
<label>Механизм </label><br>
<textarea name='mechanism' cols=20 rows='2'>".$mechanism."</textarea><br><br>
<label>Пол </label><br>
<textarea name='gender' cols=20 rows='2'>".$gender."</textarea><br><br>
<label>Стекло</label><br>
<textarea name='glass' cols=20 rows='2'>".$glass."</textarea><br><br>
<label>В наличии </label><br>
<textarea name='countwatch' cols=20 rows='2'>".$countwatch."</textarea><br><br>
<label>Цена </label><br>
<textarea name='price' cols=20 rows='2'>".$price."</textarea><br><br>
<label>Изображение</label>
<input type='file' name='img'><br>
<input type='submit' name='ok?' value='Готово'>
</td>
</tr>
</form>
</table>
";
echo $res;
if (isset($_POST['ok?'])) {
return 1;
} else {
return NULL;
}
}
if ($button != NULL) {
$ID = $_GET['ID'];
$name = $_POST['name'];
$material = $_POST['material'];
$waterproof = $_POST['waterproof'];
$countwatch_new = $_POST['countwatch'];
$diameter = $_POST['diameter'];
$mechanism = $_POST['mechanism'];
$gender = $_POST['gender'];
$glass = $_POST['glass'];
$price = $_POST['price'];
$countshop = $_POST['countshop'];
$url = "";
if (isset($_FILES['img'])) {
$url = saveImg("img");
$url = str_replace('\\', '\\\\', $url);
}
if (isset($_GET['ID'])) {
$query = mysql_query("SELECT countwatch FROM watch WHERE ID='$ID'",$db);
$data = mysql_fetch_array($query);
$countwatch = $countwatch_new;
$update_image = (!empty($url)) ? ", 'image' = '" . mysql_real_escape_string($url) . "'"
$r = mysql_query("UPDATE watch SET name = '$name', material = '$material', waterproof = '$waterproof',countwatch = '$countwatch', diameter = '$diameter',mechanism = '$mechanism',gender = '$gender',glass = '$glass',price = '$price',image='$update_image' WHERE ID='" . (int)$_GET['ID'] . "'",$db);
echo '<META HTTP-EQUIV="Refresh" content="0; URL=kabinet_1.php?ID='.$_SESSION['ID'].'">';
} else {
mysql_query("INSERT INTO watch (name,material,waterproof,countwatch,diameter,mechanism,gender,glass,price,image) VALUES ('$name','$material','$waterproof','$countwatch_new','$diameter','$mechanism','$gender','$glass','$price','$update_image')",$db);
echo '<META HTTP-EQUIV="Refresh" content="0; URL=kabinet_1.php?ID='.$_SESSION['ID'].'">';
}
}
function saveImg($dir) {
$name = substr(basename($_FILES['img']['name']), strrpos(basename($_FILES['img']['name']), "."));
$name = md5(time()) . $name;
$path = $dir . DIRECTORY_SEPARATOR . $name;
copy($_FILES['img']['tmp_name'], $path);
return $path;
}
?>
</body>
</html>
Попробовала так, но тогда выдается ошибка в 111 строке
Parse error: parse error, unexpected T_VARIABLE in ... on line 111, которая UPDATE, а когда код почему то работал, то старая картинка оставалась при редактировании, но новая не заливалась