Sometimes, the only option for dumping data into a database is using CSV files – they’re easy to use for non-technical people, they are a fairly efficient way of storing data and can be easily exported from Excel files.
There’s one huge problem with them, though…they’re a real pain in the arse to work with.
So, I decided to create a reliable, easy to use way for dumping CSV files, no matter how big or small, to a MySQL database. I will, however, show some alternatives along the way.
There are many ways to deploy a Magento site to your server. Many would argue that a simple FTP upload is fine, while others swear by version control.
The problem with the version control + Magento combo is that, necessarily, Magento stores a lot of information about its state in the filesystem – this can lead to a lot of trouble if care isn’t taken when creating the staging and deployment mechanisms.
I’ll walk you through with a tried and tested method I use for the deploying a Magento site using GIT.
Websites with AJAX elements are a defacto standard on the web and have been for quite some time. AJAX allows you to run a request on the server without actually leaving the page the user is on, executing it asynchronously while the browser waits for a response.
One big problem with this is that if the process takes more than a few seconds, there’s no built in methods in the AJAX standards to receive content before the entire request is complete, so how do we let the browser know the status of the process on the server, if we can’t stream information to the browser using AJAX? We’ll be addressing this problem in this post.
If you’ve ever wanted to include content from another site on something you’re working on, then this is probably one of the simplest ways to do it using PHP. I’ll show you how to scrape a site for specific content using a simple to use PHP library.