Update in database not working

Question

Man update in the bank does not work, follows codes:

php student.

<form method="post" action="?acao=save&id_aluno=<?php echo $id; ?>">
    <?php echo $pegaid; ?>
    <input type="text" name="ID" class="txt-medium bradius" value="<?php echo $id; ?>"/>
    <input type="text" name="Nome_completo" class="txt-medium bradius" value="<?php echo $full_name; ?>"/>
    <input type="submit" value=" Salvar " class="btn-save-medium" />
</form>

header.php

if($_GET["acao"] == ("save")) {
     $startaction = 6;
}

php Inserts.

include 'header.php';

  if($startaction == 6){
    if($acao == "save") {
      $pegaid = $_GET['id_aluno'];
            $pegaidpost = $_POST['ID'];
       $update_full_name = $_POST['Nome_completo'];
              $update_data = "UPDATE alunos SET Nome_completo = '$update_full_name' WHERE ID = '$pegaid'";
        if($update_data) {
          echo"<script> alert('Dados atualizados com sucesso'); </script>";
        } else {
          echo"<script> alert('Dados NÃO atualizados'); </script>";
        }
    }
}

I looked up the name of the field in my database, it’s Nome_completo normal, just like this in the parameter name="Nome_completo";

Answer 1

SUGGESTION :

• First : The ID is an integer value ... Check if '$pegaid' return a character or an integer value here : "... WHERE ID = '$pegaid'".

• Second : Its connection to the BD is well made ?

Answer 2

Your connection to the bank is in that header.php?

And on that line if($update_data) { it should be like this if(mysql_query($update_data)) {

I hope I’ve helped :)

Answer 3

In your code, besides not having the code for the connection, mysql_connect there is the mysql_query who would be responsible for taking your variable $update_data and pass it as SQL command to your base.