Nice and simple one.. If you want to see whats in an entire array, use the print_r function. This will give you a nicely formatted output of the array showing all dimensions. Try it: {code type=php}$anArray = array(0=>’cheese’,1=>’bacon’,2=>’apples’); print_r($anArray); {/code} Tip if you are viewing this via the output of a webpage, view the source…
After a long search for a Javascript solution similar to Facebook Photo Tagging, I initially found a great solution called Photo Notes. Unfortunately, this has now been discontinued. Photo Notes was a JS Framework-independent solution to allow tagging photos with a comment. It included resizable tags, editing and deleting. Do you know a good, modern…
Setting up indexes is essential to keeping your queries nice and quick. Adding an index is easy – if you’re using phpMyAdmin, just find your table, click “Create an Index” and choose your column or columns. Adding the right indexes is not easy and can be a bit hit-and-miss. This is where the handy EXPLAIN…
The PASSWORD() function in MySQL can generate a hash value for encrypted passwords, similar to md5() in PHP. It is generally not recommended to use this function in an application as it is not particularly secure – it is intended for internal use. If, however, your application uses the MySQL PASSWORD() function, you need to…
Many people seem to be confused with the use of quotes and apostrophes when coding in PHP. Using apostrophes is the lightweight way. Use these when you just want to create a simple string: Using quotes will provide you with a bit more functionality and is slightly more expensive in execution: Please also note that…
There are some instances where you want to redirect the user away from the current page. For example, the user needs to be logged in, so you want them redirected to the login page. In PHP, this can be done like so: If you employ this method, remember that the script will continue after the…
This is advice that you will have heard many times before… but please, for your sake, ensure that you have proper backups in place. As you well know, all our work and effort can disappear with unbelievable ease. Knock that Monday morning cup of coffee over your portable hard drive that contains the only copy…
A common problem using the UNION command in MySQL is when you want to order data sets differently. If you do it incorrectly, you will see the error message: Incorrect usage of UNION and ORDER BY To solve the problem, wrap each SELECT statement in parenthesis as follows: Nice and simple; all you have to…
The modulo operator is very useful and often underused. To best describe what it does, I will give an example of where it is useful. First, imagine you are looping through an array of monkeys and want to highlight every third monkey in bold. This is how it is done using the modulo operator: In…
If you’ve ever had to transfer a large MySQL database, you know it can be a real pain. phpMyAdmin is the go-to for most web hosts, but when it comes to importing that massive SQL dump, it can be a big time-waster. Timeouts and errors are all too common when you’re trying to import data…
