Skip to main content

How do I run a raw query against the database?

By Saurabh Patel

For Update Database:
$write = Mage::getSingleton('core/resource')->getConnection('core_write'); 
$write->query("insert into rk_stories values (NULL,'$rks_title', '$rks_date', '$rks_description', '$rks_story', '$rks_theme', '$rks_imgURL', '$rks_img_size', '$rks_isFront')");
 $message = $this->__('Your form has been submitted successfully.');
For select  Database info :

$query="SELECT * FROM rk_stories where rk_stories_id='$id'";
 $result= Mage::getSingleton('core/resource') ->getConnection('core_read')->fetchAll($query);  
$Stories["Data"]["ID"]=$result[0]["rk_stories_id"]; 
 $Stories["Data"]["Title"]=$result[(0)]["rk_stories_title"];                  
$Stories["Data"]["story"]=$result[0]["rk_stories_story"];
    return $Stories;

Comments

Post a Comment

Popular posts from this blog

HTML Emailing in ZF2

By Saurabh Patel
<?php namespace Application\Model; use Zend\Mail\Message; use Zend\Mime\Message as MimeMessage; use Zend\Mime\Part as MimePart; use Zend\Mail\Transport\Sendmail as SendmailTransport; use Zend\Mail\Transport\Smtp as SmtpTransport; use Zend\Mail\Transport\SmtpOptions; use Zend\View\Renderer\PhpRenderer; use Zend\View\Resolver\TemplatePathStack; use Zend\View\Model\ViewModel; use Zend\View\Model\ModelInterface; class ApiEmail extends ApiInterface {    protected $From = "XXXXX@gmail.com";    protected $FromName = "XXXX";    protected $To = "" ;    protected $Subject = "" ;    protected $Body = "" ;    protected $Cc = "XXXXXX@gmail.com";    protected $Bcc = "XXXXX@gmail.com" ;    protected $ReplyTo = "XXXX@gmail.com" ;    protected $Sender = "" ;    protected $Encoding = "UTF-8" ;    protected $MESSAGE ; // getter setter ...
Post a Comment
Read more

Grouped CheckboxSelectMultiple in Django template

By Saurabh Patel
from itertools import groupby from django import forms from django . forms . models import ModelChoiceIterator , ModelMultipleChoiceField from . models import Feature , Widget class GroupedModelMultipleChoiceField ( ModelMultipleChoiceField ): def __init__ ( self , group_by_field , group_label = None , * args , ** kwargs ): """ ``group_by_field`` is the name of a field on the model ``group_label`` is a function to return a label for each choice group """ super ( GroupedModelMultipleChoiceField , self ). __init__ (* args , ** kwargs ) self . group_by_field = group_by_field if group_label is None : self . group_label = lambda group : group else : self . group_label = group_label def _get_choices ( self ): if hasattr ( self , '_choices' ): return self . _choices return GroupedModelCho...
Post a Comment
Read more

How to start working with Django web framework

By Saurabh Patel
 Django is a powerful web framework for Python that makes it easy to build web applications quickly. Here are some steps you can follow to start learning Django programming: Install Python: Django requires Python to be installed on your machine. If you don ' t already have Python installed, you can download it from the official Python website (https://www.python.org/downloads/). Install Django: Once you have Python installed, you can use the pip package manager to install Django. Open a terminal or command prompt and type the following command: pip install django Create a new Django project: To create a new Django project, open a terminal or command prompt and navigate to the directory where you want to store your project. Then run the following command: django - admin startproject myproject Replace myproject with the name you want to give to your project. This will create a new Django project with the specified name in the current directory. Run the development...
Post a Comment
Read more