dongye9228 2015-05-04 12:33
浏览 43

在mysql数据库上插入PHP不能使用PDO(带有预处理语句)


I'm doing a simple website with DropzoneJS for uploading files and insert into my database some info about the uploader, file type ect.
But the problem is I don't see anything in my 'upload_log' table after file upload.
Here's my upload.php code :

$ds = DIRECTORY_SEPARATOR;
    $foldername = "../common/uploads";

    if (!empty($_FILES)) {
        $fileupload = basename( $_FILES['file']['name']);
        $fileType = $_FILES['file']['type'];
        $fileSize = $_FILES['file']['size'];

        $tempFile = $_FILES['file']['tmp_name'];
        $targetPath = dirname( __FILE__ ) . $ds. $foldername . $ds;
        $targetFile =  $targetPath. $fileupload;
        move_uploaded_file($tempFile,$targetFile);
        $upload_info = "Filetype : <b>".$fileType."</b> <br>File size : <b>".$fileSize."</b><br>File name : <b> ".$fileupload."</b>";
        add_to_log($_SESSION['username'], 'upload', $upload_info);
    }

The function "add_to_log" :


function add_to_log($usr, $type, $info) {
$servername = 'localhost';
$dbname = 'foo';
$username = 'root';
$password = 'foo';
try
{
    $bdd = new PDO('mysql:host='.$servername.';dbname='.$dbname.'', $username, $password);
}
catch(Exception $e)
{
        die('DB error');
}
$req = $bdd->prepare('INSERT INTO upload_log(type, user, info) VALUES(:type, :user, :info)');
$req->execute(array(
    'type' => $type,
    'user' => $user,
    'info' => $info
    ));
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 机器学习能否像多层线性模型一样处理嵌套数据
    • ¥20 西门子S7-Graph,S7-300,梯形图
    • ¥50 用易语言http 访问不了网页
    • ¥50 safari浏览器fetch提交数据后数据丢失问题
    • ¥15 matlab不知道怎么改,求解答!!
    • ¥15 永磁直线电机的电流环pi调不出来
    • ¥15 用stata实现聚类的代码
    • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
    • ¥20 docker里部署springboot项目,访问不到扬声器
    • ¥15 netty整合springboot之后自动重连失效