public function getDatabaseName() { $data = Farmbook::where('id', '=', $this->farmbook)->first(); if (is_null($data)) { $data = "No database"; } else { $data = $data->name; } return $data; }
/** * Show the application dashboard. * * @return \Illuminate\Http\Response */ public function store(Request $request, $id) { // current timestamp $now = Carbon\Carbon::now('Africa/Cairo')->toDateTimeString(); // get inpute $id = $request->input('id'); $name = $request->input('name'); $database = $request->input('database'); $suburbs = $request->input('suburbs'); //dd($suburbs); //$type = $request->input('type'); Farmbook::where('id', $id)->update(array('name' => $name, 'database' => $database, 'updated_at' => $now)); $farmbook = Farmbook::where('id', '=', $id)->first(); // store the deed suburbs $farmbook->suburbs()->sync($suburbs); // dd("user controller Store ",$id,,$farmbooks); Session::flash('flash_message', 'Updated ' . $name . ' at ' . $now); Session::flash('flash_type', 'alert-success'); return Redirect::back(); }
public function createdatabase(Request $request) { $file = storage_path() . '/databases/dummy_database.sql'; $file2 = storage_path() . '/databases/dummy_database.sql'; // check if the file exists if (file_exists($file)) { $sqldump = file_get_contents($file); } else { $file = "not found"; $message = 'missing dummy_database'; Session::flash('flash_message', $message); Session::flash('flash_type', 'alert-danger'); return Redirect::back()->with('flash_message', $message); } $database = $request->input('database'); $type = $request->input('type'); $database = $database . '_' . $type . '_farmbook2'; //dd($database); $servername = config('database.connections.mysql.host'); $username = config('database.connections.mysql.username'); $password = config('database.connections.mysql.password'); // dd('make database',$database); $dbname = 'tmp'; // connect to tmp database $otf = new \App\Database\OTF(['database' => $dbname]); $db = DB::connection($dbname); $sql = "CREATE DATABASE " . $database; //set created to false $created = false; try { // created database successfully $db->getpdo()->exec($sql); $created = true; } catch (Exception $ex) { // dd( $ex->getMessage()); // error creating database $message = $ex->getMessage(); } // database created success if ($created == true) { $Farmbook = Farmbook::where('database', '=', $database); $normal_name = str_replace('_', ' ', $database); $normal_name = str_replace('farmbook2', ' ', $normal_name); if ($Farmbook->count() > 0) { $Farmbook = Farmbook::where('database', '=', $database)->update(['database' => $database]); } else { // add to farmbooks $Farmbook = new Farmbook(); $Farmbook->name = $normal_name; $Farmbook->database = $database; $Farmbook->type = 0; $Farmbook->save(); } // connect to the new database $otf = new \App\Database\OTF(['database' => $database]); $db = DB::connection($database); // creates tables with dummy $db->getpdo()->exec($sqldump); $message = $database . ' created successfully.'; Session::flash('flash_message', $message); Session::flash('flash_type', 'alert-success'); } else { Session::flash('flash_message', $message); Session::flash('flash_type', 'alert-danger'); } return Redirect::back()->with('flash_message', $message); }