hi everybody... i ran across the site and found TONS of information about what i want to do.... but i don't know what to take for my need.
here is what i want to do... a search engine for my website through the database.
you can see what i have done for now at this url http://www.scale24-25.com/kitDB-site.php
this is the code
like you can see in my submit button i put a result.php file
it's this file i want to make but i'm stuck... really don't know how to make.
in fact you can make only 1 selection and press submit ex: you select the 1/24 scale and press submit it will return ALL kit in 1/24. If you select tamiya and honda it will return every kit honda made by tamiya etc...
also i want to see the kit number, the picture, year of production and of course the picture associate to this kit.
see below my field title of my database
kit_id = the ID of the kit 0, 1 , 2 ... auto increment
kit_number
description
manufacturer_ki t
manufacturer_re el
engine_detail
year_prod_kit
year_prod_reel
type
scale
image_id
so any help will be granted.
thank's in advance
sebastien
Aug 24 '09
21 3174 Dormilich 8,658
Recognized Expert Moderator Expert @scaleautostyle
well, well, my dear pupil… ;)
this is indeed not an easy decision to make (for I’m not an SQL expert).
I guess you have to construct the SQL string according to the options on which you refine (you could in theory fetch all IDs which match each option separately and only use these that occur in every result set, but this is not good if you have huge data sets).
… looks like a reasonable way to go.
of course you should read CodeIgniter’s MySQL section (if you use CI). this should clear the matter, how you connect & query (mostly)
connecting to the database is not a problem. i don't understand how i can get the result. if you or somebody put a simple code on how to do base on my need.. ( with my field and file) it will be appreciate
ex: if someone click on the 1/24 from the scale drop down and click submit. what's the code need to return all the 1/24 found in the table kit field scale.
if he select tamiya from the manufacturer kit dropdown and honda from the reel manufacturer dropdown and then click the submit button.. what will be the code to return the info from the table kit field manufacturer_ki t and manufacturer_re el.
all my code can be found in the post above. base on this file what i have to change to work. may be i have to change some variable or other things. i read, read, and RE-read. but it look like if i ask you to read an instruction in chinese. you will read 100 time but never understand. except if i gave a traduction of a small text you will be able to compare the instruction with my text and so..
i hope someone can help me i really need an answer for my problem
yours and thank's in adavance for your help
sebastien
Dormilich 8,658
Recognized Expert Moderator Expert @scaleautostyle
my problem here is, that I don’t know the CI mysql syntax. @scaleautostyle - -- as a prepared statement
-
SELECT `kit_id` FROM table_name WHERE `scale` = ?
then you can use another prepared statement to fetch all the data - -- SQL
-
SELECT * FROM table_name WHERE `kit_id` = ?
-
-
# PHP
-
foreach ($id_array as $id)
-
{
-
// pseudo code, use CI’s syntax instead
-
$pdos->execute(array(1 => $id))
-
printResult($pdos->fetch());
-
}
@scaleautostyle - -- as a prepared statement
-
-- get 20 results from offset
-
SELECT `kit_id` FROM table_name WHERE `manufacturer_kit` = ? AND `manufacturer_reel` = ? LIMIT ?,20
-
-
# PHP (again, mostly pseudo code)
-
$pdos->execute(array(1 => "tamiya", 2 => "honda", 3 => 0));
-
$id_array = $pdos->fetchAll();
the output code is the same as above
still get the #$#%$% problem this is the link of the page http://www.scale24-25.com/kitDB-site.php
for this page NO PROBLEM.. here it is... when you clic on the go button it supposed to return what the user select in the field. ex: you choose 1/24 and honda. a query will search the database under the column scale to find every 1/24 and under the constructor name to find all honda and them display the result.
this query have to be made in a separate files name kitDB-result.php.
but i REALY don't know what the query need to be.
if you can gave me an exemple of the query using my data it will be appreciate
yours
sebastien
PS: use this.
database name: sebastien
username: SAS
password: resinkit
sale column = scale
kit manufacturer = kit_manufacture r
engine = engine
thanks in advance
Frinavale 9,735
Recognized Expert Moderator Expert
Did you try the SQL statement that Dormilich suggested?
It looks "right" to me too, mind you I'm not a SQL expert...
Whenever I get stuck on SQL stuff I turn to my trusty database book or the w3cschools site. The W3CSchools site has examples on the Select Statement and the Where Clause that may help you get an idea of what you need to do....
RedSon 5,000
Recognized Expert Expert
SELECT `kit_id` FROM table_name WHERE `manufacturer_k it` = ? AND `manufacturer_r eel` = ?
This is a simple select statement. It should work no problem. Be aware however that you need to replace the ? with actual data. If that select gets the data you want then you can start to LIMIT the output and order it and do all sorts of fancy things. Just get the basic SQL down first.
The only problem is that you are selecting only one field of data "kit_id" if you want everything from the whole table "table_name " you would change kit_id to *.
@RedSon
ok but how I can replace the ? by the selection of the user....
thanks in advance
sebastien
TheServant 1,168
Recognized Expert Top Contributor - mysql_query( "
-
SELECT kit_id
-
FROM table_name
-
WHERE manufacturer_kit='$manufacturer_kit' AND manufacturer_reel='$manufacturer_reel'
-
LIMIT 1
-
" );
Obviously you will need to define your $manufacturer_k it and $manufacturer_r eel variables. I made a string using " so that php variable can be included, and then I wrapped the variables in ' so that MySQL is happy. You could also have a multipart string, but that is easier. I also added a LIMIT 1, so that only one record is returned, and it stops searching after it gets that one. Look it up if you haven't used it before.
Dormilich 8,658
Recognized Expert Moderator Expert @RedSon
You’ve got the intention wrong. this is not a simple SELECT statement to display the results, it is a SELECT statement for use as Prepared Statement. the "?" will be replaced in the execute() call. further this statement only fetches the kit_id, because for the result display, there will be used another Prepared Statement, which uses the selected IDs to get the complete data.
Dormilich 8,658
Recognized Expert Moderator Expert @scaleautostyle - $PDOStatement->execute(array(1 => "tamiya", 2 => "honda"));
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: minchu |
last post by:
Hello,
I have used CSS in HTML page (font-verdana size-8pt), looks fine in
windows but in linux the fonts are corrupt and its too small. Kindly
help me and tell what is the solution to correct this.
www.teledna.com
Regards,
Minchu
|
by: Alec |
last post by:
First attempt at doing an exercise on paginating result sets
When I run the code, I receive the error "Fatal error: Call to
undefined function: mysql_fetch_objects() in
/homepages/17/d23395818/htdocs/en/test.php on line 48"
Line 48 is while($row = mysql_fetch_objects($result)) Any ideas?? Have
I missed an obvious mistake. (full code below)
Many thanks
|
by: assgar |
last post by:
Hi
Developemnt on win2003 server. Final server will be linux
Apache,Mysql and PHP is being used.
I use 2 scripts(form and process).
The form displays multiple dynamic rows with chechboxs, input box for units of service, description of the service and each row has its own dropdown list of unit fees that apply.
Each dynamically created row will return 3 values fee1_choice, fee1_unit and fee1_money.
Note The above informaton is...
|
by: peridian |
last post by:
Hi,
I wanted a web page where I could post code to, and have it appear in coloured formatting based on the context of the code.
Most of the techniques I have seen for this involve complex use of string manipulation where they seek through the string back and forth doing replacements to substitute in the needed HTML code.
I am convinced that this can be done with a few regular expressions. Unfortunately my knowledge of regular...
|
by: assgar |
last post by:
Hi
Multiple rows of dynamically created data is retrived from the database and displayed properly.
When I get 50 rows displayed scrolling is necessary.
The problem is when I scroll to see the items at the bottom of the list the rows get blurred (jumbled).
To be specific at the top and bottom rows of the list are displayed properly but in the middle the rows get blurred.
Can you you see something wrong with my code? How can I make...
| |
by: WiseG1rly |
last post by:
Hey everyone!
I am completley new and I will start off by saying that I am not a programmer - figuring out this search took so long! I am debugging now and would appreciate any help :)
Anyways, I am creating a website where I have a database of pet listings in california. Each record lists the Type of Listing (eg. dog grooming or vet) the the Area it is in (so state, county etc.), a Name, Description, and Address.
I created a search...
|
by: jasone |
last post by:
Hi all, ive got a search function running on a database, the action performed by the form is shown below, within the 'else' statement i would like to show roughly 5 random rows from the sql table (alternative products) if you like.
please find below the script im currently running for the search, the else statment just shows 'no results found' message at the moment.
many thanks in advance for any who can help:
<table width="40%"...
|
by: howzy |
last post by:
Hello I am new to the database world and Ive learned how to do a few things storing text is easy. i found that out but trying to get an image to show up on a page is difficult and i cant seem to find the correct way to call it up in php so it will display..What i am trying to do is build a search engine for a furniture companys rug collection...so that the rug type style size and an image next to that will show up...
this is my php code...
|
by: agarwalsrushti |
last post by:
Hi,
Im just stuck up with a small query. In my database ive a table called specialization which is dependent on qualification. In specialization i ve 3 fields: QualificationId, SpecializationId,SpecializtionArea. in specialization table there are SpecializationArea with same name but with diferent SpecializationId and QualificationId. Now when i enter search page and select to search based on specialization then it doesnt displays the results...
|
by: angelicdevil |
last post by:
i have listbox 1 which displays status , based on selection of status listbox 2 displays usernames. and based on username selected the textbox displays the email id.
its working fine till displaying user names in listbox 2 based on selected of status in listbox. but its not displaying the emailid based on selection of usernames and when i click on search for users button its refreshs the page and shows the intial page also want the text box...
|
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...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
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,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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();...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |