php上传图片并存入数据库_php上传图片到数据库

---

PHP上传图片

1 链接数据库

<?php 
	$server = "localhost";
	$user = "root";
	$password = "root";
	$db = "shoping";
	function connect($servername,$username,$password,$dbname){
	    // 创建连接
	    $conn = mysqli_connect($servername, $username, $password, $dbname);
	    // $this->conn = $conn;
	    // 检测连接
	    if ($conn->connect_error) {
	        die("连接失败: " . $conn->connect_error);
	    }else{
	        // echo 'cg';
			return $conn;
	    }
	};
	
?>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

2 编写上传方法

<?php
function moveimg($file,$path,$name){
    if(move_uploaded_file($file,$path.'/'.$name)){
        //  echo json_encode($_POST);
        echo 'yes';
    }else{
        echo 'no';
    }
}
?>
1
2
3
4
5
6
7
8
9
10

3 上传并存入数据库

<?php
    header('Content-Type: text/html;charset=utf-8');
    header('Access-Control-Allow-Origin:*'); // *代表允许任何网址请求
    include('../flieControl/moveimg.php');
    include('../mysql/linksql.php');
    $conn =  connect($server,$user,$password,$db );
    // 要移动到的文件夹
    $filepath = '/Applications/phpstudy/WWW/shopingdb/img/';
    // 要移动的文件临时位子
    $file = $_FILES['file']['tmp_name'];
    // 要移动的文件名
    $filename = $_FILES['file']['name'];
    // 文件的分类
    $PATH = $filepath.$_POST['class'];
    // 判断目录存不存在
    $path = file_exists($PATH);
    if($path){
        // 文件移动方法
       moveimg($file,$PATH,$filename);
    }else{
        mkdir($PATH,0777,true);
        moveimg($file,$PATH,$filename);
    }
 
?>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25