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