Jump to content

[SOLVED] uploads the image but does not populate the database?


sandbudd

Recommended Posts

This code does upload the image to the image folder but does not populate the database.  I get no errors and it gives me the has been uploaded, and your information has been added to the directory  I am sure that I am missing something simple.

 


<?php

//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
$company=$_POST['company'];
$address=$_POST['address'];
$city=$_POST['city'];
$state=$_POST['state'];
$email=$_POST['email'];
$catagory=$_POST['catagory'];
$phone=$_POST['phone'];
$pic=($_FILES['photo']['name']);

// Connects to your Database
mysql_connect("", "sandbud_fwr", "") or die(mysql_error()) ;
mysql_select_db("") or die(mysql_error()) ;

//Writes the information to the database
mysql_query("INSERT INTO `customers` VALUES ('$company', '$address', '$city', '$state', '$email', '$catagory', '$phone', '$pic')") ;

//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";
}
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}
?> 

Try:

mysql_query("INSERT INTO `customers` VALUES ('$company', '$address', '$city', '$state', '$email', '$catagory', '$phone', '$pic')") or die(mysql_error());

More than likely it is a problem with your INSERT statement.

Also, remember to use mysql_real_escape_string() on variables being used in mysql statements other wise you are susceptible to getting a sql injection

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.