Recording Speeds in MySQL DB

Comments

1. AMPC says:
   May 17, 2008 at 12:06 pm

   Hello David,

   The logger.php receives the results of the speed test and records them into a text file, so there should be no problem getting it into the database. I don’t have the code for that, but it can be done.

   If I had time, I would do this, but right now, I don’t. If you do, will you do me a big favor and upload the code for everyone to use? Thanks!

   Jim.
2. bbspeedtester says:
   May 17, 2008 at 2:06 pm

   Jim,

   Thanks for the reply, and as always thanks for the script.

   I will work on a script for it, and then get it on the forum for folk to down load

   yours

   david
3. bbspeedtester says:
   May 17, 2008 at 3:06 pm

   ok all,

   ive got it recording into the DB

   Jim, on the line in your code:

   Code:

   if (isset($HTTP_POST_VARS['testspeeds'])) {
   $testspeeds =  $HTTP_POST_VARS['testspeeds'];
   } else {
   $testspeeds ="---t---";
   }

   IM just trying to split the —t— into two separate speeds, so i have an up speed and down speeed recorded, and after that, tis all done

   David
4. AMPC says:
   May 17, 2008 at 4:06 pm

   Thanks David, very cool and I look forward to the code!

   The flash sends the values separated by a space, so you’ll have to search for the space, then trim into two values.

   Does that help?
5. bbspeedtester says:
   May 17, 2008 at 5:06 pm

   it does indeed, have got it splitting into two values, just having issues with the array for each speed

   david
6. bbspeedtester says:
   May 17, 2008 at 7:06 pm

   have got it working properly, will put up some screenies to show

   David
7. bbspeedtester says:
   May 17, 2008 at 10:06 pm

   have got it adding to the db fine with individual speeds,

   it keeps adding a blank load to the db without values, is there any reason you think why?

   david
8. AMPC says:
   May 17, 2008 at 11:06 pm

   Glad to hear it! Share the code!

   Thanks!

   Jim
9. bbspeedtester says:
   May 18, 2008 at 11:06 pm

   ok all,

   with exception to it adding two rows to the DB, it is working.

   You can download from BBSpeedTester.com

   If anyone needs a hand on the database setup, email me on david @ bbspeedtester.com and I’ll see what i can do.

   David
10. AMPC says:
    May 19, 2008 at 11:06 pm

    Thanks for the code David, I had it for the ASP version, but not the PHP version.

    I changed the link you included and added anchor text – that link alone should not only get you spidered asap (google bbspeedtester), but you should get some nice PR from it as well – and of course, traffic

    For those that have not been to BBSpeedTester, it’s a great example of how you can set up a site around the free speed test and generate cash!

    Very nice design David!

    Regards,

    Jim.
11. bbspeedtester says:
    May 20, 2008 at 11:06 pm

    Thank you Jim for the kind words

    Over the next few weeks I shall add a full user back end to the script (signup, recording and reporting etc), keep and eye out as I will release it to everyone to use.

    Yours

    David
12. Mark.J says:
    May 21, 2008 at 8:06 pm

    That sounds excellent, I’ve been trying to add similar features to mine but it’s a nightmare to get working correctly and my PHP knowledge isn’t very good . I’d also really like to see the ability to select your ISP name before performing a test, so that when it’s logged the results can be attributed to specific provider performance.

    Been trying to add this but I think it needs to be done in the FLASH itself first.
13. bbspeedtester says:
    May 21, 2008 at 11:06 pm

    i am working this just now

    david
14. Mark.J says:
    July 22, 2008 at 11:06 pm

    Any progress bbspeedtester?

Speak Your Mind Cancel reply