Een zoekfunctie op meerdere criteria.

Door Michael op 31-01-2006 14:42

8.729 views

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;
<html xmlns="http://www.w3.org/1999/xhtml">;
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Debitel Sales Tool - Hoofdpagina</title>
</head>

<body>
<body text="#668014">
<body link="#009ACD">
<body vlink="#556B2F">
<body alink="#009ACD">

<table width="1024" border="0" cellpadding="0" cellspacing="0">


<tr>
<td height="81" colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="1024" height="81" background="images/ja.jpg"><div align="center">
<h1>Debitel Sales Tool</h1>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td width="192" rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="325" height="602" valign="top" background="images/Company-Boxed_SideBox.jpg"><blockquote>
<p> </p>
<p align="center">Hier vind je de laatste info!<br />
"info"</p>
</blockquote>

</td>
</tr>
</table></td>

<td width="208" height="107" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_01.jpg"><div align="center">
<h2><a href="index.html">Home</a></h2>
</div></td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td color="#668014" width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_02.jpg"><div align="center">
<h2><a href="aanbiedingdoen.html">Aanbieding doen</a></h2>
</div></td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_03.jpg">
<H2 align="center"><a href="Argumentatie.html">Argumentatie</a></h2>
</td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_04.jpg"><div align="center">
<h2><a href="Toestelinfo.html">Toestel info</a></h2>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="495" colspan="4" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="832" height="495" align="center" valign="top" background="images/Company-Boxed_MainBox.jpg"><div align="center">
<p> </p>
<blockquote>

<?php

// connect script
$db_host = 'localhost';
$db_user = 'interfoon';
$db_pass = '';
$db_name = 'interfoon_nl_db';

mysql_connect ($db_host, $db_user, $db_pass);
@mysql_select_db ($db_name) or die ('Fout bij het selecteren van de database');

unset ($db_host, $db_user, $db_pass, $db_name);

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if ($_POST['merk'] == 'geen voorkeur') {
$voorwaarden = "";
$and = false;
}
else {
$voorwaarden = " WHERE merk LIKE '".$_POST['merk']."'";
$and = true;
}
if (isset ($_POST['camera'])) {
if ($and) {
$voorwaarden = ' AND camera = 1';
}
else {
$voorwaarden = ' WHERE camera = 1';
$and = true;
}
}
if (isset ($_POST['bluetooth'])) {
if ($and) {
$voorwaarden = ' AND bluetooth = 1';
}
else {
$voorwaarden = ' WHERE bluetooth = 1';
$and = true;
}
}
if (isset ($_POST['umts'])) {
if ($and) {
$voorwaarden = ' AND umts = 1';
}
else {
$voorwaarden = ' WHERE umts = 1';
$and = true;
}
}
$sql = "
SELECT merk, model, kort, prijs, leverbaar, kleur, link
FROM products" . $voorwaarden;

// hierna je query uitvoeren
}
$result=mysql_query($sql);

echo "<table border=1>\n";

echo "<tr><b><td>Merk</td><td>Model</td><td>Prijs in €</td><td>Extra's</td><td>Kleur</td><td>Leverbaar</td><td>Meer info</td><b></tr>\n";

while ($myrow = mysql_fetch_row($result)) {

printf("<tr><td>%s</td> <td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",
$myrow[0], $myrow[1], $myrow[3], $myrow[2], $myrow[5], $myrow[4], $myrow[6]);

}

echo "</query>\n";

?>
<p align="left"> </p>
<p align="left"><br />
</p>
<p align="left"></p>
<p align="left"> </p>
</blockquote>
</div></td>
</tr>
</table></td>
</tr>

<tr>
<td height="85" colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="1024" height="85" align="center" valign="bottom" background="images/ja.jpg"><div align="center">
<h5>Copyright (c) 2006 <a href="mailto:[email protected]">Mike</a></h5>
</div></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

de bovenstaande pagina gaat het om.

Er zit nu een zoekfunctie in op 1 criteria.
Hoe krijg ik er zoekfunctie in op meerdere criteria
en hoe krijg ik er een beperking in op de resultaten.
bijv. 15 per pagina

Michael

07-02-2006 16:17

ff checken

Michael

07-02-2006 16:22

echo $link_prev . "  ";
$linkpagnext= "<a href=result.php?pagina="
for ($i=1;$i <= $aantal_pags; $i++){;
echo ("$linkpagnext$i>[$i]  </a>");
}
het stukje ziet ernu zo uit maar geeft nog steeds die fout weer

Robert Deiman

07-02-2006 16:22

Oké.. ben benieuwd of het dan goed is. Als het niet goed is, mag je meteen de error aangeven, dan ben ik benieuwd.

Robert Deiman

07-02-2006 16:23

<?php
echo $link_prev . "  ";
$linkpagnext= "<a href=result.php?pagina=";//puntcomma hier
for ($i=1;$i <= $aantal_pags; $i++){;
echo ("$linkpagnext$i>[$i]  </a>");
}
?>

Michael

07-02-2006 16:27

hmmm nu geeft ie een fout in regel 251
maar daar staat alleen de html tag
</html>

Robert Deiman

07-02-2006 16:28

Blijkbaar iets meer { dan } in het script.. ik zal eens kijken ;)

Robert Deiman

07-02-2006 16:31

Zo dan?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;
<html xmlns="http://www.w3.org/1999/xhtml">;
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Debitel Sales Tool - Hoofdpagina</title>
</head>

<body>
<body text="#668014">
<body link="#009ACD">
<body vlink="#556B2F">
<body alink="#009ACD">

<table width="1024" border="0" cellpadding="0" cellspacing="0">


<tr>
<td height="81" colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="1024" height="81" background="images/ja.jpg"><div align="center">
<h1>Debitel Sales Tool</h1>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td width="192" rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="325" height="602" valign="top" background="images/Company-Boxed_SideBox.jpg"><blockquote>
<p> </p>
<p align="center">Hier vind je de laatste info!<br />
"info"</p>
</blockquote>

</td>
</tr>
</table></td>

<td width="208" height="107" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_01.jpg"><div align="center">
<h2><a href="index.html">Home</a></h2>
</div></td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td color="#668014" width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_02.jpg"><div align="center">
<h2><a href="aanbiedingdoen.html">Aanbieding doen</a></h2>
</div></td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_03.jpg">
<H2 align="center"><a href="Argumentatie.html">Argumentatie</a></h2>
</td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_04.jpg"><div align="center">
<h2><a href="Toestelinfo.html">Toestel info</a></h2>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="495" colspan="4" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="832" height="495" align="center" valign="top" background="images/Company-Boxed_MainBox.jpg"><div align="center">
<p> </p>
<blockquote>
<?php
// begin deel 1 pagina nummer script
// stel aantal records per pagina in
$aantalperpag=10;

if(isset($_GET['positie']) && $_GET['positie'] == 0){
$begin=0;
}else if (isset($_GET['positie']) && $_GET['positie']<>0){
$begin=(int)$_GET['positie'];
}

if(isset($_GET['pagina']) && $_GET['pagina']==1){
$begin=0;
}
else if(isset($_GET['pagina']) && $_GET['pagina'] > 1){
$begin= ($_GET['pagina']-1)*$telaantal;
}
//einde deel 1 pagina nummer script

// connect script
$db_host = 'localhost';
$db_user = 'interfoon';
$db_pass = '';
$db_name = 'interfoon_nl_db';

mysql_connect ($db_host, $db_user, $db_pass);
@mysql_select_db ($db_name) or die ('Fout bij het selecteren van de database');

unset ($db_host, $db_user, $db_pass, $db_name);

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if ($_POST['merk'] == 'geen voorkeur') {
$voorwaarden .= "";
$and = false;
}
else {
$voorwaarden .= " WHERE merk LIKE '".$_POST['merk']."'";
$and = true;
}
if (isset ($_POST['camera'])) {
if ($and) {
$voorwaarden .= ' AND camera = 1';
}
else {
$voorwaarden .= ' WHERE camera = 1';
$and = true;
}
}
if (isset ($_POST['bluetooth'])) {
if ($and) {
$voorwaarden .= ' AND bluetooth = 1';
}
else {
$voorwaarden .= ' WHERE bluetooth = 1';
$and = true;
}
}
if (isset ($_POST['umts'])) {
if ($and) {
$voorwaarden .= ' AND umts = 1';
}
else {
$voorwaarden .= ' WHERE umts = 1';
$and = true;
}
}
// query ook iets aangepast
$sql = "
SELECT merk, model, kort, prijs, leverbaar, kleur, link
FROM products" . $voorwaarden." LIMIT".$begin.",".$aantalperpag;

// hierna je query uitvoeren
}
$result=mysql_query($sql);
// begin deel 2 van telscript
// aantal pagina's tellen
$aantal_rec=mysql_num_rows($result);
$aantal_pags=round($aantal_rec / $telaantal);
$new_pos_next=$begin+$aantalperpag;
if($new_pos_next>=$aantal_rec){
$link_next="Volgende >>";
}else {
$link_next="<a href=?positie=" . $new_pos_next . ">Volgende >></a>";
}
$new_pos_prev=$begin-$aantalperpag;
if($new_pos_prev<0){
$link_prev="<< Vorige";
} else {
$link_prev="<a href=?positie=" . $new_pos_prev . "><< Vorige</a>";
}

// einde deel 2 van het telcript

echo "<table border=1>\n";

echo "<tr><b><td>Merk</td><td>Model</td><td>Prijs in €</td><td>Extra's</td><td>Kleur</td><td>Leverbaar</td><td>Meer info</td><b></tr>\n";

while ($myrow = mysql_fetch_row($result)) {

printf("<tr><td>%s</td> <td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",
$myrow[0], $myrow[1], $myrow[3], $myrow[2], $myrow[5], $myrow[4], $myrow[6]);

// weergeven vorige/ volgende link
echo $link_prev . "  ";
$linkpagnext= "<a href=?pagina="
for ($i=1;$i <= $aantal_pags;$i++){
echo ("$linkpagnext$i>[$i]  </a>");
}
echo $link_next;
// einde weergeven vorige /volgende link

}
echo $query."\n";
?>
<p align="left"> </p>
<p align="left"><br />
</p>
<p align="left"></p>
<p align="left"> </p>
</blockquote>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="85" colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="1024" height="85" align="center" valign="bottom" background="images/ja.jpg"><div align="center">
<h5>Copyright (c) 2006 <a href="mailto:[email protected]">Mike</a></h5>
</div></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

Michael

07-02-2006 16:31

!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">;
<html xmlns="http://www.w3.org/1999/xhtml">;
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Debitel Sales Tool - Hoofdpagina</title>
</head>

<body

text="#668014"
link="#009ACD"
vlink="#556B2F"
alink="#009ACD">

<table width="1024" border="0" cellpadding="0" cellspacing="0">

<tr>
<td height="81" colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="1024" height="81" background="images/ja.jpg"><div align="center"> </div></td>
</tr>
</table></td>
</tr>
<tr>
<td width="192" rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="325" height="602" valign="top" background="images/Company-Boxed_SideBox.jpg"><blockquote>

<p align="center">Hier vind je de laatste info!<br />
"info"</p>
</blockquote></td>
</tr>
</table></td>
<td width="192" height="107" valign="top"><table width="100%" border="0" cellpadding="2" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_01.jpg"><div align="center">
<h2><a href="index.html">Home</a></h2>
</div></td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td color="#668014" width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_02.jpg"><div align="center">
<h2><a href="aanbiedingdoen.html">Aanbieding doen</a></h2>
</div></td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_03.jpg"><h2 align="center"><a href="Argumentatie.html">Argumentatie</a></h2
></td>
</tr>
</table></td>
<td width="208" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="208" height="107" align="center" valign="middle" background="images/Company-Boxed_TobBox_04.jpg"><div align="center">
<h2><a href="Toestelinfo.html">Toestel info</a></h2>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="495" colspan="4" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="832" height="495" align="center" valign="top" background="images/Company-Boxed_MainBox.jpg"><div align="center">
<p> </p>
<blockquote>
<p align="left"><b>De volgende resultaten zijn gevonden:</b> </p>

<?php
// begin deel 1 pagina nummer script
// stel aantal records per pagina in
$aantalperpag=10;

if(isset($_GET['positie']) && $_GET['positie'] == 0){
$begin=0;
}else if (isset($_GET['positie']) && $_GET['positie']<>0){
$begin=(int)$_GET['positie'];
}

if(isset($_GET['pagina']) && $_GET['pagina']==1){
$begin=0;
}
else if(isset($_GET['pagina']) && $_GET['pagina'] > 1){
$begin= ($_GET['pagina']-1)*$telaantal;
}
//einde deel 1 pagina nummer script

// connect script
$db_host = 'localhost';
$db_user = 'interfoon';
$db_pass = '';
$db_name = 'interfoon_nl_db';

mysql_connect ($db_host, $db_user, $db_pass);
@mysql_select_db ($db_name) or die ('Fout bij het selecteren van de database');

unset ($db_host, $db_user, $db_pass, $db_name);

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if ($_POST['merk'] == 'geen voorkeur') {
$voorwaarden .= "";
$and = false;
}
else {
$voorwaarden .= " WHERE merk LIKE '".$_POST['merk']."'";
$and = true;
}
if (isset ($_POST['camera'])) {
if ($and) {
$voorwaarden .= ' AND camera = 1';
}
else {
$voorwaarden .= ' WHERE camera = 1';
$and = true;
}
}
if (isset ($_POST['bluetooth'])) {
if ($and) {
$voorwaarden .= ' AND bluetooth = 1';
}
else {
$voorwaarden .= ' WHERE bluetooth = 1';
$and = true;
}
}
if (isset ($_POST['umts'])) {
if ($and) {
$voorwaarden .= ' AND umts = 1';
}
else {
$voorwaarden .= ' WHERE umts = 1';
$and = true;
}
}
// query ook iets aangepast
$sql = "
SELECT merk, model, kort, prijs, leverbaar, kleur, link
FROM products" . $voorwaarden." LIMIT ".$begin.",".$aantalperpag;

// hierna je query uitvoeren
}
$result=mysql_query($sql);
// begin deel 2 van telscript
// aantal pagina's tellen
$aantal_rec=mysql_num_rows($result);
$aantal_pags=round($aantal_rec / $telaantal);
$new_pos_next=$begin+$aantalperpag;
if($new_pos_next>=$aantal_rec){
$link_next="Volgende >>";
}else {
$link_next="<a href=index.php?positie=" . $new_pos_next . ">Volgende >></a>";
}
$new_pos_prev=$begin-$aantalperpag;
if($new_pos_prev<0){
$link_prev="<< Vorige";
} else {
$link_prev="<a href=index.php?positie=" . $new_pos_prev . "><< Vorige</a>";
}

// einde deel 2 van het telcript

echo "<table border=1>\n";

echo "<tr><b><td>Merk</td><td>Model</td><td>Prijs in €</td><td>Extra's</td><td>Kleur</td><td>Leverbaar</td><td>Meer info</td><b></tr>\n";

while ($myrow = mysql_fetch_row($result)) {

printf("<tr><td>%s</td> <td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n",
$myrow[0], $myrow[1], $myrow[3], $myrow[2], $myrow[5], $myrow[4], $myrow[6]);

// weergeven vorige/ volgende link
echo $link_prev . "  ";
$linkpagnext= "<a href=result.php?pagina=";
for ($i=1;$i <= $aantal_pags; $i++){
echo ("$linkpagnext$i>[$i]  </a>");
}
echo $link_next;
// einde weergeven vorige /volgende link
?>

}

echo $query."\n";

?>

<p align="left"><br />
</p>
<p align="left"></p>
<p align="left"> </p>
</blockquote>
</div></td>
</tr>
</table></td>
</tr>

<tr>
<td height="85" colspan="5" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="1024" height="85" align="center" valign="bottom" background="images/ja.jpg"><div align="center">
<h5>Copyright (c) 2006 <a href="mailto:[email protected]">Mike</a></h5>
</div></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

dit is em helemaal

Robert Deiman

07-02-2006 16:34

?>

}

echo $query."\n";

?>

Haal die 1e ?> eens weg ;)

Michael

07-02-2006 16:38

dan geeft ie hem wel weer maar geen resultaten

Reageren

Inloggen om te reageren