I am trying to link to a new form can anyone help me with syntax please?
I'm guessing there has to be a POST somewhere here??
I don't want to use a button I just want the link to go to the next page of the form so kind of a submit when clicked. (JS onclick? - not sure of the syntax)
I'm guessing there has to be a POST somewhere here??
I don't want to use a button I just want the link to go to the next page of the form so kind of a submit when clicked. (JS onclick? - not sure of the syntax)
$link_address = 'https://xyz.gov.uk/LFT/?chronoform=Change_Pharmacy_Main_Form&gpage=Main_Form';The code above just keeps me on the form I am already on.
oci_execute($stid);
while (($emp = oci_fetch_array($stid, OCI_BOTH)) != false) {
echo "<tr>";
echo "<td>"."<a href=$link_address&ref=".$emp['REFERENCE'].">".$emp['REFERENCE']."</a>"."</td>";
As an addition to the above here's a pic of what I am trying to do.
1. User enters reference number if that data is more than 5 days old show an error and return to the submission form.
2. User clicks one of the reference links (these are filtered less than 5 days old) - Why have both? Requirement spec! The link then takes the user off to the main form where the data is displayed and can be edited.

after either the lookup or the link the form then goes to the edit section of the form. Here is where I need a redirect back if the data is more than 5 days old code below
Can anyone please help me sort this out?
1. User enters reference number if that data is more than 5 days old show an error and return to the submission form.
2. User clicks one of the reference links (these are filtered less than 5 days old) - Why have both? Requirement spec! The link then takes the user off to the main form where the data is displayed and can be edited.
$conn = oci_connect($username, $password, $servername);The code above is the submit part of the form. Here is where I can't get the link type submission working.
if (!$conn) {
$e = oci_error();
echo(htmlentities($e['message'], ENT_QUOTES));
echo "<br>";
}
$stmt = "SELECT REFERENCE, SITEID, SITENAME, WHATISYOURNAME, DATERECORDED, NUMBEROFPOSITIVELFTTESTS, NUMBEROFVOIDLFTTESTS, NUMBEROFNEGATIVELFTTESTS, NUMBEROFPHARMACYSITESOPERATION
FROM $table
WHERE SITEID = 'PCR1'";
$stid = oci_parse($conn, $stmt);
echo '<table border = 1>';
echo "<tr><th style=width:20%>REFERENCE</th><th style=width:5%>SITEID</th><th style=width:12%>SITE NAME</th><th style=width:18%>DATE RECORDED</th><th>RECORDED BY</th></tr>";
$link_address = 'https://xxxx.gov.uk/LFT/?chronoform=Change_Pharmacy_Main_Form&gpage=Main_Form';
oci_execute($stid);
while (($emp = oci_fetch_array($stid, OCI_BOTH)) != false) {
$CheckDate = $emp['DATERECORDED'];
$mydate = date_create($CheckDate)->format('d-M-y');
//echo 'My Date - ',$mydate.'<br>';
$threshold = date('Y-m-d', strtotime("-5 days"));
$threshold = date_create($threshold)->format('d-M-y');
//echo 'Threshold - ',$threshold.'<br>';
$value = $threshold - $mydate;
//echo 'Value - ',$value.'<br>';
If ($value < '-5' || $value > '0') {
echo "<tr>";
//echo 'This data is greater than 5 days old!';
}
else{
echo "<tr>";
echo "<td>"."<a href=$link_address&ref=".$emp['REFERENCE'].">".$emp['REFERENCE']."</a>"."</td>";
$this->set("OracleReference", $emp['REFERENCE']);
echo "<td>".$emp['SITEID']."</td>";
$this->set("OracleSiteID", $emp['SITEID']);
echo "<td>".$emp['SITENAME']."</td>";
$this->set("OracleSiteName", $emp['SITENAME']);
echo "<td>".$emp['DATERECORDED']."</td>";
$this->set("OracleDateRecorded", $emp['DATERECORDED']);
echo "<td>".$emp['WHATISYOURNAME']."</td>";
//echo "<td>".$emp['NUMBEROFPOSITIVELFTTESTS']."</td>";
//echo "<td>".$emp['NUMBEROFVOIDLFTTESTS']."</td>";
//echo "<td>".$emp['NUMBEROFNEGATIVELFTTESTS']."</td>";
//echo "<td>".$emp['NUMBEROFPEOPLETESTED']."</td>";
//echo "<td>".$emp['NUMBEROFPHARMACYSITESOPERATION']."</td>";
echo "</tr>";
}
}
echo "</table>";
?>
after either the lookup or the link the form then goes to the edit section of the form. Here is where I need a redirect back if the data is more than 5 days old code below
$stid = oci_parse($conn, $stmt);
oci_execute($stid);
while (($emp = oci_fetch_array($stid, OCI_BOTH)) != false) {
// Is the data more than 5 days old?
$CheckDate = $emp['DATERECORDED'];
//echo 'Date Recorded - ', $CheckDate.'<br>';
$mydate = date_create($CheckDate)->format('d-M-y');
//echo 'My Date - ',$mydate.'<br>';
$threshold = date('Y-m-d', strtotime("-5 days"));
$threshold = date_create($threshold)->format('d-M-y');
//echo 'Threshold - ', $threshold.'<br>';
$value = $threshold - $mydate;
echo 'Value - ',$value.'<br>';
If ($value < '-5' || $value > '0') {
echo 'This data is more than 5 days old'.'<br>'; //Maybe pass a var back to the submission part to show an error??
header( "Location: ?chronoform=Change_Pharmacy_Main_Form&gpage=Main_Form");// results in too many redirects error!!
}
else {
$this->set("OracleReference", $emp['REFERENCE']);
$this->set("OracleSiteID", $emp['SITEID']);
$this->set("OracleSiteName", $emp['SITENAME']);
$this->set("OracleWhatIsYourName", $emp['WHATISYOURNAME']);
$this->set("OracleDateRecorded", $emp['DATERECORDED']);
$this->set("OracleNumberPositive", $emp['NUMBEROFPOSITIVELFTTESTS']);
$this->set("OracleNumberVoid", $emp['NUMBEROFVOIDLFTTESTS']);
$this->set("OracleNumberNegative", $emp['NUMBEROFNEGATIVELFTTESTS']);
$this->set("OracleNumberInOperation", $emp['NUMBEROFPHARMACYSITESOPERATION']);
}
}
Can anyone please help me sort this out?
You need to login to be able to post a reply.