Redirect to a page after updating

anjuraju

Hi!
can anyone tell me how to redirect to a diff page after updating in the same page.I tried using header("http://thankyou.php")
but it is not working.If i place the thankyou.php in the "action=" in my form declaration statement,updating doesn't take place.How can I do this?

anjuraju

Shrike

You need to specify what type of header you are sending, in addition to the value of the header, for example:

header( 'Location: /thankyou.php' );
// same principle for other headers
// header( 'Content-type: text/html' );

anjuraju

No,it not redirecting to the next page.its still in the same page after updating.the problem persists.

anjuraju

Can someone post some ideas to help me out?If I redirect to the next page,my update query isn't working.

anjuraju

Shrike

Could you post the relevant parts of your code? It might make it easier to see where you are going wrong.

anjuraju

Here's my code:

<html><head><TITLE>display.php</TITLE></head>
<body bgcolor="#FFFFFF">
<h3><center><bold>Your Details</bold></center></h3>
<form name="display.php" method="POST" enctype="multipart/form-data" action="Thankyou.php>
<?
print "<br>";
$Ph=$POST['Mobile'];
$Em=$POST['Email'];
$Qu=$POST['Qualification'];
$Un=$POST['University'];
$Br=$POST['Branch'];
$Co=$POST['Course'];
$Av=$POST['Average'];
$Ex=$POST['ExamsPending'];
$myph=$Ph;
$myem=$Em;
$myqu=$Qu;
$myun=$Un;
$mybr=$Br;
$myco=$Co;
$myav=$Av;
$myex=$Ex;
$db="mydb";
$link=mysql_connect("localhost") or die("couldn't connect to Mysql");
mysql_select_db($db) or die("Select Error:".mysql_error());
$query="SELECT * FROM work";
$rt=mysql_query($query);
$appu=$GET['Reference'];
while($nt=mysql_fetch_array($rt)){
if($nt[ref]==$appu){
$id = $nt[id];
//echo "$nt[Name] $nt[Surname]<br> $nt[DOB]<br> $nt[PhoneNumber]<br> $nt[Email]<br> $nt[Qualification]<br> $nt[University]<br> $nt[Branch]<br> $nt[Course]<br> $nt[Average]<br> $nt[ExamsPending]<br>";
print "<b>Name:<br>
<input type=text name=Name value=$nt[Name] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Surname:<br>
<input type=text name=Surname value=$nt[Surname] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Date of Birth(dd/mm/yyyy):<br>
<input type=text name=DOB value=$nt[DOB] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Mobile:<br>
<input type=text name=Mobile value=$nt[PhoneNumber] size=20 maxlength=20></b><br>\n";
print "<b>Email:<br>
<input type=text name=Email value=$nt[Email] size=30 maxlength=30></b><br>\n";
print "<b>Qualification:<br>
<input type=text name=Qualification value=$nt[Qualification] size=10 maxlength=10></b><br>\n";
print "<b>University:<br>
<input type=text name=University value=$nt[University] size=20 maxlength=20></b><br>\n";
print "<b>Branch:<br>
<input type=text name=Branch value=$nt[Branch] size=30 maxlength=30></b><br>\n";
print "<b>Course:<br>
<input type=text name=Course value=$nt[Course] size=5 maxlength=5></b><br>\n";
print "<b>Average:<br>
<input type=text name=Average value=$nt[Average] size=2 maxlength=2></b><br>\n";
print "<b>ExamsPending:<br>
<input type=text name=ExamsPending value=$nt[ExamsPending] size=2 maxlength=2></b><br>\n";
?>
<b><font size="+1">Please attach your file here!</font></b><br>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="uploadedfile" type=file>
<?
print "<br>\n";
print "<input type =submit value=submit><br>\n";
$target_path="/var/www/html/uploads/";
if(move_uploaded_file($FILES['uploadedfile']['tmp_name'],$target_path.$_FILES['uploadedfile']['name'])){
print "Your file has been uploaded<br>\n";
}
}
}
$sql="update work set PhoneNumber = '$myph', Email = '$myem', Qualification = '$myqu', University = '$myun', Branch = '$mybr', Course = '$myco', Average = '$myav', ExamsPending = '$myex' where id = $id";
mysql_query($sql);
mysql_close($link);
?>
</form>
</body>
</html>

anjuraju

inazrabuu

As far as I can remember, if you want to redirecting page using php, there cannot be output before the redirection take place, maybe previously you wrote the 'header' part after you had give some output to the browser. Try to write the header before you give some output to the browser (so the updating process can take place before you write some output).
Hope this would help..

Cheers
But btw, where did you previously put the 'header' part, was it after you wrote the update query ?

gle4

Hi! inazrabuu,

this is the way i currently use and i think it will be useful to you.

i put this code at the top of the page.

<?php
function gotosearch($strletter,$strstart,$strsortorder){
header("Location: customersearch.php?letter=$strletter&start=$strstart&sortorder=$strsortorder",true); exit;
}
?>

and put this code after update code.

$ibol=gotosearch($curletter,$curpage,"asc");

gle4

Hi! anjuraju,

this is the way i currently use and i think it will be useful to you.

i put this code at the top of the page.

<?php
function gotosearch($strletter,$strstart,$strsortorder){
header("Location: customersearch.php?letter=$strletter&start=$strstart&sortorder=$strsortorder",true); exit;
}
?>

and put this code after update code.

$ibol=gotosearch($curletter,$curpage,"asc");