1. 连接php文件书写
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
use QCloud_WeApp_SDK\Mysql\Mysql as DB; // 引入DB
class Tt extends CI_Controller {
public function index() {
$this->json([
'code' => 0,
'data' => [
'msg' => 'Hello World我是Tt文件。。。。。'
]
]);
}
public function test(){
echo "Look at this :hi it's me!";
}
public function cha(){
// ehco '查询';
$row = DB::select('nn',['*'],'name = "bnc"'); //查表名为nn的表里名字是bnc的数据
$this->json([
'data' => $row
]);
}
}
2.成功查到数据并输出输出
https://fmajp3wr.qcloud.la/weapp/tt/cha 是小程序腾讯云分配的开发环境的测试域名,生产环境下另行更换。
后台数据库: