日志
php通过表单上传照片到mySQL
|
首先打开mySQL 创建新的数据库
CREATE DATABASE LOADED;
USE LOADED;
CREATE TABLE LOADEDPIC(ID INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,PICPATH CHAR(50) NOT NULL);
1.html文件内容
<html>
<head>
<title>store binary data into sql database</title>
</head>
<body>
<head>
<title>store binary data into sql database</title>
</head>
<body>
<form method='post' action='2.php' enctype='multipart/form-data'> //注意enctype的值不能是其它
<input type='hidden' name='MAX_FILE_SIZE' value='1000000'>
<br>File to upload/store in database:<br>
<input type='file' name='form_data' size='40'>
<p><input type="submit" name="submit" value="submit">
</form>
</body>
</html>
<input type='hidden' name='MAX_FILE_SIZE' value='1000000'>
<br>File to upload/store in database:<br>
<input type='file' name='form_data' size='40'>
<p><input type="submit" name="submit" value="submit">
</form>
</body>
</html>
2.php文件内容
<?php
if(is_uploaded_file($_FILES['form_data']['tmp_name'])){
//print_r($_FILES);
//print_r($_POST);
$targetPath='C:/images/'.$_FILES['form_data']['name'];
if(move_uploaded_file($_FILES['form_data']['tmp_name'],$targetPath)){
echo 'Uploaded successfully!';
$link=mysql_connect('localhost','root','zhouwenhong');
if($link){
echo 'You have linked the mySQL!';
mysql_select_db('LOADED') or die('unable to select database');
//注意$targetPath要用引号才能正确插入数据
mysql_query("INSERT INTO LOADEDPIC(PICPATH)VALUES('$targetPath')") or die('unable to insert data!');
$ID=mysql_insert_id();
echo $ID;
}
}else{
echo 'Uploaded failing!';
}
}
?>
if(is_uploaded_file($_FILES['form_data']['tmp_name'])){
//print_r($_FILES);
//print_r($_POST);
$targetPath='C:/images/'.$_FILES['form_data']['name'];
if(move_uploaded_file($_FILES['form_data']['tmp_name'],$targetPath)){
echo 'Uploaded successfully!';
$link=mysql_connect('localhost','root','zhouwenhong');
if($link){
echo 'You have linked the mySQL!';
mysql_select_db('LOADED') or die('unable to select database');
//注意$targetPath要用引号才能正确插入数据
mysql_query("INSERT INTO LOADEDPIC(PICPATH)VALUES('$targetPath')") or die('unable to insert data!');
$ID=mysql_insert_id();
echo $ID;
}
}else{
echo 'Uploaded failing!';
}
}
?>
显示数据库中的图片
2.html文件内容
<html>
<body>
<?php
mysql_connect('localhost','root','zhouwenhong')or die('Unable to connect the database!');
mysql_select_db('loaded');
$result=mysql_query('SELECT PICPATH FROM LOADEDPIC')or die('Can not perform query!');
while($row=mysql_fetch_object($result)){
echo "<img src=\"$row->PICPATH\">";
//echo '<img src='.$row->PICPATH.'>'; //注意最后一个尖括号前不能加“/”，否则图片显示不出来，只显示红叉
}
?>
</body>
</html>
<body>
<?php
mysql_connect('localhost','root','zhouwenhong')or die('Unable to connect the database!');
mysql_select_db('loaded');
$result=mysql_query('SELECT PICPATH FROM LOADEDPIC')or die('Can not perform query!');
while($row=mysql_fetch_object($result)){
echo "<img src=\"$row->PICPATH\">";
//echo '<img src='.$row->PICPATH.'>'; //注意最后一个尖括号前不能加“/”，否则图片显示不出来，只显示红叉
}
?>
</body>
</html>
