uploading an image (BLOB) to mysql

Because you are inserting it  wrong.

Look at this code.

PHP Code:

$products[] = [
    'product_name' => 'MySQL DATABASES',
    'price' => 15,
    'product_image' => file_get_contents("https://i.imgur.com/UYcHkKD.png" )
]; 


You assign the contents to the image not png.

---

This is being called after the record has been inserted, and that is why it is update rather than insert. 

public function upload_image3($post_array,$primary_key)
{
    $szFile=str_replace("/files/","/thumbnails/",$post_array['thumbnail_url']);
    $file_types = array( ".doc", ".ppt", ".pdf", ".xls", ".jpg");
    $szFile=str_replace($file_types,".png",$szFile);
    $szFile3 = file_get_contents($szFile);
    $imgData = addslashes($szFile3);
    $BLOB_insert = array(
        "id" => $primary_key,
        "image_BLOB" => $imgData
    );
    $iRc=$this->db->update($_SESSION[table],$BLOB_insert);
    return;
}


$iRc is returning null so i don't know if this is succeeding. I then tried SELECT HEX(image_BLOB) FROM word where id=17 in mysqlWorkbench and the BLOB appears blank.

proof that an old dog can learn new tricks