/** * * Enter description here ... */ public static function getAll() { $dbh = $GLOBALS['dbh']; $result = array(); $sql = "\n\t\t\tSELECT\n\t\t\t\t* \n\t\t\tFROM \n\t\t\t\t`range`\n\t\t"; foreach ($dbh->query($sql) as $r) { $range = new Range(); $range->set_id($r['id']); $range->set_name($r['name']); $result[] = $range; } return $result; }
<?php include_once 'class/range.class.php'; // Insert if (isset($_POST['insert'])) { $range = new Range(); $range->set_name((string) $_POST['name']); Range::save($range); die('1'); } // Update if (isset($_POST['update'])) { $range = new Range(); $range->set_id((int) $_POST['id']); $range->set_name((string) $_POST['name']); Range::save($range); die('1'); } // Delete if (isset($_POST['delete'])) { Range::delete((int) $_POST['id']); die('1'); } $ranges = Range::getAll(); $smarty->assign('ranges', $ranges); $smarty->display('range.tpl');