Category Archives: PHP & SQL
PHP: Simple Dynamic Graphs with PHP + MySql
Graphing in PHP has always been an annoyance for me – while it would be cool feature to have, the need doesn’t come up nearly enough to warrant paying the exorbitant fees associated with most commercial graphing libraries. Besides, commercial PHP libraries always bring out the miser in me – it just doesn’t seem to fit with the open source model. [...] [ → ] Continue reading
PHP: PHP into .html file | Explained
If you need to add php code into .html (or .htm) file and you don’t want to change the file extension to .php because you already have incoming links on the .html file – although you can solve that with a simple redirect – here is the solution. Add the following lines of code to your .htaccess file: [...]
[ → ] Continue reading
PHP: Get users Born today Script
Need a sql statement or a php script to return all the users born today? here is how you do it: SELECT * FROM [users_table] WHERE DAYOFMONTH( [date_of_birth_field] ) = DAYOFMONTH(NOW()) AND MONTH( [date_of_birth_field] ) = MONTH(NOW()) [...]
[ → ]
Continue reading