Magento Coding Solutions

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'];
       

No comments:

Post a Comment