Boxerman Posted August 12, 2011 Share Posted August 12, 2011 <?php session_start(); include("header.php"); include "users/functions.php"; //This is the directory where images will be saved $target = "users/images/"; $target = $target . basename( $_FILES['photo']['name']); //This gets all the other information from the form $username=$_SESSION['username']; $title=$_POST['title']; $about=$_POST['about']; $pic=($_FILES['photo']['name']); // Connects to your Database mysql_connect("localhost", "root", "") or die(mysql_error()) ; mysql_select_db("") or die(mysql_error()) ; //Writes the information to the database mysql_query("INSERT INTO `user_pictures` VALUES ('$username', '$title', '$about', '$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."; } ?> <html> <head> <title>upload image</title> </head> <body> <form enctype="multipart/form-data" action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST"> Title: <input type="text" name="name"><br> About: <input type="text" name = "about"><br> Photo: <input type="file" name="photo"><br> <input type="submit" value="Add"> </form> </body> </html> <? include ("footer.php"); ?> 2 things wrong. 1) It's displaying "Sorry, there was a problem uploading your file." before i even upload. 2) When uploading file, it refreshes and says added to database.. but it hasnt? can anyone see the problem.. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/ Share on other sites More sharing options...
JohnOP Posted August 12, 2011 Share Posted August 12, 2011 Put the code in the provided code blocks and maybe we can see the problem Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/#findComment-1256168 Share on other sites More sharing options...
Boxerman Posted August 12, 2011 Author Share Posted August 12, 2011 <?php session_start(); include("header.php"); include "users/functions.php"; if (empty($_SESSION['username'])){ echo "<meta http-equiv='refresh' content='0;URL=index.php' />"; exit(); } //get data $query = mysql_query("SELECT * FROM users WHERE username='$username'"); $user=mysql_fetch_object($query); //This is the directory where images will be saved $target = "users/images/"; $target = $target . basename( $_FILES['photo']['name']); //This gets all the other information from the form $username=$_SESSION['username']; $title=$_POST['title']; $about=$_POST['about']; $pic=($_FILES['photo']['name']); // Connects to your Database mysql_connect("localhost", "root", "") or die(mysql_error()) ; mysql_select_db("") or die(mysql_error()) ; //Writes the information to the database mysql_query("INSERT INTO `user_pictures` VALUES ('$username', '$title', '$about', '$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."; } ?> <html> <head> <title>upload image</title> </head> <body> <form enctype="multipart/form-data" action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST"> Title: <input type="text" name="name"><br> About: <input type="text" name = "about"><br> Photo: <input type="file" name="photo"><br> <input type="submit" value="Add"> </form> </body> </html> <? include ("footer.php"); ?> So sorry guys, newbie error... Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/#findComment-1256286 Share on other sites More sharing options...
chintansshah Posted August 12, 2011 Share Posted August 12, 2011 Can you check that users/images folder has 777 permission to upload a file! Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/#findComment-1256360 Share on other sites More sharing options...
Boxerman Posted August 12, 2011 Author Share Posted August 12, 2011 I have checked and i have put it to 777 and it still doesnt work. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/#findComment-1256621 Share on other sites More sharing options...
Boxerman Posted August 12, 2011 Author Share Posted August 12, 2011 Update (as i cant edit my post sorry guys) I've now got it working on uploading images to folder, but its not adding it to the database, <?php session_start(); include("header.php"); include "users/functions.php"; if (empty($_SESSION['username'])){ echo "<meta http-equiv='refresh' content='0;URL=index.php' />"; exit(); } $open=$_GET['open']; $edit=$_GET['edit']; //get data $query = mysql_query("SELECT * FROM users WHERE username='$username'"); $user=mysql_fetch_object($query); //This is the directory where images will be saved $target = "users/images/"; $target = $target . basename( $_FILES['photo']['name']); //This gets all the other information from the form $username=$_SESSION['username']; $title=$_POST['title']; $about=$_POST['about']; $pic=($_FILES['photo']['name']); // Connects to your Database mysql_connect("localhost", "root", "") or die(mysql_error()) ; mysql_select_db("db") or die(mysql_error()) ; //Writes the information to the database mysql_query("INSERT INTO `user_pictures` VALUES ('$username', '$title', '$about', '$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."; } ?> <html> <head> <title>upload image</title> </head> <body> <form enctype="multipart/form-data" action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST"> Title: <input type="text" name="name"><br> About: <input type="text" name = "about"><br> Photo: <input type="file" name="photo"><br> <input type="submit" value="Add"> </form> </body> </html> <? include ("footer.php"); ?> Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/#findComment-1256637 Share on other sites More sharing options...
Boxerman Posted August 13, 2011 Author Share Posted August 13, 2011 File upload working but the adding to database is not, could someone please help? Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/#findComment-1256675 Share on other sites More sharing options...
jcbones Posted August 13, 2011 Share Posted August 13, 2011 Add de-bugging to your query call. mysql_query("INSERT INTO `user_pictures` VALUES ('$username', '$title', '$about', '$pic')") or trigger_error(mysql_error()); Quote Link to comment https://forums.phpfreaks.com/topic/244557-image-uploader-says-it-uploaded/#findComment-1256678 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.