use Illuminate\Support\Facades\Config;
use Illuminate\Support\Facades\DB;
class changeDatabase
{
public function getHandle($request)
{
$params = $request->All();
$sqlData = DB::table('sql_data')->where('sql_name', '=', $params['sql_name'])->first();
if (!$sqlData) {
return Apis::first()->data()->attach('code', 400)->error('数据连接失败')->getJson();
}
DB::purge('mysql');
Config::set('database.connections.mysql.host',$sqlData->host);
Config::set('database.connections.mysql.port',$sqlData->port);
Config::set('database.connections.mysql.database',$sqlData->database);
Config::set('database.connections.mysql.username',$sqlData->username);
Config::set('database.connections.mysql.password',$sqlData->password);
DB::reconnect('mysql');
$data= DB::select('select * from fa_admin where id >= 1', array(1));
return Apis::first()->data($data)->attach('code', 200)->success('数据连接成功')->getJson();
}
}