PHP and MySQL coding tips

I thought it would be good to create a thread with a lot of my common PHP and MySQL coding tips that I mention in other topics on here all the time. These are valuable things that I've learned during 1 year with PHP and MySQL. I believe these are good do's and don'ts, that most experienced coders would agree with, and not just my opinions. :)

read more | digg story

Comments

Post a Comment

Popular posts from this blog

Tagging Classic Music albums with Mp3tag for iTunes and Last.fm

Image
I realized a lot of people having trouble with tagging Classic music. Initially, I got into Classical music to take up this challenge but now I am hooked into it because of its nice sophisticated melodies. There has to be a very straight forward way of tagging music. The ID3v2 specification provides us frames for the following tags that can be used to organize classical music:   Artist AlbumArtist Conductor OriginalArtist Composer Album Name   My goal is to devise a plan to fit all of these tags into Classical music appropriately, so that the Classic music composers will appear in Last.fm statistics music will be organized and displayed well in iTunes   The primary focus is given to how the music is organized. This means tagging conventions for track names is not one of the primary concerns in this article. First we familiarise ourselves with the ID3v2 frames for the tags above.   TPE1 The 'Lead artist/L...
Read more

Having to remove shoes before you enter someone’s house

I have to put this in writing before I forget it over the time. While at work, I got a call from a friend of mine to help him connect to his new ISP. I drove after work to his house and as I approached the main door, I noticed all the shoes being removed and placed at a side. Conscience told me I had to remove the shoes I am wearing. The steel toe shoes I was wearing were strictly indoor and only had house-dirt if you call it that way. I drive to work and I have separate boots to wear during site visits. The shoes came up to my ankle so it took some time for me remove both and finally enter the house. The guy was just waiting at the main door like it was part of normal activity, but *not* for me it was! After I set up the new router it came to the point where I needed the new ISP username and password. Without a surprise he had no idea about it and he said that we will have to go to his cousin’s house to check his email and get the login details from the ISP’s email. I got out of the...
Read more

Ideas for Windows 8

Image
Use proper units Rename “KB” to “KiB” Rename “MB” to “MiB” Rename “GB” to “GiB” Rename “TB” to “TiB” etc. http://members.optus.net/alexey/prefBin.xhtml http://physics.nist.gov/cuu/Units/binary.html   Enhanced Windows Setup Reuse Users folder If Windows 8 finds a “Users” folder in the partition you are going to install Windows, it will attempt to reuse data inside this folder. For example, if the Users folder has a Mihajlo folder, then it will move all the folders other than the folders listed below, to a folder called Mihajlo.Old.     Later on in the Windows Setup, when you create an account called Mihajlo, new %appdata% etc. folders will be created but all the data folders will be preserved and ready to be used from last install.   This means in other words: Old D:\Users\Mihajlo\AppData is moved to Old D:\Users\ Mihajlo.Old \AppData D:\Users\Mihajlo\AppData will be created new.   The following folders will...
Read more