CREATE TABLE ccs_image (?id int(4) unsigned NOT NULL auto_increment,?description varchar(250) default NULL,?bin_data longblob,?filename varchar(50) default NULL,?filesize varchar(50) default NULL,?filetype varchar(50) default NULL,?PRIMARY KEY (id))engine=myisam DEFAULT charset=utf8upimage.php運行一直都是請求失敗,請重試<?php header("Content-type:text/html;charset=utf8");if (isset($_POST['submit'])) {? $form_description = $_POST['form_description'];? $form_data_name = $_FILES['form_data']['name'];? $form_data_size = $_FILES['form_data']['size'];? $form_data_type = $_FILES['form_data']['type'];? $form_data = $_FILES['form_data']['tmp_name'];??? $servername = "localhost";$username = "root";$password = "root";$dbname = "test";? $conn = mysqli_connect($servername, $username, $password, $dbname);?if(! $conn ){? ? die("數(shù)據(jù)庫連接失敗" . mysqli_error());}else{echo '數(shù)據(jù)庫連接成功！';}? /* echo "<script>alert('提示內(nèi)容')</script>";*/$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));? //echo "mysqlPicture=".$data;$sql="insert into sss values('".$data."','');";? $result = $conn->query("INSERT INTO ccs_image (description,bin_data,filename,filesize,filetype)? ? ? ? ?VALUES ('".$form_description."','".$data."','".$form_data_name."','".$form_data_size."','".$form_data_type."')");? ? ??? if ($result) {? ? echo "圖片已存儲到數(shù)據(jù)庫";? } else {? ? echo "請求失敗,請重試";}}? ? ?>upimage.html<!doctype html><html><head>? <meta charset="UTF-8">? <meta name="viewport"? ? ?content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">? <meta http-equiv="X-UA-Compatible" content="ie=edge">? <style type="text/css">? ? *{margin: 1%}? </style>? <title>Document</title></head><body><form method="post" action="upimage.php" enctype="multipart/form-data">? 描述:? <input type="text" name="form_description" size="40">? <input type="hidden" name="MAX_FILE_SIZE" value="1000000"> <br>? 上傳文件到數(shù)據(jù)庫:? <input type="file" name="form_data" size="40"><br>? <input type="submit" name="submit" value="submit"></form></body></html>getimage.php<?php? $id =2;// $_GET['id']; 為簡潔,直接將id寫上了,正常應(yīng)該是通過用戶填入的id獲取的? $dsn='mysql:dbname=test;host=localhost';? $pdo=new PDO($dsn,'root','root');? $query = "select bin_data,filetype from ccs_image where id=2";? $result = $pdo->query($query);? $result=$result->fetchAll(2);//? var_dump($result);? $data = $result[0]['bin_data'];? $type = $result[0]['filetype'];? Header( "Content-type: $type");? echo $data;? ?>有人可以給我個完整代碼嗎?
添加回答
舉報
0/150
提交
取消