Hey , now you can run PHP from Google apps Engine (GAE)

Now you can run PHP on GAE using Quercus
1) Register a free account.
2) Download this file to your computer.
3) Edit application XML tag in the file war\WEB-INF\appengine-web.xml to the name of the application you have registered.
4) Finally upload your application. I downloaded Google App Engine SDK for Java and use the following command in windows.
appcfg.cmd update C:\projects\phpwithjava\war

To see this in action just visit:

http://phponair.appspot.com/my.php

How to save MySQL query results into a text or CSV file

Below query writes resultsset to .txt file :-

SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.txt'

To make csv , try this one :-

SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n' ;

phewww...

How to enable secure http (https) in your localmachine

To enable https in your local machine is not a tough game , its simple .
I have performed only few steps in my ubuntu ,just check it out

• openssl genrsa -out yourX.key 1024

• openssl req -new -key yourX.key -out yourX.csr

• openssl req -new -key yourX.key -x509 -out yourX.crt -days 365

Run these 3 commands inside a folder , 'yourX' should be replaced with your application name .These commands will generate 3 files , here they are yourX.key,yourX.csr,yourX.crt .

After finishing the above task add virtualhost within your httpd.conf (or httpd-vhosts.conf on some systems)

<VirtualHost my.localhost:443>
DocumentRoot "/PATH TO YOUR APP/"
ServerName my.localhost
SetEnv APPSTAGE development
<Directory /PATH TO YOUR APP/>
DirectoryIndex index.php
AllowOverride All
Order allow,deny
Allow from all
</Directory>
SSLEngine On
SSLCertificateFile /PATH TO CRT FILE/yourX.crt
SSLCertificateKeyFile /PATH TO KEY FILE/yourX.key
</VirtualHost>

*NOTE: sometimes you may get error like this  "Invalid command 'SSLEngine', perhaps misspelled or defined by a module not included in the server configuration Action 'configtest' failed"
In that case please make sure ssl is enabled ,please run 'a2enmod ssl' to get it working.



Hope it will help you guys :)

-cheers

How to Add the Facebook Like button in blogger

1. Login to your Blogger Account and go to Layout > Edit HTML and click on the check box which says “Expand Widget Templates”

2. Look for <data:post.body/> and immediately after that place the following code.

<b:if cond='data:blog.pageType == &quot;item&quot;'>
<iframe allowTransparency='true' expr:src='&quot;http://www.facebook.com/plugins/like.php?href=&quot; + data:post.url + &quot;&amp;layout=standard&amp;show_faces=false&amp;width=100&amp;action=like&amp;font=arial&amp;colorscheme=light&quot;' frameborder='0' scrolling='no' style='border:none; overflow:hidden; width:450px; height:40px;'/>
</b:if>

This code will show the Like Button on Post pages only. If you want to display it everywhere, then remove the two lines of code in red.

3. Save the template and you're done

Any queries? ..comment here .

wow posterous

Started a posterous account , which has an option to link twitter,facebook,blogger and almost everything .One post to posterous goes everywhere else on the web .One of the main advantage is we can post it via mail, that means even through mobile too . I have made an account here http://photos.munawer.in/ for sharing photos on the go through mobile

Airtel NOP sucks..

hey guys,

i have started this blog to share my experience with some technologies..