RHEL5上对mysql进行图片等文件存储例子

最新推荐文章于 2024-10-02 00:27:17 发布

weixin_30822451

最新推荐文章于 2024-10-02 00:27:17 发布

阅读量72

点赞数

文章标签：数据库 php

原文链接：http://www.cnblogs.com/weichaohan/archive/2008/11/28/1343211.html

版权

1、环境设置

php.ini中设upload_max_filesize=?M

my.cnf中设max_allowed_packet=?M

2、PHP例子

<?php


//This is a stand alone example, do include this in anything.


//MySQL credentials (fill these in)

$host = 'localhost';

$user = 'username';

$pass = 'password';

$db   = 'dbname';


$con = mysql_connect( $host,$user,$pass ) or die( 'Error: Could not connect' );

mysql_select_db( $db ) or die( 'Error: Unable to select database' );


$table =<<<SQL

CREATE TABLE IF NOT EXISTS `uploaded_images` (

`id` INT NOT NULL AUTO_INCREMENT,

`name` VARCHAR(30) NOT NULL,

`type` VARCHAR(30) NOT NULL,

`size` INT NOT NULL,

`content` MEDIUMBLOB NOT NULL,

PRIMARY KEY(`id`)

);

SQL;

$query = mysql_query( $table,$con );


$case = $_GET['case'];


switch( $case ) {

case "upload":

if ( isset( $_POST['submit'] ) && count( $_FILES ) > 0 ) {

if ( isset( $_FILES['image']['name'] ) && $_FILES['image']['name'] !== '' ) {

$fileName = basename( $_FILES['image']['name'] );

$fileType = $_FILES['image']['type'];

$tempFile = $_FILES['image']['tmp_name'];

$fileSize = filesize( $tempFile );

$open = fopen( $tempFile,'r' );

$data = fread( $open,$fileSize );

fclose( $open );

$sql   = "INSERT INTO `uploaded_images` (`name`,`type`,`size`,`content`) VALUES ('{$fileName}','{$fileType}','{$fileSize}','{$data}')";

$query = mysql_query( $sql,$con );

}

}

$url = $_SERVER['PHP_SELF'];

echo <<<HTML

<form action="$url?case=upload" method="post" enctype="multipart/form-data">

<input type="file" name="image" /><br />

<input type="submit" name="submit" value="Upload" />

</form>

HTML;

break;

case "view":

if ( isset( $_GET['id'] ) ) {

$id = mysql_real_escape_string( $_GET['id'] );

if ( is_numeric( $id ) ) {

$sql   = "SELECT `type`,`content` FROM `uploaded_images` WHERE `id` = {$id}";

$query = mysql_query( $sql,$con );

$total = mysql_num_rows( $query );

if ( $total == 1 ) {

list( $type,$data ) = mysql_fetch_row( $query );

header( "Content-type: {$type}" );

echo $data;

exit;

}

}

}

break;

}


?>


上传文件时使用filename.php?case=upload，查看时使用filename.php?case=view&id=《ID号》


读者可以根据需要自行修改更强的功能。