INSERT QUERY include('../app/Mage.php'); Mage::app(); $write = Mage::getSingleton('core/resource')->getConnection('core_write'); $sql="INSERT INTO opd_uploads SET extension='$extension', sessionId='$sessionId', ip='$ip', status=1, dateTime=now()"; $write->query($sql); //lastInserted ID $imageId = $write->lastInsertId(); SELECT QUERY $read= Mage::getSingleton('core/resource')->getConnection('core_read'); $value=$read->query("select * from opd_uploads WHERE id='".$imageRowId."'"); $row = $value->fetch(); $orgFilExt=$row['extension'];
Comments
Post a Comment