Php/Mysql Image Problem

[csun]

hello, i using the code above i just copy and paste it and change the variables but it is not working the image/ photo is not stored in the databse.. below is the code

Code: Select all

<?php 
       if (array_key_exists('_submit_check', $_POST))
{
    //This is the directory where images will be saved
    $target = "../cj";
    $target = $target . basename( $_FILES['photo']['couponstore']); 
    
    //This gets all the other information from the form 
    
                    $couponstore=$_POST['couponstore'];
                    $coupontitle=$_POST['coupontitle'];
                    $website=$_POST['website'];
                    $pic=($_FILES['photo']['couponstore']); 
                    $detail=$_POST['detail'];
                    $days=$_POST["days"];
                    $date=$_POST['date'];
                    $feat=$_POST['feat'];
                    $sto_cat=$_POST['sto_cat'];
            
    //Writes the information to the database 
   mysql_query("INSERT INTO `deals`  VALUES ('$couponstore', '$coupontitle', '$website', '$detail', '$days', '$date', '$feat', '$sto_cat', '$pic')") ; 
   
            //Writes the photo to the server
        if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
        { 
    //Tells you if its all ok 
    $msg = "The file ". basename( $_FILES['uploadedfile']['couponstore']). " has been uploaded, and your information has been added to the directory"; 
    } 
    else { 
    //Gives and error if its not 
    $error = "Sorry There Was A Problem Uploading The File."; 
    } 
         } 
    ?>

[Rakuli]

Okay, then it is probably your INSERT query

change the line

mysql_query("INSERT INTO `deals` VALUES ('$couponstore', '$coupontitle', '$website', '$detail', '$days', '$date', '$feat', '$sto_cat', '$pic')") ;

to mysql_query("INSERT INTO `deals` VALUES ('$couponstore', '$coupontitle', '$website', '$detail', '$days', '$date', '$feat', '$sto_cat', '$pic')")
or
die (mysql_error());

And see if you are getting any MYSQL errors, you aren't escaping any of your data so there is a good chance something is going wrong with the query

[csun]

helo thanks for the response i follow the instruction there is an error occur

errror:

Column count doesn't match value count at row 1

[Rakuli]

Okay, so you need to make sure that you have the right amount of columns in your MYSQL table.. Your query specifies 9 values so you have to make sure that your table has only 9 columns and you are inserting them in the right order...

If you have more than 9 columns or want a different order you will have to specify the column names in your query..

eg

PHP: Select all

mysql_query("INSERT INTO deals (column1, column2, column3, column4, column5, column6, column7, column8, column9)  VALUES ('$couponstore', '$coupontitle', '$website', '$detail', '$days', '$date', '$feat', '$sto_cat', '$pic')") ; 

Replacing 'columnx' with the name of the columns in your table..

Cheers,

[csun]

helllo

i have a script below in which storing of image in the database but there i have a problem with the script it will not store images into the dbase

PHP: Select all

<?php 
       if (array_key_exists('_submit_check', $_POST))
{
    
if ($_FILES) {
  $image_types = Array ("../cj/jpeg", "../cj/gif");
                        
  if (is_uploaded_file ($_FILES[userfile][tmp_name])) { 
    $userfile  = addslashes (fread 
                 (fopen ($_FILES["userfile"]["tmp_name"], "r"), 
                 filesize ($_FILES["userfile"]["tmp_name"])));
    $file_name = $_FILES["userfile"]["name"];
    $file_size = $_FILES["userfile"]["size"];
    $file_type = $_FILES["userfile"]["type"];

                    $couponstore=$_POST['couponstore'];
                    $coupontitle=$_POST['coupontitle'];
                    $website=$_POST['website'];
                    $detail=$_POST['detail'];
                    $days=$_POST["days"];
                    $date=$_POST['date'];
                    $feat=$_POST['feat'];
                    $sto_cat=$_POST['sto_cat'];

    if (in_array (strtolower ($file_type), $image_types)) {
      $sql = "INSERT INTO deals "
             . "(couponstore, coupontitle, image_type, image, image_size, image_name, website, detail, days, date, feat, sto_cat)  ";
      $sql.= "VALUES (";
      $sql.= "'{$couponstore}','{$coupontitle}','{$website}','{$detail}','{$date}','{$days}','{$feat}','{$sto_cat}','{$file_type}', '{$userfile}', '{$file_size}', "
             . "'{$file_name}', NOW())";
             
        $result=mysql_query($sql,$dbh) or die(mysql_error());
      Header("Location:".$_SERVER["PHP_SELF"]);
      exit(); 
        } 
    }
  }
} 
    ?>

Please anyone need your help im stack..

[Rakuli]

Hi There - please post questions relating to the same code into the same thread rather than create a new one.

Okay so you have defined 12 columns but have 13 values in your query so you would be getting a MySQL column/value count error

[csun]

ok thanks i have put all the 9 columns in place but when i run the script to my server this is the error:

Warning: move_uploaded_file(../cj) [function.move-uploaded-file]: failed to open stream: Is a directory in /home/simply22/public_html/admin/deal/form.php on line 33

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpCj3Ne3' to '../cj' in /home/simply22/public_html/admin/deal/form.php on line 33

[Rakuli]

You need to use the absolute path to the folder you want to upload to...

eg.

$target = '/home/users/path/to/cj';

or

$target = 'C:/path/to/cj';

or if the folder is in the root of the site

$target = '/cj';

[csun]

yes, i got the absolute path of my folder but the problem is the image is not store in the mysgl database folder how store the image inside mysql database folder?

[Rakuli]

You would need to specify the path of the mysql folder.

The images don't actually go into the database -- unless you store them as a binary string.

The point of thes script is to store the location of the image in the database so PHP knows where to acess it when you retrieve later.

[csun]

how to create binary string and store the images into the database?

[Rakuli]

the basics are quite simple.

You need to have the mysql column holding the image set to receive binary data.

You can do this by making the column type LONGBLOB.

Then after checking that the file is a valid uploaded one, read it into a string and add it to the database like a normal string..

eg.

$data = mysql_real_escape_string(fread(fopen($_FILES[userfile][tmp_name], "r"), filesize($form_data)));

then add $data as a string like normal