Skip to main content

programaticaly Insert and select quary In magento

 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