Tag: database
October 4, 2013
algorithms, database, implementation, internet, mysql, optimization, php, programming languages, search, SEO, sorting, technical, tricks
I have created an online page that allows people to upload any single photo to server. The URL to list all the photos (visible) is https://rot47.net/picture-gallery To add a photo …
My FTP provider (fasthosts) only allows 150MB maximum usage per database created. This is big enough for most personal usages. However, the other day, after I logined to the …
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 …
Caching the pages will improve the overall site speed. For example, if you have lots of pages that do not update frequently, you can cache these pages into static …
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, …