please help me

[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 click hereto try again."; } else { mysqli_close($conn); header("Location:login.php?sebab=newreg"); exit(); } mysqli_close($conn); ?>

[blackleo]

Hi,

This is how you can store image in mysql database

$handle = fopen(“testpic.jpg”, “rb”);
$img = fread($handle, filesize(‘testpic.jpg’));
fclose($handle);
//die($img);

$img = base64_encode($img);

database_connect
(‘localhost’, ‘root’, ‘admin’, ‘img_test’, &$db_selected, &$connection);

$sql = “insert into pictures values(null,’$img’,‘jpg’,‘female’)”;

mysql_query($sql) or die(‘Bad Query at 12’);

echo “Success! You have inserted your picture!”;
?>

Hope this will solve your problem