Subversion Repositories Applications.papyrus

<?php
/*

        benchReceive.php - example way to handle incoming benchmark data,
        or how to use JSON php class to mangle data.  No benchmark data
        is stored currently.

-- 
-- Table structure for table `benchmarks`
-- 

CREATE TABLE `benchmarks` (
  `id` int(11) NOT NULL auto_increment,
  `useragent` varchar(242) NOT NULL default '',
  `dojover` varchar(96) NOT NULL default '',
  `testNum` int(11) NOT NULL default '0',
  `dijit` varchar(64) NOT NULL default '',
  `testCount` int(11) NOT NULL default '0',
  `testAverage` float NOT NULL default '0',
  `testMethod` varchar(10) NOT NULL default '',
  `testTime` bigint(20) NOT NULL default '0',
  `dataSet` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `dijit` (`dijit`,`testAverage`),
  KEY `dataSet` (`dataSet`)
) TYPE=MyISAM;

--
-- [end table struct] --

*/

if (is_array($_POST)) {

        $username = '';
        $password = '';
        $dataBase = '';
        $table    = '';

        mysql_connect("localhost",$username,$password);
        mysql_select_db($dataBase); 

        require("../../dojo/tests/resources/JSON.php");
        $json = new Services_JSON();

        // see "escape()" call in benchTest.html
        $string = $json->decode(urldecode($_POST['key']));
        // $string = $json->decode($_POST['key']);

        print "<h1>Thank YOU!</h1>";
        print "
                <p>Your results have been added to our database. No 
                personal information outside of what you see here 
                has been stored.
                </p>

                <p>You can <a href= \"javascript:history.back()\">go back</a> 
                and run more tests, or even better, load up another browser 
                and the submit your tests again!
                </p>

                <p>again ... thanks for your time.</p>

                ";

        print "<h3>Results Submitted:</h3>"; 
        print "<pre style=\"font:6pt Terminal,sans-serif; border:1px solid #cecece; background-color:#ededed; padding:20px; \">";

                $ua = $string->clientNavigator;
                $dojov = $string->dojoVersion;

                print "Client: ".$ua."\n";
                print "Dojo v".$dojov."\n"; 

                if (is_array($string->dataSet)) {
                        print "\nTest Results:";
                        // should client serialize a key, or is this safer?
                        $dataSet = md5(serialize($string)); 
                        foreach ($string->dataSet as $test) {
                                $data = array(
                                        'dataSet' => $dataSet,
                                        'useragent' => $ua,
                                        'dojover' => $dojov,
                                        'testNum' => $test->testNum,
                                        'testMethod' => $test->testMethod,      
                                        'testTime' => $test->testTime,
                                        'testAverage' => $test->testAverage,
                                        'testCount' => $test->testCount,
                                        'dijit' => $test->dijit
                                );
                                print_r($data); 
                                add_rec($table,$data); 
                        }
                }

                if (is_array($string->errors)) {
                        // not saving errors at this point
                        print "\nErrors:";
                        foreach ($string->errors as $error) {
                                print_r($error); 
                        }
                }
        print "</pre>"; 
}

function add_rec($table, $data) {

        if (!is_array($data)) { return FALSE; } 

        $keys = array_keys($data);
        $values = array_values($data);
        $field=0;

        for ($field;$field<sizeof($data);$field++) {
                if (!ereg("^[0-9].*$",$keys[$field])) {
                        $sqlfields = $sqlfields.$keys[$field]."=\"".$values[$field]."\", ";
                }
        }
        $sqlfields = (substr($sqlfields,0,(strlen($sqlfields)-2)));

        if ($query = mysql_query("insert into $table set $sqlfields")) {
                $id = mysql_insert_id();
                return ($id); } else { return FALSE; }
        }
}

?>