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
