cvs: phpweb / ws.php
| From: | Rasmus Lerdorf | Date: | Tue, 28 Feb 2006 09:03:18 +0000 |
| Subject: | cvs: phpweb / ws.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-30716@lists.php.net to get a copy of this message | ||
rasmus Tue Feb 28 09:03:18 2006 UTC
Modified files:
/phpweb ws.php
Log:
Log to a db
http://cvs.php.net/viewcvs.cgi/phpweb/ws.php?r1=1.3&r2=1.4&diff_format=u
Index: phpweb/ws.php
diff -u phpweb/ws.php:1.3 phpweb/ws.php:1.4
--- phpweb/ws.php:1.3 Tue Feb 28 08:23:28 2006
+++ phpweb/ws.php Tue Feb 28 09:03:18 2006
@@ -15,15 +15,25 @@
'pecl'=>'site=pecl.php.net',
'talks'=>'site=talks.php.net',
);
-if(isset($sites[$_REQUEST['profile']])) $p = $sites[$_REQUEST['profile']];
-else $p = $sites['all'];
+if(isset($sites[$_REQUEST['profile']])) {
+ $scope = $_REQUEST['profile'];
+} else {
+ $scope = 'all';
+}
-$request =
"{$conf['svc']}?appid={$conf['appid']}&query=$q&start=$s&results=$r&{$p}&language=$l&output=php";
+$request =
"{$conf['svc']}?appid={$conf['appid']}&query=$q&start=$s&results=$r&{$sites[$scope]}&language=$l&output=php";
$data = @file_get_contents($request);
list($version,$status_code,$msg) = explode(' ',$http_response_header[0], 3);
if($status_code==200) echo $data;
else echo serialize($http_response_header[0]);
-$fp = fopen("/tmp/ws.log","a");
-fputs($fp,"$request\n");
-fclose($fp);
+
+$dbh = new PDO('mysql:host=localhost;dbname=ws', $conf['db_user'],
$conf['db_pw'], array(PDO::ATTR_PERSISTENT => true,
+
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true));
+$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+try {
+ $stmt = $dbh->prepare("INSERT INTO log (query,profile) VALUES (:query,:profile)");
+ $stmt->execute(array(':query'=>$q,':profile'=>$scope));
+} catch (PDOException $e) {
+
+}
?>