Hello,
I'm developping a new joomla component, so i want to store pictures in database table in field type : blob. i'm wondery how to proceed to do this.
I'm using this to get file from the form :
$file = JRequest::getVar( 'img2', null, 'files', 'array' );
jimport('joomla.filesystem.file');
$filename = JFile::makeSafe($file);
$src = $file;
$image = mysql_escape_string(file_get_contents($file));
$type_img=strtolower(JFile::getExt($file));
$db =& JFactory::getDBO();
$query = "UPDATE #__prifoot SET extension2='".$type_img."' WHERE id = '89' ";
$db->setQuery($query);
$db->query();
as you see in this step i want just to get extension of the file and store it in database for just for test, and when i check my database table jos_prifoot i have in the field extension2 null value!
it means that the method strtolower(JFile::getExt($file)) returns a null value. and i dont know why!! is the mistakes in the method JRequest::getVar( 'img2', null, 'files', 'array' ) which i'm using to get file?
Thank you.
hassal