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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
| <?php get_header(); ?>
<?php
$id = $_GET["id"];
$result = mysql_query(" SELECT * FROM wp_posts_us WHERE ID='$id' UNION SELECT * FROM wp_posts_job WHERE ID='$id'");
$row = mysql_fetch_array($result);
if(isset($_POST['delete'])){
mysql_query("DELETE * FROM wp_posts_us WHERE ID='$id' UNION DELETE * FROM wp_posts_job WHERE ID='$id'");
}
if(isset($_POST['save']))
{ //$myfile = $_FILES["foto"]["tmp_name"];
//$image = file_get_contents( $_FILES['foto']['tmp_name'] );
//$image = mysql_escape_string( $image );
$title = strip_tags(trim($_POST['title']));
$m_desk = $_POST['post_m_desk'];
$desk = $_POST['post_desk'];
$select = strip_tags(trim($_POST['select']));
$tell = strip_tags(trim($_POST['tell']));
$uname = strip_tags(trim($_POST['uname']));
$sname = strip_tags(trim($_POST['sname']));
$adress = strip_tags(trim($_POST['adress']));
$cost = strip_tags(trim($_POST['uprice']));
$date = date("y.d.m");
$email = strip_tags(trim($_POST['email']));
$web = strip_tags(trim($_POST['web']));
$rub = strip_tags(trim($_POST['Rub']));
$prub = strip_tags(trim($_POST['prub']));
$access = "true";
if((isset($_POST["hot_home_page"]))&&($_POST["hot_home_page"]=="a")){
$hothom = "true";
}
else {$hothom = "false";}
if((isset($_POST["hot_catagory"]))&&($_POST["hot_catagory"]=="b")){
$hotcat = "true";
}
else {$hotcat = "false";}
if($_POST["select"]=="Работодатель"){
$rub = "Работодатель";
mysql_query(" UPDATE wp_posts_job SET post_author='$uname',post_s_author='$sname',post_date='$date',post_title='$title',post_m_desk='$m_desk', post_desk='$desk',post_rub='$rub',post_p_rub='$prub',cost='$cost',email='$email',post_site='$web',tel='$tell',adress='$adress',foto='$image',access='$access',hot_to_gen='$hothom',hot_to_cat='$hotcat' WHERE id='$id' ")or die(mysql_error());
}
else
{$_POST["select"]="Работник";
$rub = "Работник";
mysql_query(" UPDATE wp_posts_us SET post_author='$uname',post_s_author='$sname',post_title='$title',post_m_desk='$m_desk', post_desk='$desk',post_rub='$rub',post_p_rub='$prub',cost='$cost',email='$email',post_site='$web',tel='$tell',adress='$adress',foto='$image',access='$access',hot_to_gen='$hothom',hot_to_cat='$hotcat' WHERE id='$id'")or die(mysql_error());
}
echo "<script type='text/javascript'> window.location='/my-ads/'; </script>";
}?>
<main>
<div class="main_body">
<div class="middle_body">
<?php get_sidebar('for_employee_and_employer'); ?>
<?php get_sidebar('menu_rubriki'); ?>
<div class="ad">
<h3>Редактирование объявления <?php echo $row['post_title']; ?> (<?php echo $id ?>) </h3>
<form method="post" action="/editing-ads/?id=<?php echo $id ?>" enctype="multipart/form-data">
<span class="enable_star"><input type="text" name="title" size="50" value="<?php echo $row['post_title']; ?>" required></span>
<span class="enable_star"><textarea class="input" name="m_desk" cols="50" rows="4"><?php echo $row['post_m_desk']; ?> </textarea> </span>
<div class="last_later"></div>
<span class="enable_star"><textarea class="input" name="desk" cols="50" rows="6"><?php echo $row['post_desk']; ?></textarea> </span>
<div class="last_later"></div>
<div class="sub_form">
<label>Рубрика</label>
<span class="enable_star"><select Rub name="select">
<option Rub><?php echo $row['post_rub']; ?></option>
<option Rub>Работодатель</option>
<option Rub>Работник</option>
</select></span>
<label>Подрубрика</label>
<span class="enable_star"><select prub name="prub">
<option prub><?php echo $row['post_p_rub']; ?></option>
<option prub>Программист</option>
<option prub>Бухгалтер</option>
<option prub>Юрист</option>
</select></span>
<label>Ваш E-mail</label>
<span class="enable_star"><input type="email" name="email" method="post" value="<?php echo $row['email']; ?>" required ></span>
<label>Телефон</label>
<span class="enable_star"><input type="text" name="tell" value="<?php echo $row['tel']; ?>" required ></span>
<label>Имя</label>
<span class="enable_star"><input type="text" name="uname" autocomplete="off" value="<?php echo $row['post_author']; ?>" required > </span>
<label>Фамилия</label>
<input type="text" name="sname" autocomplete="off" value="<?php echo $row['post_s_author']; ?>" required >
<label>Web-страница</label>
<input type="text" name="web" value="<?php echo $row['post_site']; ?>" >
<label>Зарплата</label>
<input type="text" name="uprice" value="<?php echo $row['cost']; ?>" >
<label>Адрес</label>
<input type="text" name="adress" value="<?php echo $row['adress']; ?>" >
<label>Фото</label>
<div class="add_photo"><input type="file" name="foto" id="foto" placeholder="Вставьте адресс фотографии"></div>
</div>
<div class="hot_predlojenia">
<input type="checkbox" name="hot_home_page" id="hot_home_page" value="a">
<label for="hot_home_page">Горячие предложение на главной страницы</label>
<input type="checkbox" name="hot_catagory" id="hot_catagory" value="b">
<label for="hot_catagory">Горячие предложение в категории</label>
</div>
<input type="submit" name="save" value="Опубликовать" /> <input type="submit" name="delete" value="Удалить" />
</form>
</div>
</div>
<?php get_sidebar('banner_left'); ?>
</div>
</main>
<?php get_footer(); ?> |
(
Сообщение от Shoshona
