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”; } Vinod RamVinod Ram has…
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…
nl2br in perl
How to replace new line character with br $tempString = “Hello is testing for new line\n to br”; $tempString =~ s/\n/<br\/>/; output = “Hello is testing for new line to…
How to convert bitmap image(.jpg , .jpeg, .gif, .png) to vector format (.ai , .eps, .svg)
For converting bitmap image to vector image you need to have autotrace library installed . If you not installed you can install that bu using the command “yum install autotrace”.…