link with db query

rltamm

I would like to create a function where a link is accessed if information on DB is there.

example..

LINK > if
user
zipcode

are correct

then open link A
if no then open link B

hope this is understandable..

CoursesWeb

Hi,
You can use the header() function to open the url you want.
Something like this:

if(condition_true) header('Location: address_1');
else header('Location: address_2');

bradgrafelman

CoursesWeb;11014037 wrote:
Hi,
You can use the header() function to open the url you want.
Something like this:
if(condition_true) header('Location: address_1');
else header('Location: address_2');

That's the gist of automatically redirecting the user's browser to a new location, aye... as long as we assume that a) no output has been generated before the header() call, and b) 'address_1' and 'address_2' in your code snippet refer to full URIs (e.g. they begin with a protocol, such as "http://").

However, it sounded more like the OP was wanting to output hyperlinks rather than automatically redirecting the user's browser. Granted, the post was a bit ambiguous and/or confusing.

rltamm;11014011 wrote:
I would like to create a function...

Sounds fascinating; let us know if you get stuck and have any specific questions.

rltamm

Sorry if this was confusing.. i am unsure how to explain it.

lets go detailed.

I have a script that runs testing for my sebsite

I have a list of tests for a specific course.

LINK A = Test 1
LINK B = Test 2
Link C = Test 3
Link 4 = Final Exam

Now... when a user takes test one. the script stores information for the user and myself on the database (mySQL) examples. results, number right, pass,fail, etc..

What I need to do and this is my initial issue.

I don't want the user to be able to take the final exam without first taking tests 1 2 and 3

i need to create a way to access information from the database to allow the user to use the link only if the above tests were completed

hope this makes sense now

Ashley_Sheridan

Makes sense now, yes. So how far have you got with your code already?

laserlight

rltamm wrote:
I don't want the user to be able to take the final exam without first taking tests 1 2 and 3

i need to create a way to access information from the database to allow the user to use the link only if the above tests were completed

Rather, you need to determine if the pre-requisites for the exam have been satisfied. Based on that condition, you can decide to show the link, or do other things.

Is it the case that only exams will have pre-requisites, i.e., the tests will not? Can different exams require the same tests? The appropriate solution can be simple, e.g., each test has a foreign key to the exam that it is a pre-requisite of, or it could be complicated, e.g., A Model to Represent Directed Acyclic Graphs (DAG) on SQL Databases, depending on your requirements.