php新浪云链接mysql与storage

最新推荐文章于 2021-03-12 09:50:09 发布

weixin_30314813

最新推荐文章于 2021-03-12 09:50:09 发布

阅读量117

点赞数

文章标签： php 数据库

原文链接：http://www.cnblogs.com/huangqiming/p/6654634.html

版权

1、首先要有一个新浪云服务器

2、链接数据库获取数据

mysql

CREATE TABLE Persons(FirstName varchar(255),LastName varchar(255));
insert into Persons values("张三","大张三"),("李四","小李四");

php

<?php
header('Content-Type: application/json');
$output = [];

//$conn =@mysqli_connect("localhost","root","","nfit2017");
$conn = mysqli_connect(SAE_MYSQL_HOST_M, SAE_MYSQL_USER, SAE_MYSQL_PASS,  SAE_MYSQL_DB, SAE_MYSQL_PORT);
$sql = 'SET NAMES UTF8';
mysqli_query($conn,  $sql);
$sql = "SELECT FirstName FROM Persons";
$result = mysqli_query($conn, $sql);

//从结果集中读取一行记录
 while( true ){
     //从结果集中读取一行记录
     $row = mysqli_fetch_assoc($result);
     if(! $row ){  //没有获取到更多记录行
         break;
     }
     $output[] = $row;
 }

echo json_encode($output);
?>

3、上传文件利用storage

html

<html>
<head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <title>上传文件</title>
</head>
<body>
<p>所有文件</p>
<form enctype="multipart/form-data" action="index.php" method="post" class="upload">
    <input name='myfile' type='file' class="dropify" data-default-file="url_of_your_file"/>
    <input type="submit" value="上传"/>
</form>
<script src="js/jquery-3.2.0.min.js"></script>
<script>
//防止页面自动跳转的方法，注意改好class名字
    $('form').submit(function (event) {
        event.preventDefault();
        var form = $(this);
        if (!form.hasClass('upload')) {
            //普通表单
            $.ajax({
                type: form.attr('method'),
                url: form.attr('action'),
                data: form.serialize(),
                success:function(){
                    //成功提交
                }
            })
        }else {
            // mulitipart form,如文件上传类
            var formData = new FormData(this);
            $.ajax({
                type: form.attr('method'),
                url: form.attr('action'),
                data: formData,
                mimeType: "multipart/form-data",
                contentType: false,
                cache: false,
                processData: false,
                success:function(){
                    //成功提交
                }
            })
        }
    });
</script>
</body>
</html>

php

<?php
    $s2 = new SaeStorage();
    $name =$_FILES['myfile']['name'];
    $s2->upload('test',$name,$_FILES['myfile']['tmp_name']);//把用户传到SAE的文件转存到名为test的storage  ,$_FILES["file"]["tmp_name"] - 存储在服务器的文件的临时副本的名称
    // echo $s2->getUrl("test",$name);//输出文件在storage的访问路径
    // echo '<br/>';
    // echo $s2->errmsg(); //输出storage的返回信息
?>

转载于:https://www.cnblogs.com/huangqiming/p/6654634.html