mysql - PHP move_uploaded_file to SQL -
i having difficulty code. trying upload file server folder , insert in sql blob. neither 1 of works. suggestions?
<?php mysql_connect ("host","user","pass") mysql_select_db("pics") $image= addslashes($_files['file']['tmp_name']); $name= addslashes($_files['file']['name']); $image= file_get_contents($image); $image= base64_encode($image); if (move_uploaded_file ($_files["file"]["tmp_name"], "http://www.website.com/uploads/".$_files["file"]["name"])) { $insert = mysql_query ("insert pics (name,file) values ('$name','$image')"); } else "error uploading query database"; ?>
first of (agree @amartinno1) don't use mysql functions, use pdo.
also (one more time agree @amartinno1) 2nd parameter move_uploaded_file must path file on server (file system path).
$pdo = new pdo('mysql:dbname=pics;host=host', 'user', 'pass'); $image = addslashes($_files['file']['tmp_name']); $name = addslashes($_files['file']['name']); $image = file_get_contents($image); $image = base64_encode($image); if (move_uploaded_file($_files['file']['tmp_name'], '/tmp/myuploadedfile')) { $s = $dbh->prepare('insert pics (name, file) values (:name, :file)'); $s->bindvalue(':name', $name, pdo::param_str); $s->bindvalue(':file', $image, pdo::param_str); if (!$s->execute()) { throw new exception($s->errorinfo()); } }
Comments
Post a Comment