Looking to Build/Redesign a Website or Blog ?

To speak to Rakshit, call +91 968 704 2303

February 26, 2010

59 Comments

Export MYSQL data into Excel/CSV via php

Today i came across a functionality where i need to Export the MYSQL data into CSV/Excel file via PHP function/script. There are such requirement where client needs to Export the MYSQL data (Order data,Member data,Newsletter emails etc) into Excel sheet or CSV file for future reference or need to send to other team for future work. You can give a button or link from where client can click on it and get a Excel or CSV file with all data from MYSQL database tables using(through) PHP.

February 22, 2010

95 Comments

Import CSV/Excel data into MYSQL database via PHP

Today i came across a functionality where i need to import the CSV/Excel file in to MYSQL database via PHP script. There is a special requirement from client where he can upload the CSV/Excel file in file upload field in HTML form and all data from CSV/Excel must import into MYSQL database table through PHP.

February 18, 2010

8 Comments

How to Upload Files to a WordPress Post/Page

All we know to upload images in wordpress blog but if you have a specification to upload other files ( which is not an image like PDF , Doc ) for page/post in your wordpress blog and didn't get from where to upload other files (PDF,DOC etc..) than here you will get the steps how to upload any files and give link in post of wordpress blog. Also after reading this article you will come to know,how to upload image if you are new to wordpress.

February 17, 2010

9 Comments

5 Useful plugins for Simple CMS wordpress website

If you are planning to develop simple CMS website in wordpress than here i am sharing some of plugins of wordpress which is very useful and must needed for any CMS website. Also these are the plugins which makes your development task easier as well.

February 16, 2010

12 Comments

Upload large(Big) files in PHP using .htaccess

I have seen many developers who find difficulties when working with larger files upload in php. When files which are too large in size, needs to be uploaded by php than you have to change the default file size either from php.ini OR httpd.conf OR using .htaccess. Default upload file size will be 2MB. If you are uploading file which is larger than 2MB size than here i am showing you the way to upload larger files using PHP.

February 15, 2010

54 Comments

How to send email from localhost(XAMPP or WAMP) in PHP in Windows

Whenever you works in local server (XAMPP or WAMP) for developing any email functionality in website, than you might be wonder that why email is not going from localhost(XAMPP or WAMP) in windows environment. Well, i faced the same situation and in this case i can help you. Below is the error you might get when working with email.

February 11, 2010

6 Comments

Javascript floating point precision(Sets the number of decimal points)

If you have a problem with floating point precision when you update any number in html using javascript/jquery than here i show you the way how to get number formatted with decimals (set 2 digits after decimal point in float number) from javascript. In PHP, you can simply use number_format() function and pass the parameter as you want for floating point precision(Sets the number of decimal points).

February 9, 2010

4 Comments

Check/Get Visitors Browser/Operating Systems details in PHP

There are plenty of browsers(Mozilla Firefox , Internet Explorer , Google Crome , Safari , Opera and many more) and Operating systems (Windows , Linux , Unix and many more) available in web world. It might be a case when you want to get browser/operating system details of visitors or users who came across your website built up with PHP and fill up a contact request form. Browser/Operating System details will help you to analyze the contact us request made by visitor or user. By looking at browser info & Operating system info,you have a brief idea about users before replying them.

February 8, 2010

6 Comments

Get Visitors Real IP Address in PHP

If you want track visitor's or user's IP address than you may use $_SERVER['REMOTE_ADDR']. Well, you might be shocked to know that it may not return the real IP address of the visitor/user at all time. Here are the cases when it happens. If visitor/user is connected to the Internet through Proxy Server then $_SERVER['REMOTE_ADDR'] in PHP will give the IP address of the proxy server and it will not be visitor's/user's IP address.

February 6, 2010

4 Comments

How to set PHP configuration(php.ini) values from .htaccess file

There might be situation where you need to change php configuration values when you work on server. In local apache server, you can easily change the php configuration values using php.ini file from directory. But what will you do as php.ini is not visible on server ? The solution is .htaccess which is visible on server(.htaccess invisible ?). Using .htaccess you can change the php configuration values.