使用PHP PDO MySQL存储图像

Question

Hello friends of the community. I'm storing information in my MySQL database using this code:

class crud
    {
        private $db;

        function __construct($DB_con)
        {
            $this->db = $DB_con;
        }

        public function create($fname,$lname,$email,$contact,$nimagen)
        {
            try
            {
                $stmt = $this->db->prepare("INSERT INTO tbl_users(first_name,last_name,email_id,contact_no) VALUES(:fname, :lname, :email, :contact)");
                $stmt->bindparam(":fname",$fname);
                $stmt->bindparam(":lname",$lname);
                $stmt->bindparam(":email",$email);
                $stmt->bindparam(":contact",$contact);
                $stmt->execute();
                return true;
            }
            catch(PDOException $e)
            {
                echo $e->getMessage();  
                return false;
            }

        }   

}

Now I want to add a picture, Please I need to add in the code? I'm using PDO.

Answer 1

You need to store your image as a blob.

$file = fopen('path/to/image.jpg','rb');

$stmt->bindparam(":image", $file, PDO::PARAM_LOB);

Edit: Since others have pointed this out I thought I'd just say it's probably best to avoid doing this and store your image in the filesystem, instead saving the filename in the database so you can reference your image that way. But this should answer your question regardless.