sandbudd Posted March 31, 2009 Share Posted March 31, 2009 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."; } ?> Link to comment https://forums.phpfreaks.com/topic/151927-solved-uploads-the-image-but-does-not-populate-the-database/ Share on other sites More sharing options...
Brian W Posted March 31, 2009 Share Posted March 31, 2009 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 Link to comment https://forums.phpfreaks.com/topic/151927-solved-uploads-the-image-but-does-not-populate-the-database/#findComment-797807 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.