public function getSave() { $id = Input::get('id'); if ($id) { $employee = employee::find($id); $employee->full_name = Input::get('name'); $employee->position = Input::get('position'); $employee->gender = Input::get('gender'); $employee->phone = Input::get('phone'); $employee->email = Input::get('email'); $employee->address = Input::get('address'); $employee->city_id = Input::get('city_id'); $employee->save(); Session::flash('message', 'The records are updated successfully'); } else { $employee = new employee(); $employee->full_name = Input::get('name'); $employee->position = Input::get('position'); $employee->gender = Input::get('gender'); $employee->phone = Input::get('phone'); $employee->email = Input::get('email'); $employee->address = Input::get('address'); $employee->city_id = Input::get('city_id'); $employee->save(); Session::flash('message', 'The records are inserted successfully'); } return Redirect::to('employee'); }
<?php /** * Copyright (c) 2012 Ryan Yonzon, <*****@*****.**> * Dual licensed under the MIT and GPL licenses: * http://www.opensource.org/licenses/mit-license.php * http://www.gnu.org/licenses/gpl.html */ // Enable full-blown error reporting. http://twitter.com/rasmus/status/7448448829 error_reporting(-1); require '../ormbit.init.php'; // require and initialize ORMbit class // intantiate: /models/employee.model.php $employee = new employee(); $job_id = 1; // Software Engineer (from `job` table) $privilege = 'Administrator'; $record = array('first_name' => 'Curly', 'last_name' => 'Howard', 'phone' => '888-9999', 'job_id' => $job_id, 'access' => $privilege, 'created_on' => date("Y-m-d H:i:s", time())); // insert/save new record $id = $employee->save($record); // print record ID echo "Record ID: " . $id . "\n"; // -EOF-
public function save($id = 0, $login = '', $fullname = '', $profiles_id = 0) { // Check if this operation is requested to the default object if ($id != 0) { // Create, fill and save the employee $employee = new employee($id); $employee->fill($id, $login, $fullname, $profiles_id); $employee->save(); } else { $database = $_SESSION['database']; // Insert a new entry if one does not exist or update the existing one if (!$this->id_exists($this->id)) { // The entry does not exist $database->query("insert into " . TABLE_EMPLOYEES . " (employees_id, employees_login, employees_fullname, profiles_id) values ('" . $this->id . "', '" . $this->login . "', '" . $this->fullname . "', '" . $this->profile->id . "')"); } else { // The entry exists, update the contents $activity_query = $database->query("update " . TABLE_EMPLOYEES . " set employees_id='" . $this->id . "', employees_login='******', employees_fullname='" . $this->fullname . "', profiles_id='" . $this->profile->id . "' where employees_id = '" . (int) $this->id . "'"); } } }