Die Website für die Meldung verlorener oder gefundener Objekte oder vermisster Haustiere.
Wo ehrliche Finder gefunden werden und verlorene Objekte mit ihrem rechtmäßigen Eigentümer wieder vereint werden. Kostenlos!
Follow @DasFundburo
if(isset($_GET['q']) && strlen($_GET['q'])) { ?>
Datum
Bild
Nachricht
Verloren Gefunden
/* +--------------+----------------------------------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------------------------------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | | auto_increment |
| hash | varchar(32) | NO | | | |
| date_added | timestamp | YES | | CURRENT_TIMESTAMP | |
| type | enum('LOST','FOUND') | NO | | LOST | |
| title | varchar(50) | YES | | | |
| hoofdrubriek | varchar(50) | NO | | | |
| subrubriek | varchar(50) | NO | | | |
| date1 | datetime | NO | | | |
| date2 | datetime | YES | | | |
| description | text | YES | | | |
| plaats_id | int(11) | NO | | 0 | |
| lokatie | text | YES | | | |
| abroad | tinyint(1) | YES | | 0 | |
| pubtrans | varchar(50) | YES | | | |
| report | tinyint(1) | YES | | 0 | |
| exchowner | tinyint(1) | YES | | 0 | |
| reward | varchar(255) | YES | | | |
| name | varchar(50) | NO | | Unknown | |
| email | varchar(128) | NO | | | |
| telephone | varchar(50) | YES | | | |
| status | enum('ACTIVE','PENDING','EXPIRED','DELETED') | NO | | PENDING | |
| has_image | tinyint(1) | NO | | 0 | |
+--------------+----------------------------------------------+------+-----+-------------------+----------------+
*/
//---------- Added pagination -----------------
$query = db_query("SELECT COUNT(*) FROM posts
WHERE status='ACTIVE'
AND
(
hoofdrubriek like '%".db_input($_GET['q'])."%'
OR
subrubriek like '%".db_input($_GET['q'])."%'
OR
title like '%".db_input($_GET['q'])."%'
OR
description like '%".db_input($_GET['q'])."%'
OR
lokatie like '%".db_input($_GET['q'])."%'
OR
pubtrans like '%".db_input($_GET['q'])."%'
)
AND country = '".addslashes($_SESSION['country'])."'
");
$count = mysql_result($query,0);
$PaginateIt = new PaginateIt();
$PaginateIt->SetItemCount($count);
$PaginateIt->SetItemsPerPage($config['results_per_page']);
$PaginateIt->SetLinksToDisplay($config['links_to_display']);
$PaginateIt->SetLinksFormat('<<' , ' | ' , '>>');
$PaginateIt->SetQueryString('q='.$_GET['q']);
$query = db_query("SELECT posts.id as id,
plaats,
DATE_FORMAT(date_added,'%d-%m-%Y') as date,
hoofdrubriek,
subrubriek,
title,
description,
has_image,
type
FROM posts
WHERE status='ACTIVE'
AND
(
hoofdrubriek like '%".db_input($_GET['q'])."%'
OR
subrubriek like '%".db_input($_GET['q'])."%'
OR
title like '%".db_input($_GET['q'])."%'
OR
description like '%".db_input($_GET['q'])."%'
OR
lokatie like '%".db_input($_GET['q'])."%'
OR
pubtrans like '%".db_input($_GET['q'])."%'
)
AND country = '".addslashes($_SESSION['country'])."'
ORDER BY date_added DESC".
$PaginateIt->GetSqlLimit()
);
while($row = db_fetch_array($query)) {
echo "