php新浪云链接mysql与storage

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的返回信息

?>

巴特西

php新浪云链接mysql与storage

最新文章

热门文章