blackFan Posted September 12, 2011 Share Posted September 12, 2011 i need to make Registration Script With Photo Upload but the problem is the photo only save in temporary folder not in my database. here my php code <?php $name = $_POST['name']; $uname = $_POST['uname']; $email = $_POST['email']; $pwd = $_POST['pass']; $up = $_POST['fileToUpload']; $id= $_POST['id']; $insert ="INSERT INTO users (name,username,emailadd,password,userphoto) VALUES ('{$name}','{$uname}','{$email}',SHA1('{$pwd}'),'{$up}')" ; if(!empty($_FILES['fileToUpload'])) { if($_FILES['fileToUpload']['type']=="image/jpeg"); { $dest = "images/{$id}.jpg"; if (move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$dest)) { $a .=",userphoto ='{$dest}'"; print "File successfully uploaded"; } } } $q .= " WHERE userID='{$id}'"; require_once("dbconnect.php"); mysqli_query($conn,$insert); if(mysqli_affected_rows($conn) <= 0) { print "Unable to create account.Please <a href='reg.html'>click here</a>to try again."; } else { mysqli_close($conn); header("Location:login.php?sebab=newreg"); exit(); } mysqli_close($conn); ?> :'( :'( :'( :'( :'( Quote Link to comment Share on other sites More sharing options...
voip03 Posted September 12, 2011 Share Posted September 12, 2011 Your Code $dest = "images/{$id}.jpg"; Change it to $dest = "images/"; PS: Please code tag for posting code. Quote Link to comment Share on other sites More sharing options...
voip03 Posted September 12, 2011 Share Posted September 12, 2011 http://www.webcheatsheet.com/PHP/file_upload.php Quote Link to comment Share on other sites More sharing options...
aruns Posted September 12, 2011 Share Posted September 12, 2011 As your code <?php $name = $_POST['name']; $uname = $_POST['uname']; $email = $_POST['email']; $pwd = $_POST['pass']; $up = $_POST['fileToUpload']; $id= $_POST['id']; if(!empty($_FILES['fileToUpload'])) { if($_FILES['fileToUpload']['type']=="image/jpeg"); { $dest = "images/{$id}.jpg"; if (move_uploaded_file($_FILES['fileToUpload']['tmp_name'],$dest)) { $a .=",userphoto ='{$dest}'"; print "File successfully uploaded"; } } } $q .= " WHERE userID='{$id}'"; require_once("dbconnect.php"); $insert ="INSERT INTO users (name,username,emailadd,password,userphoto) VALUES ('{$name}','{$uname}','{$email}',SHA1('{$pwd}'),'{$dest}')" ; mysqli_query($conn,$insert); if(mysqli_affected_rows($conn) <= 0) { print "Unable to create account.Please <a href='reg.html'>click here</a>to try again."; } else { mysqli_close($conn); header("Location:login.php?sebab=newreg"); exit(); } mysqli_close($conn); ?> Quote Link to comment 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.