User Tools

Site Tools


a_simple_php_sqlite_download_counter

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
a_simple_php_sqlite_download_counter [2020/06/27 21:21] waxphilosophica_simple_php_sqlite_download_counter [2020/06/27 21:24] (current) – [Summary] waxphilosophic
Line 3: Line 3:
 ===== Summary ===== ===== Summary =====
  
-If you host downloadable content on SDF, you may want to get an idea of how many people have downloaded things and which are the most popular. In this tutorial, I will focus on an example of tracking PDF formatted ebooks. After completing this tutorial, you should be able to modify things to suit your needs, even if your downloads are not ebooks. You will need to have PHP access to do this, so check your membership level before you get started.+If you host downloadable web content on SDF, you may want to get an idea of how many people have downloaded things and which are the most popular. In this tutorial, I will focus on an example of tracking PDF formatted ebooks. After completing this tutorial, you should be able to modify things to suit your needs, even if your downloads are not ebooks. You will need to have PHP access to do this, so check your membership level before you get started.
  
 ===== The Download Script ===== ===== The Download Script =====
Line 230: Line 230:
 Even if you're not a SQL expert, you can prune by simply picking a rowid and delete everything before it. "DELETE FROM tally WHERE rowid<100" will purge everything from 1 to 99. You get the idea. Even if you're not a SQL expert, you can prune by simply picking a rowid and delete everything before it. "DELETE FROM tally WHERE rowid<100" will purge everything from 1 to 99. You get the idea.
  
-====== Go Forth and Conquer ======+===== Go Forth and Conquer =====
  
 Now that you know what people are downloading from your site, you'll have better insight into what's popular and what's not. Now that you know what people are downloading from your site, you'll have better insight into what's popular and what's not.
a_simple_php_sqlite_download_counter.1593292919.txt.gz · Last modified: 2020/06/27 21:21 by waxphilosophic