| Index: chrome/test/data/dromaeo/store.php
|
| ===================================================================
|
| --- chrome/test/data/dromaeo/store.php (revision 0)
|
| +++ chrome/test/data/dromaeo/store.php (revision 0)
|
| @@ -0,0 +1,58 @@
|
| +<?php
|
| +
|
| + $server = 'mysql.dromaeo.com';
|
| + $user = 'dromaeo';
|
| + $pass = 'dromaeo';
|
| +
|
| + require('JSON.php');
|
| +
|
| + $json = new Services_JSON();
|
| + $sql = mysql_connect( $server, $user, $pass );
|
| +
|
| + mysql_select_db( 'dromaeo' );
|
| +
|
| + $id = str_replace(';', "", $_REQUEST['id']);
|
| +
|
| + if ( $id ) {
|
| + $sets = array();
|
| + $ids = split(",", $id);
|
| +
|
| + foreach ($ids as $i) {
|
| + $query = mysql_query( "SELECT * FROM runs WHERE id=$i;" );
|
| + $data = mysql_fetch_assoc($query);
|
| +
|
| + $query = mysql_query( "SELECT * FROM results WHERE run_id=$i;" );
|
| + $results = array();
|
| +
|
| + while ( $row = mysql_fetch_assoc($query) ) {
|
| + array_push($results, $row);
|
| + }
|
| +
|
| + $data['results'] = $results;
|
| + $data['ip'] = '';
|
| +
|
| + array_push($sets, $data);
|
| + }
|
| +
|
| + echo $json->encode($sets);
|
| + } else {
|
| + $data = $json->decode(str_replace('\\"', '"', $_REQUEST['data']));
|
| +
|
| + if ( $data ) {
|
| + mysql_query( sprintf("INSERT into runs VALUES(NULL,'%s','%s',NOW(),'%s');",
|
| + $_SERVER['HTTP_USER_AGENT'], $_SERVER['REMOTE_ADDR'], str_replace(';', "", $_REQUEST['style'])) );
|
| +
|
| + $id = mysql_insert_id();
|
| +
|
| + if ( $id ) {
|
| +
|
| + foreach ($data as $row) {
|
| + mysql_query( sprintf("INSERT into results VALUES(NULL,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');",
|
| + $id, $row->collection, $row->version, $row->name, $row->scale, $row->median, $row->min, $row->max, $row->mean, $row->deviation, $row->runs) );
|
| + }
|
| +
|
| + echo $id;
|
| + }
|
| + }
|
| + }
|
| +?>
|
|
|