<?php /** * Created by PhpStorm. * User: Adaministrator * Date: 2018/3/30 * Time: 21:24 */ //链接数据库 $servername = "182.254.147.87"; $username = "数据库用户名"; $password = "服务器密码"; $dbname = "服务器数据库"; $base_url='http://182.254.147.87/'; //https://123p2.sogoucdn.com/imgu/2018/03/20180331093834_260.gif $con = mysqli_connect($servername, $username, $password, $dbname); if (!$con) { die('Could not connect: ' . mysqli_error($con)); } $userid = $_POST['id']; //处理上传文件 $base_path = "./"; //上传文件的存放路径 //$base_path = "upload/"; $fileName = $_FILES['file']['name']; $name = explode('.', $fileName); $userpicads = $base_path . 'user_' . $userid . '.' . $name[1]; $fileurl = $base_url . 'user_' . $userid . '.' . $name[1]; /* 返回状态码: 300: 处理成功 301:服务器异常 */ $status = 301; if (move_uploaded_file($_FILES ['file'] ['tmp_name'], $userpicads)) { $status = 300; } else { $status = 301; } //如果保存文件成功,更新数据库 if ($status == 300) { $sql = "update myguests set file='{$fileurl}' where id='{$userid}'"; $result = mysqli_query($con, $sql); if (!$result) { die("Valid result!"); }else{ $sql2 = "SELECT * FROM myguests where id='{$userid}'"; $result2 = mysqli_query($con, $sql2); if (!$result2) { printf("Error: %s\n", mysqli_error($con)); exit(); }else{ while ($row=mysqli_fetch_array($result2, MYSQLI_BOTH)) { $jarr = array(); $count = count($row);//不能在循环语句中,由于每次删除 row数组长度都减小 for ($i = 0; $i < $count; $i++) { unset($row[$i]);//删除冗余数据 } array_push($jarr, $row); $json=array('status'=>'200', 'success'=>'true', 'data'=>$jarr); echo $str = json_encode($json);//将数组进行json编码 } } } mysqli_close($con); }
安卓PHP接口上传文件到服务器
最新推荐文章于 2024-07-12 18:19:14 发布