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

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -

How to provide Authorization & Authentication using Asp.net, C#? -