Registration with Image Upload Problem

[blackFan]

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);

 

 

?>

 

:'( :'( :'( :'( :'(

 

[voip03]

Your Code

  $dest = "images/{$id}.jpg";

 

Change it to

  $dest = "images/";

 

PS: Please code tag for posting code.

[voip03]

http://www.webcheatsheet.com/PHP/file_upload.php

[aruns]

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);

 

 

?>