Carrying on with the theme of data files and databases, I am going to talk a bit about .csv files. “csv” stands for Comma Separated Variables, and is a popular format that is supported by many spreadsheet and database applications. I work a lot with csv files, opening them in Excel to […]

read more from " Splitting large csv files - the CSV Splitter "

In my last post I talked about dealing with a .sql file from the command line. This worked well, but there are other ways to interact with your databases that are GUI based, and perhaps easier for someone accustomed to dealing with the GUI interface. The two that I am currently […]

read more from " Some database tools - phpMyAdmin and HeidiSQL "

I have some .sql dump files that I wanted to open and play with. After googling and doodling, I finally accepted that I was going to have to overcome my innate need for orderly progression and jump into doing stuff with mySQL before actually getting to that chapter in the book!!
So here are the […]

read more from " Working with a .sql dump file - a newbie tutorial "

Since I have been completely swamped with work and haven’t really had time to do any more PHP learning, I decided to write about a program I wrote ages ago in 2ooo. I was looking through my old files and came across the manual that I wrote, plus all the source code which I […]

read more from " From the Archives "

So now I have my laptop all set up so that I can write and test php code. My next step was to collect the remaining tools I need to start, so first I had to decide what I’m going to use to write and edit my code. I’ve always liked Notepad for […]

read more from " The Next Step - Collecting my tools "

The first step for me in the PHP journey was to set up a server on my laptop so that I could code and test my code locally, without uploading it to my hosting account. After some research, I decided to install Apache, PHP, and MySQL from scratch without using any of the installation […]

read more from " The First Step - Installing Apache/PHP/MySQL "