Advanced Search

Results 1 to 2 of 2

Thread: Updating database table problem

  1. #1
    Join Date
    Oct 2009
    Posts
    37
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Default Updating database table problem

    I am trying to create a news manager with admin control to edit, delete, add functions, every thing is working fine instead of editing table data.

    i need help from any experts.
    here is my update.php and update_ac.php


    update.php
    PHP Code:

    <?php
    $host
    ="localhost"// Host name 
    $username=""// Mysql username 
    $password=""// Mysql password 
    $db_name="test"// Database name 
    $tbl_name="news_manager"// Table name

    // Connect to server and select database.
    mysql_connect("$host""$username""$password")or die("cannot connect"); 
    mysql_select_db("$db_name")or die("cannot select DB");

    // get value of id that sent from address bar
    $id=$_GET['id'];


    // Retrieve data from database 
    $sql="SELECT * FROM $tbl_name WHERE id='$id'";
    $result=mysql_query($sql);

    $rows=mysql_fetch_array($result);
    ?>
    <table width="567" border="1" align="center" cellspacing="0">
      <form enctype="multipart/form-data" action="update_ac.php" method="post">
      <tr>
        <td><strong>Edit</strong></td>
        <td><input name="title" type="text" id="title" value="<? echo $rows['id']; ?>" size="10"></td>
      </tr>
      <tr>
        <td width="89">Title</td>
        <td><input name="title" type="text" id="title" value="<? echo $rows['title']; ?>" size="40"></td>
      </tr>
      <tr>
        <td><strong>Sub Title</strong></td>
        <td><input name="subtitle" type="text" id="subtitle" value="<? echo $rows['subtitle']; ?>" size="40"></td>
      </tr>
      
        <tr>
        <td>News</td>
        <td rowspan="2"><textarea name="news" cols="65" rows="9" id="news"><? echo $rows['news']; ?></textarea>      </textarea></td>
      </tr>
      
      
      
      
        <tr>
          <td>&nbsp;</td>
        </tr>
      
        <tr>
          <td>Read More</td>
          <td rowspan="2"><textarea name="fulltext" cols="65" rows="9" id="fulltext"><? echo $rows['fulltext']; ?></textarea>      </textarea></td>
        </tr>
            <tr>
              <td>&nbsp;</td>
        </tr>
           <tr>
             <td height="100">Image</td>
             <td class="image_wrapper"><? echo "<img src=http://localhost:8888/doctorsByspeciality/images/".$rows['photo'] ."> <br>"?></td>
        </tr>
      
      
      
        <tr>
        <td height="31">Change Photo</td>
        <td><input type="file" name="photo"></td>
        </tr>
      
          <tr>
        <td>&nbsp;</td>
        <td><input type="submit" name="Submit" value="Submit"></td>
        </tr>
      </form>
    </table>

    update_ac.php
    PHP Code:
    <?php


    $host
    ="localhost"// Host name 
    $username=""// Mysql username 
    $password=""// Mysql password 
    $db_name="test"// Database name 
    $tbl_name="news_manager"// Table name

    // Connect to server and select database.
    mysql_connect("$host""$username""$password")or die("cannot connect"); 
    mysql_select_db("$db_name")or die("cannot select DB");


     
    //This is the directory where images will be saved 
     
    $target "../images/"
     
    $target $target basename$_FILES['photo']['name']); 
     
     
    //This gets all the other information from the form 

     
    $title=$_POST['title']; 
     
    $subtitle=$_POST['subtitle']; 
     
    $news=$_POST['news']; 
     
    $photo=($_FILES['photo']['name']); 
     
    $fulltext=$_POST['fulltext'];
     
     


    // update data in mysql database 
    $sql="UPDATE news_manager SET title='$title', subtitle='$subtitle', news='$news', photo='$photo', fulltext='$fulltext' WHERE id='$id'";

               

    $result=mysql_query($sql);

     
    //Writes the photo to the server 
     
    if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) 
     { 
     
     
    //Tells you if its all ok 
     
    echo "The file "basename$_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"
      echo 
    "Successful";

      echo 
    "<BR>";
      echo 
    "<a href='admin1.php'>Go Back To Admin Panel</a>";
     } 
     else { 
     
     
    //Gives and error if its not 
     
    echo "Sorry, there was a problem uploading your file."

     } 




    ?>

    Thank you.

  2. #2
    Join Date
    Nov 2011
    Location
    Buenos Aires
    Posts
    15
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    Hello,
    Did you check the column lengh?

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •