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.
Getting started with Magento can be tricky, and one of the first things every new user wants to do is add a product – but that in itself can be confusing for the newbie, so here’s a definitive guide to adding your first product in Magento.
This guide will tell you how to add a simple product in Magento and explain all the terms along the way.
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.
This is one of the most useful tips about programming I’ve seen. It has deep roots in programming philosophy and in philosophy in general. I find I can apply it not only to programming but in other areas such as data management, time management and just life in general. What is this magical paradigm? Let me explain.
jQuery BBQ creates a nice interface for manipulating your url without having to reload the page. This means that you can create bookmarkable content without having to reload the page every time you want to change a url parameter. This is great for creating AJAX based forms that can display results instantly while still being bookmarkable.
A lot of sites use this sort of functionality already. A good example of this is grooveshark, which uses the hash part of a url to store parameters. Drupal also includes jQuery BBQ in its base package. Page reloads take a long time, so in today’s world of responsive web pages and impatient users, putting url parameters in the hash part of a url makes a lot of sense.
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.