PHP - Upload And View Image In Php With Mysql

Hello

I am having problems uploading an image through a HTML form. I want the image to be uploaded to the server and the image name to be written to the mysql database.

Below is the code I am using:
Code: [Select]
<?php
if (isset($_POST['add'])){
   
   echo "<br /> add value is true";
      $name = $_POST['name'];   
      $description = $_POST['description'];   
      $price = $_POST['price'];
      $category_id = $_POST['category_name'];
      $image = $_FILES['image']['name'];   
      
      //file path of the image upload
      $filepath = "../images/";
      //mew name for the image upload
      $newimagename = $name;
      //new width for the image
      $newwidth = 100;
      //new height for the image
      $newheight = 100;
      
      include('../includes/image-upload.php');
      
      
      mysql_query("INSERT INTO item (item_name, item_description, item_price, item_image)
      VALUES ('$name','$description','$price','$image')"); ?>

Here is the image-upload.php file code:

Code: [Select]
<?php

//assigns the file to the image
$image =$_FILES["image"]["name"];
$uploadedfile =$_FILES["image"]["tmp_name"];

if ($image) {
   //retrieves the extension type from image upload
   $extension = getextension($image);
   //converts extension to lowercase
   $extension = strtolower($extension);
   
   //create image from uploaded file type
   if($extension=="jpg" || $extension=="jpeg") {
      $uploadedfile = $_FILES['image']['tmp_name'];
      $src = imagecreatefromjpeg($uploadedfile);
   }else if($extension=="png") {
      $uploadedfile = $_FILES['image']['tmp_name'];
      $src = imagecreatefrompng($uploadedfile);
   }else{
      $src = imagecreatefromgif($uploadedfile);
   }
   
   //creates a list of the width and height of the image
   list($width,$height)=getimagesize($uploadedfile);
   
   //adds color to the image
   $tmp = imagecreatetruecolor($newwidth,$newheight);
   
   //create image
   imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);
   
   //set file name
   $filename = $filepath.$newimagename.".".$extension;
   $imagename = $newimagename.".".$extension;
   //uploads new file with name to the chosen directory
   imagejpeg($tmp,$filename,100);
   
   //empty variables
   imagedestroy($src);
   imagedestroy($tmp);
   
}


?>
Any help would be appreciated, fairly new to all this!

Thanks!!!

Hello freaks!

Im new to this forum, but im not all that new to PHP and MySQL.
Although there's been some years since the last time I used it, so don't go all freaky on me if I dont do this right

Let's go on-topic:
Im in progress of making an internal web-page for me and my colleagues to make things a bit easier for us.
I am making an database of our different projects, and I need some help with the input form - as I need to upload an image to the server, and store the path in the MySQL database.

In my input form, I need to store information from text fields, and I need to upload an image to the server and store the path in the database.
Before I can even start to code this (although I have coded the input forum without the upload), I need to know what would be the best way to do this.
I guess there are several ways.. What would the expert do (That's you right?)?

Should I have the information input, and image upload in the same form, or should I make a second form (maybe on a different page) for the upload?
Is it necessary with two tables, one for the info and one for the image path, and then tie them together with the imageID, or is it fine to use just one table?

Any thoughts would be appreciated!

<!-- TechThat -->

what's wrong with this ?  i can't upload

Okay, so I found this code on-line that uploads images via a form, inserts them in to MySQL and displays the images on the page.  It works great!  Problem is, I spent a long time hacking this script to make it work with my site just to realize it did not re-size the image after it uploaded (dumb me).  I have found other code that do this but I really do not want to start over at this point and my level of expertise with PHP are a step below what I need to figure this out.  I am attaching the "original" code.  If anyone knows how to add the necessary lines of code to make every image re-size (reduce) itself.  I would very much appreciate it.  Thanks

       <?php
    $con=mysql_connect("localhost", "root", "rootwdp")or die("cannot connect");
    mysql_select_db("student",$con)or die("cannot select DB");
     
    if(isset($_POST['upload']))
    {
    $img=$_FILES["image"]["name"];
    foreach($img as $key => $value)
    {
    $name=$_FILES["image"]["name"][$key] ;
    $tname=$_FILES["image"]["tmp_name"][$key];
    $size=$_FILES["image"]["size"][$key];
    $oext=getExtention($name);
    $ext=strtolower($oext);
    $base_name=getBaseName($name);
    if($ext=="jpg" || $ext=="jpeg" || $ext=="bmp" || $ext=="gif"){
    if($size< 1024*1024){
    if(file_exists("upload/".$name)){
    move_uploaded_file($tname,"upload/".$name);
    $result = 1;
    list($width,$height)=getimagesize("upload/".$name);
    $qry="select id from img where `img_base_name`='$base_name' and `img_ext`='$ext'";
    $res=mysql_fetch_array(mysql_query($qry));
    $id=$res['id'];
    $qry="UPDATE img SET `img_base_name`='$base_name' ,`img_ext`='$ext' ,`img_height`='$height' ,`img_width`='$width' ,`size`='$size' ,`img_status`='Y' where id=$id";
    mysql_query($qry);
    echo "Image '$name' updated<br />";
    }
    else{
    move_uploaded_file($tname,"upload/".$name);
    $result = 1;
    list($width,$height)=getimagesize("upload/".$name);
    $qry="INSERT INTO `img`(`id` ,`img_base_name` ,`img_ext` ,`img_height` ,`img_width`, `size` ,`img_status`)VALUES (NULL , '$base_name', '$ext', '$height', '$width', '$size', 'Y');";
    mysql_query($qry);
    echo "Image '$name' uploaded<br />";
    }
    }
    else{
    echo "Image size excedded.<br />File size should be less than 1Mb<br />";
    }
    }
    else{
    echo "Invalid file extention '.$oext'<br />";
    }
    }
    }
     
    function getExtention($image_name){
    return substr($image_name,strrpos($image_name,'.')+1);
    }
    function getBaseName($image_name){
    return substr($image_name,0,strrpos($image_name,'.'));
    }
    ?>
     
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Untitled Document</title>
    <script type="text/javascript">
    function addItems()
    {
    var table1 = document.getElementById('tab1');
    var newrow = document.createElement("tr");
    var newcol = document.createElement("td");
    var input = document.createElement("input");
    input.type="file";
    input.name="image[]";
    newcol.appendChild(input);
    newrow.appendChild(newcol);
    table1.appendChild(newrow);
    }
    function remItems()
    {
    var table1 = document.getElementById('tab1');
    var lastRow = table1.rows.length;
    if(lastRow>=2)
    table1.deleteRow(lastRow-1);
    }
    </script>
     
    <style type="text/css">
     
    <a class="tooltip" and them url href="/http.www.anyurl.com" </a>
     
    a.tooltip:hover span{display:inline; position:absolute; border:2px solid #cccccc; background:#efefef; color:#333399;}
    a.tooltip span
    {display:none; padding:2px 3px; margin-left:8px; width:150px;}
     
    </style>
     
    </head>
     
    <body>
     
    <form method="post" action="" enctype="multipart/form-data">
    <table align="center" border="0" id="tab1">
    <tr>
    <td width="218" align="center"><input type="file" name="image[]" /></td>
    <td width="54" align="center"><img src="Button-Add-icon.png" alt="Add" style="cursor:pointer" onclick="addItems()" /></td>
    <td><img src="Button-Delete-icon.png" alt="Remove" style="cursor:pointer" onclick="remItems()" /></td>
    </tr>
    </table>
     
    <table align="center" border="0" id="tab2">
    <tr><td align="center"><input type="submit" value="Upload" name="upload" /></td></tr>
    </table>
    </form>
    <table border="0" style="border:solid 1px #333; width:800px" align="center"><tr><td align="center">
     
    <iframe style="display:none" name="if1" id="if1"></iframe>
     
    <?
    $qry="select * from img where img_status='Y' order by id";
    $res=mysql_query($qry);
    $i=0;
    if(mysql_num_rows($res)){ ?>
    <div align="center"><ul style="width:650px; border: 0px">
    <?
    while($fetch=mysql_fetch_array($res)){
    $hratio=120/$fetch['img_height'];
    $wratio=120/$fetch['img_width'];
    $ratio=($hratio < $wratio) ? $hratio : $wratio;
    $hth=$fetch['img_height']*$ratio;
    $wth=$fetch['img_width']*$ratio;
    ?>
    <li style="width:120px; height:180px; border:0px solid #333;float:left;list-style:none outside none; padding-right:5px;"><img src="upload/<? echo $fetch['img_base_name'].'.'.$fetch['img_ext']; ?>" width="<? echo $wth; ?>" height="<? echo $hth; ?>" title="<? echo "image : ".$fetch['img_base_name'].".".$fetch['img_ext']; ?>" /><br />
    <?
    if($i==0)
    $fp=fopen("fileInfo.txt",'w');
    else
    $fp=fopen("fileInfo.txt",'a');
    fwrite($fp,"Image : ".++$i ."\r\n");
    fwrite($fp,"Name : ".$fetch['img_base_name'].".".$fetch['img_ext']."\r\n");
    fwrite($fp,"width X height :
    ".$fetch['img_width']." X ".$fetch['img_height']."\r\n");
    fwrite($fp,"Size : ".round($fetch['size']/1024,1)."Kb\r\n");
    fwrite($fp,"____________________________________\r\n");
    fclose($fp);
     
    echo $fetch['img_base_name'].".".$fetch['img_ext'].'<br />';
    echo $fetch['img_width'].' X ';
    echo $fetch['img_height'].'<br />';
    echo round($fetch['size']/1024,1) .'Kb';
    ?>
    </li>
    <?
    }?>
    </ul>
    </div><? }?>
     
    </td></tr></table>
    </body>
    </html>

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=328623.0