Search engine with textbox, dynamic dropdown with MySql. Need Help - Page 2

13 New Member

Hello everyone, this is my first post here so I will try to make it as clear as possible.

Firstly i have a database with a single table named "albums" with the following fields:

Expand|Select|Wrap|Line Numbers

 
albumid    int(11)         

genreid    varchar(30)     

albumtitle    varchar(30)     

albumauthor    varchar(30

numberofsongs    int(11     

price    int(11)

Then i have two php pages

Search.php :

Expand|Select|Wrap|Line Numbers

 
<html>
 
<center>
 
</br></br></br></br>
 
<img src="guitarlogo.jpg" alt="Music Database"/>
 
<form method="GET" action="Result.php">
 
<h2><b>Search Music Database:</b></h2>
 
<input type="text" name="mts" />

<input type="submit" name="submit" value="Search" />

</form>
 
<?php

$connection = mysql_connect("localhost","root",""); 

$fields = mysql_list_fields("ea09039", "albums", $connection); 

$columns = mysql_num_fields($fields); 

echo "<form action=Result.php method=POST>"; 
 
echo "<select name=Field>";

for ($i = 0; $i < $columns; $i++) { 

echo "<option value=$i>"; 

echo mysql_field_name($fields, $i); 

} 

echo "</select></form>"; 

?>
 
</center>
 
</html>

and Result.php :

Expand|Select|Wrap|Line Numbers

 
<?php
 
include("db.php");
 
$mts=$_GET["mts"];

$Field=$_GET["Field"];
 
$query="select * from albums where '$Field' like '%$mts%'";
 
$res2=mysql_query($query);
 
while($row=mysql_fetch_row($res2))

{

echo $row[2];

echo " has author ";

echo $row[3];

echo " and costs ";

echo $row[5];

echo " Euro.";

echo " And is from the genre ";

echo $row[1];

echo "<br/>";

}
 
?>

This is as far as i have gotten with this, but i keep getting errors.
Please if someone can help I would be very thankful.

Dec 10 '10

Subscribe Reply

7115

Xicer

New Member

Thank you Samishii23 the second part worked like a charm :D
Also thanks to everyone that contributed

Dec 10 '10 #11

Samishii23

246

New Member

Let me make a note about doing that. When you pass data like this there is a higher chance of someone finding out what your data is because they know something about your Database, though it is a bit far fetched, but the concept and possibility is there. Your better off using the #'s rather then the Field name itself.

You could use a field name array and do something like this:

Expand|Select|Wrap|Line Numbers

 $fields = array ('id','name','date');

$Field = $fields[$_POST['Field']];

Dec 10 '10 #12

Xicer

New Member

Thank you for the information, i will try it out.

Dec 10 '10 #13

Similar topics

1520

Search Engine

by: vichet | last post by:

Hi All; Please help me with some problem i want VBSCRIPT to search something in only my own website give me code thank vichet

ASP / Active Server Pages

1462

search engine in php,mysql

by: sathyashrayan | last post by:

dear group, I have been working VC++ for some time. My company assigned me a task for an online dictionary search site similar to the onelook.com which I have to make it in php mysql. Since I never did any of the project in the search engine , can any one guide me to the above? I am really struggling to understand the following: When I enter a word in a text it searches the definition of the word from the web site but not the home page...

PHP

2493

Looking for a search engine that search a mysql database

by: Martien van Wanrooij | last post by:

I have been using phpdig in some websites but now I stored a lot of larger texts into a mysql database. In the phpdig search engine, when you entered a search word, the page where the search word was found was displayed with about 2 lines before and 2 lines behind the search word itself. Let us say you look for "peanut butter" an the word is found in a larger text about sandwiches, even when it is on the 40th line of the text you would get...

PHP

2656

Need advice on search engine

by: hazly | last post by:

I'm very new in the web technology and need advice on search engine. I want to develop a portal using PHP and MySQL on Linux. Need to know on the following features : 1. search engine that could search my portal (mySQL, PDF, Ms Word & others) 2. search engine that could search to few web sites specified by user/programmer

PHP

1021

C# Two-Column Dropdown List: Need help

by: JJ_377 | last post by:

I am trying to populate a two-column dropdown list from a populated datareader (dr) having two fields from the Categories table of the Northwind database: CategoryID and CategoryName. I've used this type of construction successfully with VB.NET (from which I am now transistioning...) and it has worked unfailingly with my dropdowns there. However, when I do this in C#, the result is only the CateogryID displaying in the dropdown. And...

C# / C Sharp

1280

Search Engine using PHP and Mysql

by: gaganlatha | last post by:

Hi, I want to create a search engine for my site. When i search a any keyword it should take me to that keyword. The keyword may be a country name, name, month etc. If this available in database it should take me there else if the keyword specified by the user is new it should store that keyword in database and when next time the user give that word it should display that result. Regards Latha

PHP

2052

Refresh individual Dynamic dropdown

by: d1156676 | last post by:

Hi I have a Dynamic dropdown reading in data from a MySql database, I need to refresh the dropdown when the database is updated without refreshing the whole page. I have had a go at trying to use a javascript and getelementbyid but with no sucess. Does any ones have any example or have any ideas on how i can do this. Any help will greatly appreciated

PHP

3571

Make long url search engine friendly by using fake folder in address bar

by: miraan | last post by:

Hi, I have searched on the internet but can't find a way to disguise a long ugly php url such as www.domain.com/companies.php?id=543 into this: www.domain.com/companyname the folder "companyname" shouldnt really exist. There should be some instructions in .htaccess or something like that (not sure) to show www.domain.com/companies.php?id=543 instead but still keep www.domain.com/companyname in the address bar. I dont want to actually create a...

Apache Web Server

1234

Need help with linking

by: nagendra802000 | last post by:

Hi All, I have created a search engine for MP3 with mysql database. Now I want to connect each search result with its respective info page which will consist with name of the artist, size, year, and so on. Dose anyone knows how to do it? I did created few static pages with all these info. But its impossible to create for thousands of MP3s. Please help me. Best,

PHP

8683

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9031

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8902

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6528

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5862

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4372

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3052

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2339

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2007

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General