Select Random SQL
Sometimes if you want to extract some records from a table you can use the following SQL syntax select * from table order by rand() limit 10 Different SQL …
Category: mysql
PHP Cache Improvements
August 17, 2012
http, I/O File, implementation, multithreading, mysql, php, SEO, software design, tools / utilities, tricks, web programming
No Comments
In , a PHP-based framework for caching the website is introduced. The sample PHP psudo-code is given. This post will present some additional improvements based on this framework. It …
Create PHP Download Counters
Sometimes, maybe you want to know how popular your programs are. You put the download links but have no idea how many of them have been downloaded. In fact, …
Database Optimisation Script in PHP
Well, sometimes, you probably need to optimise your MySQL tables. In order to avoid the hassle loggin to your remote SSH server, you probably want to write a script …