Categories
Learning Journal

Inserting Data in Multiple Tables

How to insert records of data into more than 1 database table in MySQL at a time? When I first started coding PHP scripts for myself, without researching further, I simply assumed that I had to INSERT data into multiple tables by inserting part of the data into 1 table, query that table to get that just inserted data’s record ID and then do another INSERT on the next table and so on.

Categories
Learning Journal

Create Multidimensional PHP Arrays

Creating a multidimensional array is quite simple as long as you get over the initial confusion learning to create or work with one.

Categories
Learning Journal

Create a MySQL Table with PHP

One thing I often asked myself, when I first started programming in PHP, was How do I create a MySQL database table with PHP? Of course, I have come a long way since then, and creating a MySQL table from within a PHP script is no longer a mystery to me.

Categories
Learning Journal

Random Rows in MySQL

I have to admit that I had quite some trouble figuring out how I could get MySQL to return some random rows in a query. It was something I had to figure out for myself when I wanted to get a list of random web sites off GIDTopsites to place on these pages here.

Categories
Learning Journal

Parsing PHP in .HTML Files

Is parsing PHP in web pages that end in .html or .htm possible? Absolutely!

Categories
Learning Journal

Hacking Hotmail… NOT!

I bet [Hacking Hotmail passwords] is one of the top search phrases on popular Search Engines.

Categories
Learning Journal

Compress Your Web Page

In my never-ending quest to get my web pages to load super-fast  I chanced upon ob_gzhandler() one day while researching the uses of ob_start() in PHP.