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

Internet Explorer 7

Well, Microsoft said a while ago there will be no more new Internet Explorer versions built. But things changed and now we are aware of the coming release of Internet Explorer 7. WM9 Bitrate Calculator 2.1 was released. For CCE/MPEG2/MPEG1 to WMV conversions, the need of setting the Audio Mode as CBR was necessary to avoid Encoder Errors on 2-pass. So from here on, the default Windows Media Profile will be created with CBR for Audio. Default video mode is still 2-pass VBR. It will also select Windows Media Audio 9 Professional codec by default for any Audio Mode you choose. Version 2.1 ======== 0088 == Final Release of WM9 Bitrate Calculator 0087 ++ File > Open Log 0086 =+ Code Optimization 0085 =+ Always choose WMA9PRO as default 0084 == Default Audio mode set to CBR 0083 ++ Fixed Resolution issue Please check the thread at MSUN Forums .
Read more