mysql error while executing propel:insert-sql in symfony 1.4
SQLSTATE: Syntax error or access violation: 106 you have an error in your SQL syntax; check the manual that corresponds to you server version for the right syntax to use…
London shop to make breast milk ice cream
LONDON (Reuters Life!) – A specialist ice cream parlour plans to serve up breast milk ice cream and says people should think of it as an organic, free-range treat. The…
How to check PHP error before including any file in your script
Suppose you want to include/require any file in your scripts, But before doing so you want to confirm that the included or required file doesn’t contain error. Then in that…
How to check if requested url exits or not
$requestedUrl = “http://www.example.com/abc.php”; $tags = get_headers($requestedUrl); if(preg_match(“/Not Found/i”,$tags) || preg_match(“/Service Unavailable/i”,$tags)) { echo “Requested Url does not exists”; } else { echo “Requested Url exists”; }
select multiple column from multiple table in cakePHP
$markers = $this->Post->find(‘all’, array( ‘joins’ => array( array( ‘table’ => ‘cp_user’, ‘alias’ => ‘users’, ‘type’ => ‘left’, ‘foreignKey’ => false, ‘conditions’=> array(‘Post.postauthor = users.id’) ) ), ‘conditions’=>’Post.poststatus = 1’, ‘fields’=>array(‘Post.postid’,…
font size issue on iphone
In case you are viewing the html page in iphone and the content appear differenct (the font size appearing bigger/smaller) than other phone, then add the below meta tag code…
export data to excel file (.xls format)
By using the below code you can export your data from the database to excel file. When you run the below code, the excel file get generated and get downloaded…
How to fetch multi-lingual content from database
The basic purpose of this post is to guide you all about fetching multilingual content from database. I mean to say that, if you have stored japanese text in your…
How to use FCKeditor in symfony
1. Download the FCKeditor source from http://ckeditor.com/download 2. Extract the source to /web/js/ directory of your symfony project directory 3. To use the editor in symfony, add (edit if present)the…
Update query in symfony
Suppose you want to execute query like UPDATE tableName SET column1 = ‘abc’,column2 = ‘xyz’ WHERE column =’1′; then you can use the below syntax to do so 🙂 —————————————————————————-…