Other Software > Developer's Corner

PHP Database help.

(1/2) > >>

Davidtheo:
I am trying to create a php page that has 2 drop down lists and a search box, the drop down list are filled via database.

for exmlpe My database can be something like.

Table 1
Subject ID
Subject

Table 2
Subject ID
paper ID
Paper

Table 3
Subject ID
Paper ID
Title
Des

Drop down box 1 will be filled from Table 1 (subject)
Drop down box 2 is filled from Table 2 based on what subject is selected in Drop down box 1
when a search word is entered into the search box then table 3 is searched based on the search box and what is selected in down down boxes 1 and 2
the search result is displayed in a different page as links, the link when clicked  displays the Full record that is in table 3.

Can someone please tell me how to or help me do this?

Thanks

Davidtheo:
ok It looks this this can't be done in PHP so I am now looking at ASPX, can anyone help he with this?

housetier:
How far did you look until you came to that conclusion?

Davidtheo:
How far did you look until you came to that conclusion?
-housetier (May 13, 2009, 03:10 PM)
--- End quote ---

I have spend two days four days before posting this topic and an other two day after posting it just trying to find out this first part.

"Drop down box 1 will be filled from Table 1 (subject)
Drop down box 2 is filled from Table 2 based on what subject is selected in Drop down box 1"

Note: I am trying to do this first part on one page.

I have already found a way I can do this with ASPX using updatepanel but I have not coded it yet, as I am now trying to work out now to connect ASPX using C# to a database. This is proving to be harder in C# and ASPX.

Kirth:
ok It looks this this can't be done in PHP so I am now looking at ASPX, can anyone help he with this?
-Davidtheo (May 13, 2009, 12:00 AM)
--- End quote ---

Lies and falsehood.  You'd be using AJAX for this -- which includes PHP & JavaScript.  Honestly, if there'se something you cán do with ASP(x), then you can count on the fact that you can do it with PHP also.

Navigation

[0] Message Index

[#] Next page