Search jQuery

jQuery Forum

jQuery Mobile

jacco tro..

search engine problem

in jQuery Mobile • 7 years ago

//php page zoeken.php contains:
<?php
//alle ingevuld gegevens worden opgehaald en bewaard
$zoeken = $_GET["searchbox"];
print($zoeken);
$terms = explode (" ", $zoeken) ;
$query= "SELECT * FROM artikel WHERE " ;
foreach($terms as $each){
$i++ ;
if($i == 1)
$query .= "Omschrijving LIKE '%$each%'" ;
else
$query .= "OR Omschrijving LIKE '%$each%' ";
}
//connect
mysql_connect("localhost","meubels","wachtwoord") or die("Fout: Er is geen verbinding met de MySQL-server tot stand gebracht!");
mysql_select_db("meubels_co") or die("Fout: Het openen van de database is mislukt!");
$query= mysql_query($query);
$numrows= mysql_num_rows($query);
if($numrows > 0 ){
while ($row= mysql_fetch_assoc($query)){
$Artikelnummer =$row['Artikelnummer'];
$Omschrijving=$row['Omschrijving'];
$Categorie=$row['Categorie'];
$Voorradig=$row['Voorradig'];
$Prijs=$row['Prijs'];
$link= $row['Link'];
echo "<a href= '$link'> $Omschrijving</a> ";
}
}
else
echo "No results found for $zoeken"
//disconnect
mysql_close();
?>
// html page contains:
<form action="zoeken.php" method="get" data-ajax="false">
<input type="text" name="searchbox">
<input type="submit" value="zoek">
</form>
this code wouldn't work could someone explain this to me?

Replies(5)

jakecigar

Re: search engine problem

7 years ago

If the query is wrong, you are not checking for errors.
It looks like you did not include a proper jQM <head> or any markup at all.
You are open to SQL injection from malicious hackers.
You chose to use data-ajax="false" which really messes up a smooth jQuery Mobile site.

JΛ̊KE

jacco tro..

Re: search engine problem

7 years ago

thanks for replying

1. I've checked my querys before i posted it

2. the head is there but not in the code i submitted

3. i know

4. thats the problem if i don't use data ajax-false it returns error loading page

and if you inculde data-ajax="false" he returns a blank page

jakecigar

Re: search engine problem

7 years ago

We can’t guess what the problem is. It probably has to do with the the code you left out. Your Query result page has to have the JQM structure. From what you showed it does not.

Share a link to your site.

JΛ̊KE

jacco tro..

Re: search engine problem

7 years ago

the site link

good luck

and the php code

for zoeken.php

<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Shoppen</title>
<link rel="stylesheet" href="jquerry/jquery.mobile-1.4.0.min.css" />
<script src="jquerry/jquery-1.9.1.min.js"></script>
<script src="jquerry/jquery.mobile-1.4.0.min.js"></script>
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Shoppen</title>
<link rel="stylesheet" href="jquerry/jquery.mobile-1.4.0.min.css" />
<script src="jquerry/jquery-1.9.1.min.js"></script>
<script src="jquerry/jquery.mobile-1.4.0.min.js"></script>
<script id="panel-init">
$(function()
{
$("body>[data-role='panel']").panel();
$("body > [data-role='panel'] [data-role='collapsible']").collapsible();
$("body > [data-role='panel'] [data-role='listview']").listview();
if(typeof(Storage)!=="undefined")
{
var tekst = "<p>Op jouw shoppinglist staan:</p>";
document.getElementById("lijst").innerHTML = tekst;
}
else
{
document.getElementById("lijst").innerHTML="Helaas, jouw browser ondersteunt geen WebStorage!";
}
}
);
</script>
</head>
<body>
<div id="pag1" data-role="page" data-theme="b">
<div data-role="header" style="text-align:right">
<a href="#producten" data-rel="menu" class="ui-btn ui-shadow ui-icon-bars ui-corner-all ui-btn-icon-left">Menu</a>
<h1>Meubels</h1>
<a href="#winkelmandje" class="ui-btn ui-corner-all ui-icon-shop ui-btn-icon-notext ui-btn-icon-right">Winkelmandje</a>
</div>
<div role="main" class="ui-content">
<div class="ui-body ui-body-b ui-corner-all">
<img src="logo.gif">
<form action="zoeken.php" method="get" data-ajax="false">
Welkom op de pagina van onze Meubel webshop.</br>
Zoek hieronder naar een product:</br></br>
<input type="text" name="searchbox" class="ui-input-text ui-body-null ui-corner-all ui-shadow-inset ui-body-c" />
<input type="submit" value="Zoeken">
</form>
<?php
//alle ingevuld gegevens worden opgehaald en bewaard
$zoeken = $_GET["searchbox"];
print($zoeken);
$terms = explode (" ", $zoeken) ;
$query= "SELECT * FROM artikel WHERE " ;
foreach($terms as $each){
$i++ ;
if($i == 1)
$query .= "Omschrijving LIKE '%$each%'" ;
else
$query .= "OR Omschrijving LIKE '%$each%' ";
}
//connect
mysql_connect("localhost","meubels","wachtwoord") or die("Fout: Er is geen verbinding met de MySQL-server tot stand gebracht!");
mysql_select_db("meubels_co") or die("Fout: Het openen van de database is mislukt!");
$query= mysql_query($query);
$numrows= mysql_num_rows($query);
if($numrows > 0 ){
while ($row= mysql_fetch_assoc($query)){
$Artikelnummer =$row['Artikelnummer'];
$Omschrijving=$row['Omschrijving'];
$Categorie=$row['Categorie'];
$Voorradig=$row['Voorradig'];
$Prijs=$row['Prijs'];
$link= $row['Link'];
echo "<a href= '$link'> $Omschrijving</a> ";
}
}
else
echo "No results found for $zoeken"
//disconnect
mysql_close();
?>
</div>
</div>
<div data-role="footer" data-position="fixed">
<div data-role="navbar">
<ul>
<li><a href="#pag1">Home</a></li>
<li><a href="#pagcontact">Contact</a></li>
<li><a href="#pagregistreren">Registeren</a></li>
</ul>
</div>
</div>
</div>
</body>
</html>