Blogs

PHP Dynamic Variables

Let's say that you have a bunch of data in a recordset and you want to populate that data into a list of variables. In my example we will draw 20 items from a players inventory from a MySQL table which stores all the items for a player in rows we call slot_1, slot_2, slot_3, … all the way to 20. So when we pull all of the items from the MySQL table we want to assign them to variables respectively. For example, our variable of "slot_1" that we are creating will equal "slot_1" from the MySQL table.

MySQL Joins (Left and Inner)

MYSQL Joins are confusing, to say the least. I was successfully able to do one a few different ways and thought it be best to write down how I did it so I can do it in the future.

What I had was two different tables. One table was xcart_products_categories which stores all "productid" and matches them with which category they go to "categoryid". The other table which was xcart_products had the “productid” and all of its information.

Reset a MySQL Recordset with PHP

When you run a recordset through a loop, you will not be able to re-run the recordset further down in the same page. Here is how to reset the recordset so you can use it again on the same page. Just place this code after your loop. Change the "$Recordset" to your recordset's variable.

Rich Black or True Black with Adobe Illustrator

If you have ever had problems getting a nice deep black with Adobe Illustrator, you’re not the only one. When generating pdfs if you have your standard black color set to #000000 your black may come off a little different than expected, it will loose its richness and not be true black.

To get a true rich black in Adobe Illustrator, use the following:

Cyan: 50
Magenta: 40
Yellow: 40
Black: 100

Get Page Name from Web Address using PHP

With PHP you can recognize the page you are on and then display a proper header for that page.

For example:

Looping with PHP to Build a Table

Looping comes in handy when you may want to execute a certain script "x" number of times or if you want to display all the information within a Recordset. Here is an example of how I display all the information stored within a Recordset into a nice table that is easy to read.

Create a PHP Recordset

Recordsets in PHP are useful bits of code used to display data that is stored within a MYSQL table. You can run a loop to display all of this data or you can display only the bit of information you want. Here is how I do this:

Pages

Subscribe to RSS - blogs
If you have questions about anything on this site, you can find me on Google+: