Edit button

Discussion in 'PHP' started by Alice24, Apr 6, 2011.

  1. #1
    I have a simple issue, i don't know where to put the code for edit
    here is the code that search for data in Mysql DATABASE
    <?php
    require_once('config.php');
    
    if (isset($_POST['Search'])) {
    
    $id=$_POST['id'];
    
    
    $result = mysql_query("SELECT * FROM filme WHERE id='$id'  ");
    
     while($rand = mysql_fetch_array($result))
      {
      
     $x="<b><font color='red'>    </font></b>";
     echo '
    <div id="subtitrare">
          <div id="side-head"> 
          <h2><a  title="Download Subtitrare '.$rand['nume'].' "> '.$rand['nume'].' </a></h2> 
          </div>
           <img id="poster" src=" '.$rand['poza'].' " title=" '.$rand['nume'].' "/>   
              <div id="info">
              <b>Nume:</b><br> <input type="text" name="nume" size="50" value="'.$rand['nume'].'" maxlength="120"> <br>
              
              <b>Tip:</b><br> <input type="text" name="tip" size="50" value="'.$rand['tip'].'" maxlength="120"> <br>
              <b>An:</b> <br><input type="text" name="an" size="50" value="'.$rand['an'].'" maxlength="120"> <br>
              <b>Data:</b><br> <input type="text" name="data" size="50" value="'.$rand['data'].'" maxlength="120"> <br>
              <b>YOUTUBE:</b><br> <input type="text" name="youtube" size="50" value="'.$rand['youtube'].'" maxlength="120"> <br><br>
              <b>IMDB:</b> <input type="text" name="imdb" size="50" value="'.$rand['imdb'].'" maxlength="120"> <br><br>
              <b>TEXT:</b> <input type="text" name="www" size="50" value="'.$x.'" maxlength="120"> <br>
              <b>Comentariu:</b> <br> <TEXTAREA NAME="comentariu"  COLS=80 ROWS=15>'.$rand['comentariu'].'</TEXTAREA><br>
     </div> </div> '  ; 
     
     
    
    
      }
    }
    
    ?>
    
    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    
    <br>ID:<input type="text" name="id" maxlength="60"><br>
    
    
    <br><input type="submit" name="Search" value="Search">
    PHP:
    and here is the code that should UPDATE the data into the Mysql
    <?
    
    
    
    if (isset($_POST['Edit'])) {
    
    $enume=$_POST['nume'];
    $etip=$_POST['tip'];
    $ean=$_POST['an'];
    $eyoutube=$_POST['youtube'];
    $eimdb=$_POST['imdb'];
    $edata=$_POST['data'];
    $ecomentariu=$_POST['comentariu'];
    
    $id=$_POST['user'];
    $sql = "UPDATE filme SET nume='$enume', tip='$etip', an='$ean', youtube='$eyoutube', imdb='$eimdb', data='$edata', comentariu='$ecomentariu' WHERE id='$id' ";    
            
           
    
    echo "<br>$id was edited!<p>";
    }
    
    
    ?>
    PHP:
    but i don't know where to put it ...
     
    Alice24, Apr 6, 2011 IP
  2. Alice24

    Alice24 Greenhorn

    Messages:
    59
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #2
    i tryed many ways but still can't find what is wrong
    if i put the update befoare the code like this , still does nothing
    
    <?php
    require_once('config.php');
    
    if (isset($_POST['Edit'])) {
    $id=$_POST['id'];
    $enume=$_POST['nume'];
    $etip=$_POST['tip'];
    $ean=$_POST['an'];
    $eyoutube=$_POST['youtube'];
    $eimdb=$_POST['imdb'];
    $edata=$_POST['data'];
    $ecomentariu=$_POST['comentariu'];
    
    
    mysql_query("UPDATE filme SET nume='$enume', tip='$etip', an='$ean', youtube='$eyoutube', imdb='$eimdb', data='$edata', comentariu='$ecomentariu' WHERE id='$id' ");    
            
    echo "<br>$enume cu $id was edited!<p>";
    }
    
    
    if (isset($_POST['Search'])) {
    
    $id=$_POST['id'];
    
    $result = mysql_query("SELECT * FROM filme WHERE id='$id'  ");
    
     while($rand = mysql_fetch_array($result))
      {
      
     $x="<b><font color='red'>    </font></b>";
     echo '
    <div id="subtitrare">
          <div id="side-head"> 
          <h2><a  title="Download Subtitrare '.$rand['nume'].' "> '.$rand['nume'].' </a></h2> 
          </div>
           <img id="poster" src=" '.$rand['poza'].' " title=" '.$rand['nume'].' "/>   
              <div id="info">
              <b>Nume:</b><br> <input type="text" name="nume" size="50" value="'.$rand['nume'].'" maxlength="120"> <br>
              <b>Tip:</b><br> <input type="text" name="tip" size="50" value="'.$rand['tip'].'" maxlength="120"> <br>
              <b>An:</b> <br><input type="text" name="an" size="50" value="'.$rand['an'].'" maxlength="120"> <br>
              <b>Data:</b><br> <input type="text" name="data" size="50" value="'.$rand['data'].'" maxlength="120"> <br>
              <b>YOUTUBE:</b><br> <input type="text" name="youtube" size="50" value="'.$rand['youtube'].'" maxlength="120"> <br><br>
              <b>IMDB:</b> <input type="text" name="imdb" size="50" value="'.$rand['imdb'].'" maxlength="120"> <br><br>
              <b>TEXT:</b> <input type="text" name="www" size="50" value="'.$x.'" maxlength="120"> <br>
              <b>Comentariu:</b> <br> <TEXTAREA NAME="comentariu"  COLS=80 ROWS=15>'.$rand['comentariu'].'</TEXTAREA><br>
    
    <a href="update.php?id='.$rand['id'].'">Update</a> 
     </div> </div> '  ; 
     
     
    
    
      }
    }
    
    ?>
    
    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    
    <br>ID:<input type="text" name="id" maxlength="60"><br>
    <br><input type="submit" name="Search" value="Search"> <input type="submit" name="Edit" value="Edit">
    PHP:
     
    Alice24, Apr 6, 2011 IP
  3. Alice24

    Alice24 Greenhorn

    Messages:
    59
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    Pls Help :(
     
    Alice24, Apr 10, 2011 IP