function searchpager(&$conn, $page) { $sql = $this->pager_sql; $offset = ($page - 1) * $this->pager_items; $limit = $this->pager_items; $sql .= " LIMIT {$offset},{$limit}"; //print_r($sql); $result = $conn->makequery($sql); $arr_obj = array(); while ($result and $row = $conn->nextRow($result)) { $one_entry = new SpeedEntry(); $one_entry->setID($row[0]); $one_entry->setNumber($row[1]); $one_entry->setDescription($row[2]); $arr_obj[] = $one_entry; } return $arr_obj; }
$filename = $_FILES["file"]["tmp_name"][0]; $f = fopen($filename, "r"); //filter empty rows and check for "header" do { $data = fgetcsv($f, 1000, $delimiter); if (trim(strtolower($data[0])) == 'number' and trim(strtolower($data[1])) == 'callerid' and trim(strtolower($data[2])) == 'forward' and trim(strtolower($data[3])) == 'permission') { break; } } while ($data !== FALSE); if ($data !== FALSE) { //DELETE phonebook (empty phonebookEntryDel means no filters, so all!) $speedEntryDel = new SpeedEntry(); $daospeed->delete($dsspeed, $speedEntryDel); unset($speedEntryDel); while (($data = fgetcsv($f, 1000, $delimiter)) !== FALSE) { $speeddialEntry = new SpeedEntry(); $number = trim($data[0]); //1 field $description = trim($data[1]); //2 field $telnr = trim($data[2]); //3 field $permission = trim($data[3]); //4 field if (trim(strtolower($permission)) == 'no') { $permission = ""; } if (trim(strtolower($permission)) == 'yes') { $permission = "CHECKED"; } //insert only lines with both fields