svnno****@sourc*****
svnno****@sourc*****
2011年 4月 25日 (月) 15:24:41 JST
ForkRevision: 11
http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=11
Author: hryksbt
Date: 2011-04-25 15:24:40 +0900 (Mon, 25 Apr 2011)
Log Message:
-----------
Modified Paths:
--------------
trunk/SmartUpload/include/database.php
trunk/SmartUpload/upload_file.php
-------------- next part --------------
Modified: trunk/SmartUpload/include/database.php
===================================================================
--- trunk/SmartUpload/include/database.php 2011-04-25 02:24:53 UTC (rev 10)
+++ trunk/SmartUpload/include/database.php 2011-04-25 06:24:40 UTC (rev 11)
@@ -1,27 +1,40 @@
<?php
-
+/*
+ * SmartUpload/upload.php
+ * @author Hiroyuki Shibata
+ * 2011/04/25
+ * Rev 1.0
+ *
+ */
+?>
+<html>
+<head>
+<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
+<title>SmartUpload</title>
+</head>
+<body>
+<?php
//PDOで接続
$dsn = 'mysql:dbname=upload;host=localhost';
$user = 'root';
-$password = 'Zaq12wsx';
+$password = '********';
try{
- $dbh = new PDO($dsn, $user, $password);
+ $db = new PDO($dsn, $user, $password);
print('接続に成功しました。<br>');
- //$dbh->query('SET NAMES utf8');
- $sql = 'select * from shouhin';
- foreach ($dbh->query($sql) as $row) {
+ $db->query('SET NAMES utf8');
+/* $sql = 'select * from data_info';
+ foreach ($db->query($sql) as $row[]) {
print($row['filename']);
print($row['uploaddate'].'<br>');
- }
+ }*/
}catch (PDOException $e){
print('Error:'.$e->getMessage());
die();
}
-$dbh = null;
+//$db = null;
-// PDO切断
-// $pdo = null;
-
-?>
\ No newline at end of file
+?>
+</body>
+</html>
\ No newline at end of file
Modified: trunk/SmartUpload/upload_file.php
===================================================================
--- trunk/SmartUpload/upload_file.php 2011-04-25 02:24:53 UTC (rev 10)
+++ trunk/SmartUpload/upload_file.php 2011-04-25 06:24:40 UTC (rev 11)
@@ -2,7 +2,7 @@
/*
* SmartUpload/upload.php
* @author Hiroyuki Shibata
- * 2011/04/17
+ * 2011/04/25
* Rev 1.0
*
*/
@@ -21,45 +21,33 @@
$updir = "./data/";
$filename = $_FILES['upfile']['name'];
$filesize = filesize($_FILES['upfile']['tmp_name']);
+
if(move_uploaded_file($_FILES['upfile']['tmp_name'], $updir.$filename)==FALSE){
print("Upload failed");
print($_FILES['upfile']['error']);
- }
- else {
+ } else {
print("<b> $filename </b> is uploaded.<br />");
print("size = "."$filesize"." bytes<br />");
-// ↓↓↓↓↓↓↓ データベース管理 ↓↓↓↓↓↓↓
+ $db = new PDO($dsn, $user, $password);
+ $db->query("show tables".'<br>');
- //↓↓↓test↓↓↓
- /* $conn = mysql_connect( "localhost", "root", "******" );
- mysql_set_charset("utf8");
- mysql_select_db( "upload" );
- */
-/*
- $abc = "select * from data_info";
- $res = "mysql_query( $abc ))";
+ // データベース
+ $stmt = $db->prepare(
+ "INSERT INTO data_info (filename, uploaddate, data_size)
+ VALUES(? ,now() ,?)");
+ $stmt->bindParam(1,$filename);
+ $stmt->bindParam(2,$filesize);
+ $stmt->execute();
- while( $row = mysql_fetch_array($res)){
- print( $row["filename" ]."<br />" );
- print( $row["uploaddate"]."<br />" );
- print( $row["data_size" ] );
+ print('<br>');
+ $sql ='select * from data_info';
+ foreach ($db->query($sql) as $row) {
+ print($row['filename']."<TAB>");
+ print($row['uploaddate'].'<TAB>');
+ print($row['data_size'].'<br />');
}
-*/
- //↑↑↑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 ) );
-*/
}
-
?>
</body>
</html>
\ No newline at end of file