svnno****@sourc*****
svnno****@sourc*****
2011年 4月 24日 (日) 23:35:01 JST
ForkRevision: 6
http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=6
Author: hryksbt
Date: 2011-04-24 23:35:01 +0900 (Sun, 24 Apr 2011)
Log Message:
-----------
Modified Paths:
--------------
trunk/SmartUpload/include/database.php
trunk/SmartUpload/upload_file.php
Added Paths:
-----------
trunk/SmartUpload/data/aaa.jpg
trunk/SmartUpload/data/mopera.txt
trunk/SmartUpload/test.php
-------------- next part --------------
Added: trunk/SmartUpload/data/aaa.jpg
===================================================================
(Binary files differ)
Property changes on: trunk/SmartUpload/data/aaa.jpg
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/SmartUpload/data/mopera.txt
===================================================================
--- trunk/SmartUpload/data/mopera.txt (rev 0)
+++ trunk/SmartUpload/data/mopera.txt 2011-04-24 14:35:01 UTC (rev 6)
@@ -0,0 +1,16 @@
+ID: kyc6twgy
+PW: ekybutj2
+
+DNS 220.159.212.201
+DNS 220.159.212.201
+
+moperau ‰ŠúÝ’è
+
+ID: d6uv788c
+APN: mopera.net
+PW: kaz34612
+
+151 1 4
+
+‚Ђ©‚è“d˜b
+00:80:87:19:DE:1C
Property changes on: trunk/SmartUpload/data/mopera.txt
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Modified: trunk/SmartUpload/include/database.php
===================================================================
--- trunk/SmartUpload/include/database.php 2011-04-18 15:47:41 UTC (rev 5)
+++ trunk/SmartUpload/include/database.php 2011-04-24 14:35:01 UTC (rev 6)
@@ -1,4 +1,5 @@
<?php
+/*
// MDB2 ライブラリã®èªã¿è¾¼ã¿
require_once("MDB2.php");
@@ -21,4 +22,19 @@
// æ–‡å—コードã®æŒ‡å®š
$mdb2->setCharset( "utf8" );
+*/
+
+//PDOã§æŽ¥ç¶š
+try {
+ //DBã¸æŽ¥ç¶š
+ $pdo = new PDO(
+ "mysql:host=localhost;dbname=upload","root","san59shi");
+
+} catch (PDOException $e){
+ var_dump($e->getMessage());
+}
+
+//PDO切æ–
+$pdo = null;
+
?>
\ No newline at end of file
Added: trunk/SmartUpload/test.php
===================================================================
--- trunk/SmartUpload/test.php (rev 0)
+++ trunk/SmartUpload/test.php 2011-04-24 14:35:01 UTC (rev 6)
@@ -0,0 +1,24 @@
+<?php
+/*
+ * SmartUpload/upload.php
+ * @author Hiroyuki Shibata
+ * 2011/04/17
+ * Rev 1.0
+ *
+ */
+
+ try {
+ $pdo = new PDO(
+ "mysql:host=localhost; dbname=upload", "root", "san59shi");
+ $stmt = $pdo->query("SELECT * FROM data_info");
+
+ while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
+ echo implode(", ", $row) . PHP_EOL;
+ }
+} catch (PDOException $e){
+ var_dump($e->getMessage());
+}
+
+$pdo = null;
+
+?>
\ No newline at end of file
Modified: trunk/SmartUpload/upload_file.php
===================================================================
--- trunk/SmartUpload/upload_file.php 2011-04-18 15:47:41 UTC (rev 5)
+++ trunk/SmartUpload/upload_file.php 2011-04-24 14:35:01 UTC (rev 6)
@@ -36,7 +36,7 @@
mysql_set_charset("utf8");
mysql_select_db( "upload" );
*/
-
+/*
$abc = "select * from data_info";
$res = "mysql_query( $abc ))";
@@ -45,16 +45,19 @@
print( $row["uploaddate"]."<br />" );
print( $row["data_size" ] );
}
+*/
//↑↑↑test↑↑↑
// データベースã«è¨˜éŒ²
+ /*
$sql = "INSERT INTO data_info ( filename, uploaddate, data_size ) VALUES ( 'a', now(),1 ) ";
+ //sqlã®ç¢ºèªãƒ†ã‚¹ãƒˆ
echo $sql."<br />";
$stmt=$db->prepare("$sql");
$stmt->execute( array( $filename, $filesize ) );
-
+*/
}
?>