We are going step by step through the process of converting a csv file to a sql file. In the first part, we discussed what tools we need to accomplish this task, as well as where to find a sample csv file to play with. We then covered creating the sql database in the second part. In this third section,…

Continuing on from my previous post, we are now going to start the conversion process. The first step is to create the database and the table that we need. You can do this using PHPMyAdmin, but I generally prefer to use HeidiSQL. The process is basically the same in each case, but I find HeidiSQL to have a better interface.…

I have been playing more with databases and less with PHP these last few days out of necessity, and I've had to convert a bunch of files over from .csv to .sql (MySQL).  Now I generally don't like to use a method if I don't understand it, and I try to find a way that works for me, use it,…

If you are serious about learning PHP and MySQL, you need good resources. There are many online tutorials and websites, and I have listed some really useful resources in a previous post. If you are like me and prefer to not read off a screen, and instead like to use a book, there are many excellent books out there that…

If you are interested in web development, then you've probably at some point discovered, dealt with, or cursed at a Content Management System (CMS). This is actually one of the main avenues through which I discovered, and decided to learn PHP. Installing a CMS and modding it to get it to look like you want, let alone work like you…

Close