在config文件里面加入连接参数,比如:'db_config1'=>['type'=>'sqlsrv','hostname'=> '','database'=>'partner','username'=>'','password'=>'','charset'=>'utf8',],
<?php
namespace app\api\controller;
use think\Controller;
use think\Db;
use think\Request;
class User extends Controller
{
public function login(Request $request)
{
header('Access-Control-Allow-Origin:*');
if($request->isPost()){
$data=input('post.');
$connect=$data['connect'];
$pname=$data['pname'];
$param=$data['param'];
$str="'".$request->ip()."','".$param['login_name']."','".$param['login_psw']."','".$param['pc_name']."','".$param['pc_sn']."','".$param['sub_domain']."'";
$produce="exec [dbo].[".$pname."] ".$str;
$result=Db::connect($connect)->query($produce);
if($result[0][0]['id']>0){
session('userid', $result[0][0]['id']);
session('mycoid',$result[0][0]['mycoid']);
}
return json($result[0][0]);
}
}
}
$("#login").click(function (){
$.ajax({
type: "POST",
dataType: "json",
url: "http://localhost/tp5/public/index.php/api/user/login" ,
data: {
"connect": "db_config1",
"pname": "users_login_erp3",
"param": {
"login_name": "lgs",
"login_psw": "8",
"pc_name": "aaa",
"pc_sn":"bbb",
"sub_domain":"11"
},
"output":"row"
},
success: function (result) {
alert(result.id);
},
error : function() {
alert("登陆失败!");
}
});
});