Blogs

Genrating SEO friendly url using .htaccess and modrewrite

September 29, 2014
Here how you can create clean SEO friendly url: Normal practice of using url: 1) http://sforsuresh.in/user.php?u=123 2) http://sforsuresh.in/user.php?u=123&cat=php 3) http://sforsuresh.in/page.php You can just rewrite it like 1) http://sforsuresh.in/user/123 2) http://sforsuresh.in/user/123/php 3) http://sforsuresh.in/page Let see how we can achieve this: 1) You need to enable “mod_rewrite” of apache as below: For enabling “mod_rewrite” open file “httpd.conf” and remove “#” from beginning of the below line: LoadModule rewrite_module modules/mod_rewrite.so 2) ...
Read more..

Creating Contact us page in Drupal 7

September 10, 2014
Following are the steps to enable, configure and adding Contact us form: Enabling Contact module: Login to Admin and click on “Modules” link from the top admin menu you will see below screen. Check the Contact module and save configuration button at the bottom. By checking you made it available to use in your application.   Now need to ...
Read more..

RSS feeds generator

September 1, 2014
RSS is an easy way to provide contents of your sites in form of XML. RSS is written using XML, so we can define our own tags while generating RSS feeds. Here I provided a sample PHP code how we can generate RSS feeds for the site. By following this blog you will be able to generate ...
Read more..

Migrating content/node from drupal 4.x to drupal 7.x

April 11, 2014
Drupal having a huge support with version 6 > but with 4.X with no support and 5.x with limited support. Initially I install few module to import node/content with CSV/XML but they are not working as expected. I need to import content first which include mainly title, description images(more than one) and attachments (more than ...
Read more..

What is the difference between SMTP server mail() and PHP mail()

April 9, 2014
PHP support mail() function for sending mails. And in general we use it as it fast and easy to do it. But by doing this we for exactly what we are doing this. Because when we use mail() native function of php it goes to Spam box and not in inbox of the intended recipient.
Read more..

Wamp server port conflict with skype

March 24, 2014
If you are a PHP developer with WAMP install in you system which gives error for port number (if skype is already started). WAMP does not go green if you are logged in to skype and wanted to start your WAMP server it will not start. We can solve this problem in two ways: A) Start your WAMP ...
Read more..

Generating ERD using PHPMyAdmin

March 5, 2014
Today I need to generate ERD for my Database. If you search on net you will get number of people suggest Workbench for it but as i am using PHPMyAdmin as an GUI for my Mysql database I just don’t want to install workbench only for generating ERD. And above all when PHPMyAdmin support it ...
Read more..

How to access remote mysql server using local phpmyadmin

February 28, 2014
It is very tough to connect your remote mysql box especially when you are working with VPN. Initially I used telnet to connect to mysql box than I try to use workbench. Workbench is good and better than using telnet but again it consume more memory and if VPN got disconnected it just hanged. It ...
Read more..

Date manipulation with mysql..

February 10, 2014
There are various instance when we do date calculation on date / unix datetime fields.Following are some example as how to use inbuilt functions of mysql which will reduce doing calculation in PHP, I hope it will help someone:
Read more..

Maximum Number of Columns Per Table – Mysql

January 31, 2014
The maximum row size constrains the number of columns because the total width of all columns cannot exceed this size. For example, utf8 characters require up to three bytes per character, so for a CHAR(255) CHARACTER SET utf8 column,
Read more..