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.
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.
Force a vertical scroll bar in non-IE browsers to avoid page jump
Webpages that don’t fit vertically in the browser window have a vertical scroll bar, pages that do fit in the browser window don’t have this scroll bar. All is great until you click from a short page to a tall page and the content ‘jumps’, in order to make room for the scroll bar.
Add the New Twitter Follow Button to Your Website
Now your website users can follow you on Twitter with one click, instead of needing to visit your actual Twitter webpage and potentially lose track of your website.
Force WWW onto Domain Name URLs for SEO with .htaccess
You can get to a website by typing http://mydomain.com or by typing http://www.mydomain.com. So should this matter to you as a developer? Yup. Google doesn’t like when you have duplicate content on a website.
Embed a Twitter Feed on your website with jQuery
In a previous post I showed possibly the easiest way to embed a Twitter feed on your website. This brought up a couple of questions from some users.
How to embed a Twitter Feed on your website
One of the great things about Twitter is that you rarely ever go to the actual site. You can use a program like Tweetie or TweetDeck to send all your Tweets. Another great thing is the ability to embed your recent Tweets onto other websites. It’s a rather simple process, so check out my demo and then keep reading to learn how you can embed your Tweets on your page.