Web Development Cheat Sheets, Must Haves

Today I found a site that offers great web development cheat sheets!

There is MySQL, mod_rewrite, CSS, PHP and RGB Hex color chart. All great to have, I hope to print them out on the nice color laserjet at work!

I know the MySQL one will be helpful for reminding me the MySQL data types, the PHP one will be great help for formatting dates.

The CSS one has a great diagram for understanding margins and padding of box elements.

The RGB Hex color chart is a great companion to Website Colors.

With the Colors Cheat Sheet you can get a color close to what you want and plug that into the website color tool and tweak it to just what you want. Then compare with other colors to get your full color scheme. Great Stuff!

Links

A New Approach to Web Applications

I have mentioned AJAX before, still have not learned much more. As much as I understand is that it is a concoction of your web language, PHP/ASP, java script and CSS to create a web app that acts more like a desktop app. Less page refreshing mostly.

That is really what separates web apps from desktop apps. More time consuming when waiting for pages to generate and load.

I hope to find the time to really dive into AJAX. Google is using it in several places, so it’s got to be a good thing!

ajax: a new approach to web applications

New Lines to Paragraphs PHP Function

This is a great php function, written by Matthew Mullenweg, that will format text that has been pulled from a MySQL database so that it is displayed with HTML paragraph tags.

The function will replace new lines/carriage returns or even HTML line breaks with the paragraph tags, within the given string.

I have used this in a couple of different areas and it works great! One place is on the Hip Hop Rappers Lyrics pages, plus any other page that has text pulled from the database. Great stuff! This goes in conjunction well with CSS for formating the paragraphs to my likings. You can also specify a CSS class to use with the paragraph.

New Lines to Paragraphs PHP Function

First Letters SQL Statement

Here is a neat SQL statement that will return a recordset that counts the number of records that start with a particular letter.

I do have a good use for this that I need to implement. It was created by Matthew Mullenweg, the creator of Wordpress.

First Letters Query

Windows XP Desktop on a Webpage?

While browsing around I saw this cool CSS example. I have seen some pretty cool things done in CSS, but this has to be one of the neatest.

Multiple-Themed Windows XP CSS Desktop v1.0 Trovster.com