MySQL Icon

PHP Upload a CSV File into MySQL

Sometimes clients want to put all their products online in a database but don’t want to manage them as they may already be doing so in some kind of spreadsheet or offline database (Excel, Numbers, Filemaker, etc). For them, they don’t want to learn any new systems but want to have both areas, offline and online, up to date and mirroring each other. If you run into something like this, it’s very easy to populate your table via a CSV file upload.

Read more

Writers Block

Well I’m having some problems keeping up with one post a week. Been fairly busy with full time work and side projects as well as having writers block. Anyone have any good ideas for topics? Drop me a message if there is anything you’d like covered or more in depth on some of my current posts.

MySQL Icon

When to Store Data in a Table vs Using an Array

I was coding out a basic contact form today with the usual name, address, email etc. I was building out the country select menu and noticed I already had code for building it via an array and building it from a database table. So I decided to put the two up against each other and see which one was faster.

Read more