<?php
namespace app\index\controller;
use think\Controller;
use think\Db;
class Kline extends Common
{
public function kline() {
//$sqlresult = db('marksix') ->field('d_days as nameone,d_number_2 as nametwo,d_number_pro as namethree,d_number_1 as namefour,d_number_2 as namefive,d_ds as namesix')->order('d_days desc')->select();
$sqlresult = self::post();
// print_r($sqls);die;
// var_dump($sqlresult);die;
$result = array_reverse($sqlresult);
$data=[];
foreach ($result as $key => $value) {
// print_r($result);die;
$tempArr = [];
$time = $value['nameone'];
$times = strtotime($time). "000";
$tempArr[] = floatval($times);
$tempArr[] = floatval($value['nametwo']);
$tempArr[] = floatval($value['namethree']);
$tempArr[] = floatval($value['namefour']);
$tempArr[] = floatval($value['namefive']);
// var_dump($tempArr);
$tempArr[] = floatval($value['namesix']);
$data[] = $tempArr;
}
// $list = $data;
// var_dump($data);die;
if( isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH'])=='xmlhttprequest' ){
// $data['data'] = $data;
echo json_encode($data);die;
// return json($data);
}
// return $this->fetch()
// return json($data);
return view();
}
public function post(){
if($_POST){
$result = input('post.');
// var_dump($result);die;
if($result['dbname'] =='shangyan'){
$dbname = $result['dbname'];
$tablename = $result['tablename'];
$filename1 = $result['filename1'];
$filename2 = $result['filename2'];
$filename3 = $result['filename3'];
$filename4 = $result['filename4'];
$filename5 = $result['filename5'];
$filename6 = $result['filename6'];
// Db::connect('shangyan');
$sql = "select $filename1 as nameone,$filename2 as nametwo,$filename3 as namethree,$filename4 as namefour,$filename5 as namefive,$filename6 as namesix from $tablename order by $filename1 desc ";
// echo $sql;
$res = Db::query($sql);
// echo $sql;
// $res = Db::query($sql);
// var_dump($res);
}else if($result['dbname'] =='ball'){
// var_dump($result);
$dbname = $result['dbname'];
$tablename = $result['tablename'];
$filename1 = $result['filename1'];
$filename2 = $result['filename2'];
$filename3 = $result['filename3'];
$filename4 = $result['filename4'];
$filename5 = $result['filename5'];
$filename6 = $result['filename6'];
// Db::connect('shangyan');
$sql = "select $filename1 as nameone,$filename2 as nametwo,$filename3 as namethree,$filename4 as namefour,$filename5 as namefive,$filename6 as namesix from $tablename order by $filename1 desc ";
// echo $sql;
$res = Db::query($sql);
// $res = Db::query($sql);
}else{
$dbname = $result['dbname'];
$tablename = $result['tablename'];
$filename1 = $result['filename1'];
$filename2 = $result['filename2'];
$filename3 = $result['filename3'];
$filename4 = $result['filename4'];
$filename5 = $result['filename5'];
$filename6 = $result['filename6'];
// Db::connect('shangyan');
$sql = "select $filename1 as nameone,$filename2 as nametwo,$filename3 as namethree,$filename4 as namefour,$filename5 as namefive,$filename6 as namesix from $tablename order by $filename1 desc ";
// echo $sql;
$res = Db::query($sql);
// $res = Db::query($sql);
}
}
// var_dump($res);die;
return $res;
}
}这个代码使用原生的sql语言就不能运行，报错未定义变量 $res，使用tp5框架的查询方式就可以运行。拜托各位大佬帮忙看看 最佳答案
