如何從另一個數(shù)據(jù)庫連接(.env 文件中的“mysql2”)在 laravel 中生成一個圖表,可能是餅圖或圓環(huán)圖?我知道如何從主數(shù)據(jù)庫生成圖表。但是這次我沒有遷移第二個數(shù)據(jù)庫,因為它已經(jīng)有表和數(shù)據(jù)了。我可以使用“dd”命令獲取數(shù)據(jù),但是如果我在其中生成圖表則是另一回事。請幫我做作業(yè)。這是我的HomeController.php<?phpnamespace App\Http\Controllers;use Illuminate\Http\Request;use App\User;use Illuminate\Support\Facades\DB;use Charts;class HomeController extends Controller{ /** * Create a new controller instance. * * @return void */ public function __construct() { $this->middleware('auth'); } /** * Show the application dashboard. * * @return \Illuminate\Contracts\Support\Renderable */ public function index() { // // $count = User::count(); $chart = Charts::database(User::all(),'line','highcharts') ->title('User Statistics') ->groupByYear(7) ->Width(0) ->ElementLabel('Total Users Registered') ->Responsive(true); return view('dashboard',['chart'=>$chart])->with('count', $count); // return view('dashboard', ['chart' => $chart]); // $count = User::count(); // return View::make('dashboard')->with('count', $count); // return view('dashboard'); } public function logout () { //logout user auth()->logout(); // redirect to homepage return redirect('/coindeoro'); } //FETCH DATA FROM THE SECOND DATABASE public function another(){ // $arr_graph = \DB::connection('mysql2')->select("SELECT * FROM ico_stages WHERE id = ?", [1]); $arr_graph = \DB::connection('mysql2')->select("SELECT * FROM ico_stages WHERE id = ?", [1]); //DISPLAY dd($arr_graph); }}
- 2 回答
- 0 關注
- 181 瀏覽
添加回答
舉報
0/150
提交
取消