PHP Forum

**moamahi** · 01:51 PM

Hi everybody,
I'm new here. I'm facing a problem bigger than me. I'd like to update/add a record of a mysql table with a php form. Everything work good until I change or insert the id (which is the primary key).
here the code

PHP Code:


			
<html>



<body>







<?php







$db = mysql_connect("localhost", "root", "password");



mysql_select_db("db",$db);







if ($submit) {



  // here if no ID then adding else we're editing



  if ($id) {



    $sql = "UPDATE proprietario SET id='$id',Nome='$Nome',Cognome='$Cognome',Indirizzo='$Indirizzo',Note='$Note' WHERE id=$id";



  } else {



    $sql = "INSERT INTO proprietario (id,Nome,Cognome,Indirizzo,Note) VALUES ('$id','$Nome','$Cognome','$Indirizzo','$Note')";



  }



  // run SQL against the DB



  $result = mysql_query($sql);



  echo "Record updated/edited!<p>";



} elseif ($delete) {



    // delete a record



    $sql = "DELETE FROM proprietario WHERE id=$id";    



    $result = mysql_query($sql);



    echo "$sql Record deleted!<p>";



} else {



  // this part happens if we don't press submit



  if (!$id) {



    // print the list if there is not editing



    $result = mysql_query("SELECT * FROM proprietario",$db);



    while ($myrow = mysql_fetch_array($result)) {



      printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PHP_SELF, $myrow["id"], $myrow["Nome"], $myrow["Cognome"]);



      printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["id"]);



    }



  }







  ?>



  <P>



  <a href="<?php echo $PHP_SELF?>">AGGIUNGI UN RECORD</a>



  <P>



  <form method="post" action="<?php echo $PHP_SELF?>">



  <?php







  if ($id) {



    // editing so select a record



    $sql = "SELECT * FROM proprietario WHERE id=$id";



    $result = mysql_query($sql);



    $myrow = mysql_fetch_array($result);



    $id = $myrow["id"];



    $Nome = $myrow["Nome"];



    $Cognome = $myrow["Cognome"];



    $Indirizzo = $myrow["Indirizzo"];



    $Note = $myrow["Note"];



    // print the id for editing







    ?>

<?php

    //<input type=hidden name="id" value="<?php echo $id ?>

    



    <?php



  }







  ?>



  id:<input type="Text" name="id" value="<?php echo $id ?>"><br>



  Nome:<input type="Text" name="Nome" value="<?php echo $Nome ?>"><br>



  Cognome:<input type="Text" name="Cognome" value="<?php echo $Cognome ?>"><br>



  Indirizzo:<input type="Text" name="Indirizzo" value="<?php echo $Indirizzo ?>"><br>



  Note:<input type="Text" name="Note" value="<?php echo $Note ?>"><br>



  <input type="Submit" name="submit" value="Inserisci le informazioni">



  </form>







<?php







}







?>







</body>



</html>

Thank you to all of you that will help me.
moamahi

**moamahi** · 08-10-2004, 11:49 AM

the parser did not work...
sorry
moamahi

**zscherween** · 08-10-2004, 12:00 PM

In your :
$sql = "UPDATE proprietario SET id='$id',Nome='$Nome',Cognome='$Cognome',Indirizzo ='$Indirizzo',Note='$Note' WHERE id=$id";

You can do it this way:

$sql = "UPDATE proprietario SET Nome='$Nome',Cognome='$Cognome',Indirizzo ='$Indirizzo',Note='$Note' WHERE id=$id";

No need to assign for id in update

**moamahi** · 08-10-2004, 12:55 PM

Thank you zscherween.
But the fact is that I would like to add record complite of id.
Or i'd like to change it.
Thank you
moamahi

**zscherween** · 08-10-2004, 01:01 PM

Quote:

Originally Posted by moamahi

Thank you zscherween.
But the fact is that I would like to add record complite of id.
Or i'd like to change it.
Thank you
moamahi

moamahi,
I think there's a logic problem with update statement.
If you want to change ID, you would have to reference the old ID first before changing the other fields.

Hope that helps.