PHP &amp; MySQL

PHP & MySQL

Nickosssss

Lets say i have a "text field" in ONE file (first.php) named as "text1".

How can i save the data inserted on "text1" in order to examine if this data exists on my database and then display it on another php file (second.php)????

I have used redirection (header) to jump from first.php to second.php

So far, i have managed to check if "text1" string exists on my database and then from first.php i jump to second.php

BUT, when i want to display the "text1" on the second.php page does not display anything because it seems that it does not take the value of "text1" from the first php.

thank you

if it seems complicated please contact me so i can send the file or explain better.

Sxooter

That's because of the header function, which will override whatever else the page is trying to do, like passing variables.

Generally it's better to use some form of form submission to move from page to the next.

But in this case, WHY are you using two pages? You should be able to do this pretty handily on one.

Nickosssss

oh so when u use the header then the value is erased.....well once the user's password is verified i want the second.php to display

Welcome and the first name and last name of the user from the database

Nickosssss

how can i jump from one php page to another php page without the header?

Sxooter

Are you gathering this information with a form? If so, then just set the form tag's action field to the URL you want to go to.

Nickosssss

well yes i know that but the issue is that i have
radio button in the file and the user need to be directed to the right php file according to the choice....

is there any other way to redirect to other php files where there is a choice that needs to be made

look at this code if u have time:

<?php

if (isset($POST['submit']))
{
header('location: ' . $POST['url']);
exit();
}

require ('main.php');

$page = new homePage();
$page -> content = ' Please Choose one of the following options ';
$page -> Display();

	<form action="" method="POST"> 
		<div style = "width:15em; font-size:22; position:relative; top:-5%; left:33%	">
			<fieldset><legend> Please Choose: </legend><br>
				<input type="radio" name="url" value="stud.php">Students<br><br>
				<input type="radio" name="url" value="super.php">Supervisors<br><br>
				<input type="radio" name="url" value="admin.php">Administrator<br><br> 
				<input class = "button" type="submit" name="submit" value="submit"> 
			</fieldset>
		</div>
	</form>

<?php

$page -> Display2();

thank u

Sxooter

Originally posted by Nickosssss
well yes i know that but the issue is that i have
radio button in the file and the user need to be directed to the right php file according to the choice....

is there any other way to redirect to other php files where there is a choice that needs to be made

OK, the problem here is you're kinda going about it the wrong way. If you want to go from one page to the next and take data with you, you need to do it by submitting a form, not using header (location) type stuff. Otherwise you're just doing "get" method instead of "post", which, I assume, is what you want.

Get method allows to user to bookmark a page to return later. For a page with data that's a live edit, this is a bad thing.

What you want to do is either put your processing logic in one page and make the decision how to branch there, or put an intermediate page with a javascript onload=document.formname.submit() in it, with hidden variables stuck in it to get to the next page. A pain.

Is there a solid reason why you can't just abstract out the logic to process and include the proper logic file based on the radio button later?