UPDATE MYSQL how to update?

Y

Yuri Elmanov2016-02-05 14:47:28

PHP

Yuri Elmanov, 2016-02-05 14:47:28

I ask for help, 1st form, 2nd handler, the request passes but the data in the line is not updated, what's the problem?
P.S. At the request of those who responded:
Form code:

<?php 
  Head('Изменяем вакансию');
?>
<body>
<div class="wrapper">
  <div class="header">
    <?php
      HeadButton();
      MessageShow();
    ?>

  </div>
  <div class="content">
    <?php 
      AdminMenu();
    ?>
    <div class="Page">
   		<div class="edit">
   				<?php
   				$id=$_GET["id"];
   				?>
   			<form method="POST" action="requesthandlereditvacancies">
   				<script type="text/javascript">
   			 			window.onload = function()
    						{
      			 					CKEDITOR.replace('preview');
      			 					CKEDITOR.replace('content');
   							};
          </script>
          <br>
   				<input type = "text" name = "title" placeholder = "Введите новое название вакансии" required autocomplete="off"><br><br>
   				ID вакансии: <textarea name = "id"></textarea><br>
          Краткое описание вакансии: <textarea name = "preview"></textarea><br>
          Полное описание вакансии:  <textarea name = "content"></textarea><br>	
          <input type = "submit" name = "enter" value = "Изменить вакансию"> <input type = "reset" value = "Очистить поля">
   			</form>
   		</div>
    </div>	
  </div>
</div>
  <div class="footer">
    <?php 
      Footer();
    ?>
  </div>
</body>
</html>

Form handler code:

<?php 
  if($Module == 'requesthandlereditvacancies' and $_POST['enter'])
        {
          $_POST['title']   = FormChars($_POST['title']);
          $_POST['preview'] = FormChars($_POST['preview']);
          $_POST['content'] = FormChars($_POST['content']);
        
      if(!$_POST['title'] or !$_POST['preview'] or !$_POST['content']) 
        {
          MessageSend(1,'Ошибка валидации формы.');
        }					
      else 
        {
   				mysqli_query($CONNECT, "UPDATE vacancies SET  title = $_POST[title], preview = $_POST[preview], content = $_POST[content], regdate = NIW() WHERE id=$_POST[id]");
          MessageSend(3,'Данные изменены в базе данных.');	
        }		
    }
?>

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

S

Sergey Melnikov, 2016-02-05
@Elmanovyurik

D

Denis, 2016-02-05
@Ayahuaska

What is going on? Any mistakes?

S

Silm, 2016-02-05
@Silm

First: PDO
Second: Display the resulting SQL query on the screen, see what happens in it. If nothing suspicious, run it manually, look at the result.
Thirdly:
values for string type fields must be in quotes, NOW() should be used instead of NIW()