Quote:
<?php
$shg=$_POST[shg_name];
$mem_name=$_POST[member_name];
$mem_desig=$_POST[member_desig];
$mem_sal=$_POST[member_salary];
$mem_doj=$_POST[mem_join_date]."-".$_POST[mem_join_month]."-".$_POST[mem_join_year];
//print $shg."-".$mem_name."-".$mem_desig."-".$mem_sal."-".$mem_doj;
$temp=explode('-',$shg);
$shg_name=$temp[0];
$district=$temp[1];
//echo "<br> ->".$shg_name."<-";
$db_conn = new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./shg.mdb").";";
$db_conn->open($connstr);
$rS = $db_conn->execute("insert into shg_member (shg,district,mem_name,mem_desig,mem_sal,mem_doj) values ('$shg_name','$district','$mem_name','$mem_desig',$mem_sal,'$mem_doj');");
$rS->Close();
$db_conn->Close();
$url = "shg_members.php"; // target of the redirect
$delay = "0";
echo '<meta http-equiv="refresh" content="'.$delay.';url='.$url.'">';
?>
|
This is a php code which inserts a record, the last three lines is used to redirect back to the form which calls this script, basically i am trying to create a kind of looping , where the user keeps entering the details.
Now the record gets inserted , but its not getting re-directed to the form shg_members.php
I hope u can understand my problem.
Regards
JayaKrishnan