/** * Run the database seeds. * * @return void */ public function run() { Eloquent::unguard(); DB::table('country')->delete(); Countries::create(array('id' => 1, 'name' => 'Ukraine', 'description' => 'Ukraina is a country in Eastern Europe', 'user_id' => 1)); Countries::create(array('id' => 2, 'name' => 'USA', 'description' => 'The United States of America, is a federal republic composed of 50 states', 'user_id' => 1)); Countries::create(array('id' => 3, 'name' => 'China', 'description' => 'China, is a sovereign state in East Asia. It is the worlds most populous country, with a population of over 1.35 billion.', 'user_id' => 1)); $this->command->info('Countries table seeded!'); }
public function addAction() { // set page title $this->view->pageTitle = 'Add Country'; // breadcrumb $this->pageBreadcrumbs[] = 'Add Country'; $this->view->setVar('pageBreadcrumbs', $this->pageBreadcrumbs); $this->view->name = null; $this->view->abbreviation = null; $country = new Countries(); // process post if ($this->request->isPost()) { // Receiving the variables sent by POST $this->view->name = $this->filter->sanitize($this->request->getPost('name', 'string'), "trim"); $this->view->abbreviation = $this->filter->sanitize($this->request->getPost('abbreviation'), "trim"); // save $country->name = $this->view->name; $country->abbreviation = $this->view->abbreviation; $country->created = date('Y-m-d H:i:s'); $country->modified = date('Y-m-d H:i:s'); $country->modified_by = $this->userSession['email']; if ($country->create() == false) { $this->logger->log("Failed to save", \Phalcon\Logger::ERROR); foreach ($country->getMessages() as $message) { $this->logger->log($message, \Phalcon\Logger::ERROR); } $this->getFlashSession('error', 'Sorry, we could not create a new country record. Please try again.', true); } else { $this->getFlashSession('success', 'New country record is created.', true); // Forward to index return $this->response->redirect("/country"); } } // post }