1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

update form with image

Discussion in 'PHP' started by macaela, Sep 18, 2010.

  1. macaela

    macaela Active Member

    Messages:
    181
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #21
    on the code above i have an update query but on the image field when i update it just insert in the database the word Array when is meant to update with the new name of the image and it doesnt upload the image either why does sends word Array to database??
     
    macaela, Sep 20, 2010 IP
  2. macaela

    macaela Active Member

    Messages:
    181
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #22
    Hi guys i gt the form to update database but know the only problem is it doesnt upload the new image help please


    <?php
    define('ROOT_DIR', './');
    define('THIS_SCRIPT', 'news');
    define('PROPER', TRUE);
    /**
    * include common files
    */
    include_once(ROOT_DIR. 'includes/common.inc.php');
    
        $id = $_GET['id']; 
        $name = $_GET['name'];
        $location = $_GET['location'];
        $date_of_birth = $_GET['date_of_birth'];
        $car_number = $_GET['car_number'];
        $favourite_track = $_GET['favourite_track'];
        $least_favourite_track = $_GET['least_favourite_track'];
        $achievements = $_GET['achievements'];
        $sponsors = $_GET['sponsors'];    
        $email = $_GET['email'];    
        $image  = $_REQUEST['image'];
        
        
        
    /// start uploading process
        define ("MAX_SIZE","100");
    // define the width and height for the thumbnail
    // note that theese dimmensions are considered the maximum dimmension and are not fixed,
    // because we have to keep the image ratio intact or it will be deformed
    define ("WIDTH","150");
    define ("HEIGHT","100");
    
    // this is the function that will create the thumbnail image from the uploaded image
    // the resize will be done considering the width and height defined, but without deforming the image
    function make_thumb($img_name,$filename,$new_w,$new_h)
    {
    //get image extension.
    $ext=getExtension($img_name);
    //creates the new image using the appropriate function from gd library
    if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
    $src_img=imagecreatefromjpeg($img_name);
    
    if(!strcmp("png",$ext))
    $src_img=imagecreatefrompng($img_name);
    
    //gets the dimmensions of the image
    $old_x=imageSX($src_img);
    $old_y=imageSY($src_img);
    
    // next we will calculate the new dimmensions for the thumbnail image
    // the next steps will be taken:
    // 1. calculate the ratio by dividing the old dimmensions with the new ones
    // 2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable
    // and the height will be calculated so the image ratio will not change
    // 3. otherwise we will use the height ratio for the image
    // as a result, only one of the dimmensions will be from the fixed ones
    $ratio1=$old_x/$new_w;
    $ratio2=$old_y/$new_h;
    if($ratio1>$ratio2) {
    $thumb_w=$new_w;
    $thumb_h=$old_y/$ratio1;
    }
    else {
    $thumb_h=$new_h;
    $thumb_w=$old_x/$ratio2;
    }
    
    // we create a new image with the new dimmensions
    $dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);
    
    // resize the big image to the new created one
    imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y);
    
    // output the created image to the file. Now we will have the thumbnail into the file named by $filename
    if(!strcmp("png",$ext))
    imagepng($dst_img,$filename);
    else
    imagejpeg($dst_img,$filename);
    
    //destroys source and destination images.
    imagedestroy($dst_img);
    imagedestroy($src_img);
    }
    
    // This function reads the extension of the file.
    // It is used to determine if the file is an image by checking the extension.
    function getExtension($str) {
    $i = strrpos($str,".");
    if (!$i) { return ""; }
    $l = strlen($str) - $i;
    $ext = substr($str,$i+1,$l);
    return $ext;
    }
    
    // This variable is used as a flag. The value is initialized with 0 (meaning no error found)
    //and it will be changed to 1 if an errro occures. If the error occures the file will not be uploaded.
    $errors=0;
    // checks if the form has been submitted
    if(isset($_GET['Submit']))
    {
    //reads the name of the file the user submitted for uploading
    $image=$_FILES['image']['name'];
    // if it is not empty
    if ($image)
    {
    // get the original name of the file from the clients machine
    $filename = stripslashes($_FILES['image']['name']);
    
    // get the extension of the file in a lower case format
    $extension = getExtension($filename);
    $extension = strtolower($extension);
    // if it is not a known extension, we will suppose it is an error, print an error message
    //and will not upload the file, otherwise we continue
    if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png"))
    {
    echo '<h1>Unknown extension!</h1>';
    $errors=1;
    }
    else
    {
    // get the size of the image in bytes
    // $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which the uploaded file was stored on the server
    $size=getimagesize($_FILES['image']['tmp_name']);
    $sizekb=filesize($_FILES['image']['tmp_name']);
    
    //compare the size with the maxim size we defined and print error if bigger
    if ($sizekb > MAX_SIZE*2024)
    {
    echo '<h1>You have exceeded the size limit!</h1>';
    $errors=1;
    }
    
    //we will give an unique name, for example the time in unix time format
    $image_name=time().'.'.$extension;
    //the new name will be containing the full path where will be stored (images folder)
    $newname="images/".$image_name;
    $copied = copy($_FILES['image']['tmp_name'], $newname);
    //we verify if the image has been uploaded, and print error instead
    if (!$copied)
    {
    echo '<h1>Copy unsuccessfull!</h1>';
    $errors=1;
    }
    else
    {
    // the new thumbnail image will be placed in images/thumbs/ folder
    $thumb_name='images/thumbs/'.$image_name;
    // call the function that will create the thumbnail. The function will get as parameters
    //the image name, the thumbnail name and the width and height desired for the thumbnail
    $thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
    }} }}    
        
        
    
        
    $query = "UPDATE driversnew SET name = '$name', location = '$location', date_of_birth='$date_of_birth', car_number='$car_number', favourite_track='$favourite_track', least_favourite_track='$least_favourite_track', achievements='$achievements', sponsors='$sponsors', email='$email', image='$image' WHERE id = '$id'";
    
    
    mysql_query($query) or die(mysql_error()); 
    // execute query 
     $result = mysql_query($query) ;
     //if there was a problem - get the error message and go back 
     if (!$result)
      {
         echo "There were errors :<br>". mysql_error();
      } 
      else //OK, then the insertion was successful
      
      {
        
    print "<p>The following records has been updated:  </p>";
    
        //Create a new query to display the new row in a table
        $query = "SELECT id, name, location, date_of_birth, car_number, favourite_track, least_favourite_track, achievements, sponsors, email, image FROM driversnew WHERE id = '$id' ";    $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 
        echo "<table cellpadding=10 border=1>";  
        while($row = mysql_fetch_array($result)) { 
              echo "<tr>"; 
         echo "<td>".$row["id"]."</td>";
         echo "<td><strong>" .$row["name"]."</strong></td>";
         echo "<td><strong>".$row["location"]."</strong></td>"; 
         echo "<td><strong>" .$row["date_of_birth"]."</strong></td>";
         echo "<td><strong>".$row["car_number"]."</strong></td>";
         echo "<td><strong>" .$row["favourite_track"]."</strong></td>";
         echo "<td><strong>".$row["least_favourite_track"]."</strong></td>"; 
         echo "<td><strong>" .$row["achievements"]."</strong></td>";
         echo "<td><strong>".$row["sponsors"]."</strong></td>";
         echo "<td><strong>" .$row["email"]."</strong></td>";
         echo "<td><strong>".$row["image"]."</strong></td>"; 
         echo "</tr>"; 
        } //End while
        echo "</table>"; 
           } //End Else insertion successful
    //End else successful Amendment     
    
    ?>
    PHP:
     
    macaela, Sep 20, 2010 IP
  3. macaela

    macaela Active Member

    Messages:
    181
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #23
    ok i finaly manage to get the form to update bt one foul if user doesnt send a new image the form will empty the previous is like it as long it press submit it send data empty if no new image uploaded how can i make so like if user doesnt modify the image to keep same image name on the database???
     
    macaela, Sep 20, 2010 IP