public function delete($params){ $query = sprintf("DELETE FROM `online_booking` WHERE `id`='%s'", mysql_real_escape_string($params['id']) ); return parent::run($query); }
public function __construct() { if (file_exists(dirname(__FILE__) . '/config.ini')) { $this->config = parse_ini_file(dirname(__FILE__) . '/config.ini', TRUE); } $component = new Model('zip', dirname(__FILE__), $this); $this->_component = $component; $component->run(); }
public function __construct() { // erzeugt das Model Objekt, welches einiges erleichtern soll $component = new Model('course', dirname(__FILE__), $this); $this->_component = $component; // startet nun unsere Komponente, dabei kommt die Zuordnung von Aufruf und Funktion // aus der Commands.json $component->run(); }
public function submit($params){ $query = sprintf("INSERT INTO `online_booking` SET `date_from`='%s', `date_to`='%s', `destination`='%s', `accomodation`='%s', `transport`='%s', `payment_method`='%s', `address`='%s', `city`='%s', `telephone`='%s', `email`='%s', `reason`='%s'", mysql_real_escape_string($params['date_from']), mysql_real_escape_string($params['date_to']), mysql_real_escape_string($params['destination']), mysql_real_escape_string($params['accomodation']), mysql_real_escape_string($params['transport']), mysql_real_escape_string($params['payment_method']), mysql_real_escape_string($params['address']), mysql_real_escape_string($params['city']), mysql_real_escape_string($params['telephone']), mysql_real_escape_string($params['email']), mysql_real_escape_string($params['reason']) ); $id = parent::insert($query); if(isset($params['parent']['name']) && !empty($params['parent']['name'])) foreach($params['parent']['name'] as $key => $val){ //Add parents and date of birth $query_parents = sprintf("INSERT INTO `online_booking_passangers` SET `online_booking_id`='%s', `passanger`='%s', `birth_date`='%s', `type`='%s'", mysql_real_escape_string($id), mysql_real_escape_string($val), mysql_real_escape_string($params['parent']['birth_date'][$key]), mysql_real_escape_string('Putnik') ); parent::run($query_parents); } if(isset($params['child']['name']) && !empty($params['child']['name'])) foreach($params['child']['name'] as $key => $val){ //Add child and date of birth $query_child = sprintf("INSERT INTO `online_booking_passangers` SET `online_booking_id`='%s', `passanger`='%s', `birth_date`='%s', `type`='%s'", mysql_real_escape_string($id), mysql_real_escape_string($val), mysql_real_escape_string($params['child']['birth_date'][$key]), mysql_real_escape_string('Dete') ); parent::run($query_child); } return true; }
public function setVisible($params){ $query = sprintf("SELECT * FROM `accomodation_types` WHERE `id`='%s'", mysql_real_escape_string($params['id']) ); $row = parent::queryOne($query); //Change visible status $query = sprintf("UPDATE `accomodation_types` SET `visible`='%s' WHERE `id`='%s'", mysql_real_escape_string(1 - $row['visible']), mysql_real_escape_string($params['id']) ); parent::run($query); return true; }
public function __construct() { $component = new Model('', dirname(__FILE__), $this); $this->_component = $component; $component->run(); }
public function deleteService($params){ $query = sprintf("DELETE FROM `accomodation_services` WHERE `id`='%s'", mysql_real_escape_string($params['service_id']) ); return parent::run($query); }