Jump to content

Adnan628

New Members
  • Posts

    6
  • Joined

  • Last visited

    Never

Posts posted by Adnan628

  1. Ok, those links fugix gave are the manuals for the SQL commands you need.  In each case you will want "WHERE id = $id" to ensure that you update or delete only the requested data, and not any other.  Apart from that, updating and deleting is not much different from inserting new data.  The id can be passed with a hidden input in the form.

    Update.php=>>

    <?php
    $id=$_GET['id'];
    mysql_connect("localhost","admin","");
    mysql_select_db("simphp");
    $query="SELECT * FROM contents WHERE id='$id'";
    $result=mysql_query($query);
    $num=mysql_numrows($result);
    mysql_close();
    $i=0;
    while ($i < $num) 
    {
    $name=mysql_result($result,$i,"Name");
    $email=mysql_result($result,$i,"Email");
    $number=mysql_result($result,$i,"number");
    ?>
    <html><head></head><body>
    <form action="updated.php" method="post">
    <input type="hidden" name="ud_id" value="<? echo $id; ?>">
    Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br>
    Email: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
    Number: <input type="text" name="ud_number" value="<? echo $number; ?>"><br>
    </form></body></html>
    <?php $i++;}?>

     

    i got this:->

     

    Notice: Undefined index: id in D:\xampp\htdocs\simphp\update.php on line 2

     

    Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\simphp\update.php on line 7

  2. Hello there,

    I'm quite new on PHP language.I'm trying to make an simple Phone book apps.I added insert & show options in Phone book.Now i want to add "update & delete" option.How can i do that.

    This is add code:

    <?php
    mysql_connect("localhost","admin","");
    mysql_select_db("simphp");
    //Get Values from form
    $name=$_POST['name'];
    $email=$_POST['email'];
    $number=$_POST['number'];
    mysql_query("insert into phonebook(name,email,number) values('$name','$email','$number')");
    echo"Saved Sucessfully";
    echo "<br/>";
    echo '<a href="index.php/">Homepage</a>';
    echo "<br/>";
    echo '<a href="select.php/">Show Data</a>';
    echo "<br/>";
    echo '<a href=update.php>Update</a>';
    mysql_close();
    ?>

    Show.php=>>

    <?php
    mysql_connect("localhost","admin","");
    mysql_select_db("simphp");
    $query="select *from phonebook";
    $result=mysql_query($query);
    $num=mysql_numrows($result);
    echo"Number of records Stored:$num";
    $i=0;
    while($i<$num)
    {
    
    $name=mysql_result($result,$i,"Name");
    $email=mysql_result($result,$i,"Email");
    $number=mysql_result($result,$i,"number");
    echo "<br/>";
    echo "Name  :<b> $name </b><br/>";
    echo "<br/>";
    echo "Email : <b>$email</b> <br/>";
    echo "<br/>";
    echo "Phone :<b>$number</b><br/>";
    echo '<a href=update.php>Update</a>';
    
    $i++;
    }
    ?>

     

    8)

    How can i update and delete data?? :confused:help me :-[

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.