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 manipulate them, or saving my Excel or Access…

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 playing with are PHPMyAdmin and Heidi SQL. Both are…

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 steps I used. I have…

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 somehow still have :-). The program…

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 HTML coding because it doesn't leave behind…

Close