Archive for the ‘Mysql’ Category

Handle Mysql special chars

Here you can use couple of line of code for special characters from your webpage, you have to add below 2 line after mysql_connetc() function.

These lines will removed the unsupported characters from web page and set character set to UTF8………

mysql_query(“SET CHARACTER SET utf8″);
mysql_query(“SET NAMES ‘utf8′”);

Enjoy and keep browsing………….. ~SV~

LAMP useful Resources

http://www.canavese.org/resume

http://thinkd2c.blogspot.com/2006_03_01_archive.html

http://www.sajithmr.com/smpp-library-in-php/

http://www.kannel.org/ (SMS)

http://developer.apple.com/internet/webservices/soapphp.html

http://www.vueling-sc.com/SMS-testPost.asp (SMS)
http://www.blogohblog.com/top-10-javascripts-for-image-manipulation/  (js img)

http://jquery.khurshid.com/ifixpng.php

http://phaedo.cx/archives/2007/07/25/tools-for-optimizing-your-website-etag-and-expire-headers-in-django-apache-and-lighttpd/

http://www.ultramegatech.com/blog/2008/12/creating-upload-progress-bar-php/2/

http://www.bigresource.com

http://www.mysqltutorial.org/  (mysql)
http://www.mysqlperformanceblog.com/2007/10/16/  (Mysql)
http://www.mysql-apache-php.com/  (LAMP)
http://myy.helia.fi/~karte/kurssit/lamp-linux-apache-mysql-php-quickstart.html (lamp)

http://www.thegeekstuff.com/2008/09/how-to-install-or-upgrade-lamp-apache-mysql-and-php-stack-on-linux-using-yum/

http://www.mysql-apache-php.com/website_screenshot.htm

http://www.mysql-apache-php.com/apf-firewall.htm  (Firewall)
http://www.mysqlperformanceblog.com/2007/10/16/  (Mysql)
http://pingability.com/  (Monitor)
http://www.mysql-apache-php.com/dns-server-tutorial.htm  (DNS)
http://www.linuxjournal.com/article/7327  (SPF spam/junk for hotmail, aol etc.)
http://www.onlamp.com/pub/a/onlamp/2008/05/13/creating-applications-with-amazon-ec2-and-s3.html  (EC2)
http://ibiblio.org/g2swap/byteofpython/read/what-programmers-say.html  (Python)
http://jyotirmaya.blogspot.com/2008/11/xampp-python-django.html  (xampp + python)
http://blog.chomperstomp.com/?p=150 (xampp + python)
http://www.prosoxi.gr/2008/12/11/xampp-settings-with-plain-text-configuration-files/  (xampp + php)
http://www.cyberciti.biz/tips/redhat-enterprise-linux-4gb-plus-ram-support.html  (more RAM)
http://www.yolinux.com  (Articles)
http://www.solarenergyhost.com/content/view/157/155/  (Joomla)
http://fonefinder.net/  (us phone no)
http://www.tp2location.com/  (Phone finder)
http://ffmpeg-php.sourceforge.net/  (ffmpeg-php)
http://www.crucialp.com/resources/tutorials/server-administration/how-to-install-ffmpeg-centos-rhel-redhat-enterprise-easy-way.php   (cenOS 4.7 Final)
http://www.cyberciti.biz/faq/explain-mx-record-mx-priority/  (MX Record)
http://www.tldp.org/LDP/solrhe/Securing-Optimizing-Linux-RH-Edition-v1.3/chap29sec295.html  (FTP user)
http://www.crucialp.com/blog/2008/09/27/how-to-install-webmin-on-ubuntu-7-or-8-by-using-ubuntu-deb-packages/  (Webmin)
http://blog.getasysadmin.com/2009/02/more-apache-benchmarks-using-ec2.html  (scalr + EC2 + ubuntu)
http://doxfer.com/Webmin/ProFTPDServer#Configuring_logging  (Webmin)
http://dev.sellingsource.com/2006/12/07/sending-wap-push-messages-with-kannel-php/  (Wap Push)

http://www.passitto.com/

http://techandother.wordpress.com/2006/02/01/rapid-web-prototyping-with-open-source-part-5/  (Joomla)

http://wiki.triangle-solutions.com/index.php/SMS_WAP

http://mu.wordpress.org/forums/topic.php?id=10540  (Paypal API)
http://valet.webthing.com/link/  (broken links)

http://codex.wordpress.org/Changing_File_Permissions

http://www.zimbio.com/PHP/articles/144/Htaccess+Example+Codes

http://codex.wordpress.org/htaccess_for_subdirectories  (stop script execution)

http://www.bigresource.com/PHP-Stop-Direct-Execution-kZxnWn2H.html

http://www.artzstudio.com/2008/08/using-modconcat-to-speed-up-render-start/  (Combine css, js etc.)

http://aciddrop.com/php-speedy/

http://www.ejeliot.com/blog/72

http://bizrules.info/weblog/2005/08/database_vs_rulebase_vs_knowle.html  (DB vs KB)

http://www.securityfocus.com/infocus/1818  (SSL)

http://www.vanemery.com/Linux/Apache/apache-SSL.html  (SSL)

http://www.tc.umn.edu/~brams006/selfsign_ubuntu.html  (SSL)

http://developer.apple.com/internet/opensource/php.html (PHP on MAc)

http://www.databaseanswers.org/data_models/

http://dhtmlkitchen.com/scripts/tabs/Tabs/demo/dual.html#content4  (key Tabs)

http://jquery.khurshid.com/ifixpng.php

http://blog.scubetech.in/?p=107

Top 10 PHP Frameworks

1. Zend Framework – http://framework.zend.com/
2. CakePHP – http://www.cakephp.org/
3. Symfony Project – http://www.symfony-project.com/
4. Seagull Framework – http://seagull.phpkitchen.com/
5. WACT – http://www.phpwact.org/
6. Prado – http://www.xisc.com/
7. PHP on TRAX – http://phpontrax.com/
8. ZooP Framework – http://zoopframework.com/
9. eZ Components – http://ez.no/products/ez_components
10. CodeIgniter – http://www.codeigniter.com/

That’s the top ten framework. For more information on other framework. below is the link

http://www.phpwact.org/php/mvc_frameworks

http://www.dagbladet.no/development/phpcodingstandard/