_POST and form processing

j_70

1.
I have a form which has a list of events which have date fields pre-filled in. The user then selects (via a checkbox) several events and I print a confirmation. Since the date field are all populated, when the user hits submit, the StartDate[] and EndDate[] arrays have all the date fields, rather than the ones related to the users selection. How do I limit this.

2.
Based on the event, I call a report template and fill in name, event, dates etc. How do related the event arrays with the appropriate date arrays. This is all database driven so I do not always know the specific array element number, I need to loop through but make sure I have the correct date associated with the correct event.

This is how I create the arrays.

    while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
     $count=$count+1; 
     print '<tr>';
     print '<td class=" DataStrong">';
     print '<input name="event[]" type="checkbox" value="';
    print $row[9].'"'.'</td>'.'<td class="DataStrong">'.$row[9].'<td class="DataStrong">'.$row[8].'<td class="DataStrong">'.$row[1].'<td class="DataStrong">'.$row[0].'<td class="DataStrong"><input style="width: 80px" type="text" name="StartDate[]" value ="'.$row[10].'"'.'<td class="DataStrong"><input style="width: 80px" type="text" name="EndDate[]" value ="'.$row[11].'"';
    print '</td>';
    print '</tr>';

Blulagoon

Interesting to see someone else using Oracle with PHP.

Its not clear where the code snippet is from. It might be worth your while posting the whole form so we can see what you are trying to do and how you are filling in the dates and maybe we can suggest a way of doing what you want to do.

Blu

j_70

I've been using PHP and Oracle (OPAL) since we do not run MySQL and I like the flexibility PHP provides outside of the Oracle development tools. Here is the full code:

<html>
<head>
  <LINK REL=StyleSheet HREF="style.css" TYPE="text/css">
</head>

<body>
<?php
session_start();

$ID = $_POST['IdNum'];
$ap_year = $_POST['yeardropdown'];

$conn = ocilogon($_SESSION['user'],$_SESSION['password'], $_SESSION['db']);


if (!$conn) {
   $e = oci_error();
   print htmlentities($e['message']);
   exit;
  }
$query = "select a.id_num,corp_name,
         A.STRT1, A.CITY, A.ST, LPAD(A.zip1,5,0) ZIP, c.plan_cat, c.event_name,
         case
            when start_date > sysdate then to_char(c.start_date,'MM/DD/YYYY')
            else to_char(sysdate,'MM/DD/YYYY')
            end as start_date,
            to_char(c.end_date,'MM/DD/YYYY') end_date
         from vps1 a, VPS2 b, (select id_num,  b.event_name, b.start_date, b.end_date,
                                          tab_to_string(cast(collect(b.event||' '||cat) as t_varchar2_tab)) as cat, max(ap_num) ap_num
                                          from vps1 a, event_matrix b
                                          where date_canceled is null and ap_year=$ap_year
                                          and id_num=$ID
                                          and a.plan=b.plan
                                          ) c
         where b.AP_NUM = C.AP_NUM
         AND b.ap_num = a.ap_num
         and RANK = '1' and a.id_num = $ID
         and c.id_num=a.id_num"; 

$stid = oci_parse($conn, $query);
  if (!$stid) {
   $e = oci_error($conn);
   print htmlentities($e['message']);
   exit;
  }

  $r = oci_execute($stid, OCI_DEFAULT);
  if (!$r) {
   $e = oci_error($stid);
   echo htmlentities($e['message']);
   exit;
  }

oci_close($conn);


  print '<form method="POST" action="loa_test.php">';
  print '<table class="Table" cellspacing="1" cellpadding="5" rules="none"
     frame="void" border="9px" bordercolor="#000000"
     summary="Procedure Report: Detailed and/or summarized report">';

print '<tr>';
print '<TD BGCOLOR=#5F9EA0 width=180 height=550>';
print '</td>';
print '<td>';
print '<br>';
print '<br>';
print '<br>';
print '<br>';
print '<br>';
print '<table>';  

print '<colgroup>';
print '<col>';
print '<col>';
print '<col>';
print '<col>';
print '</colgroup>';
print '<tr>';
print '<th class=" header" scope="col">&nbsp;</th>';
print '<th class=" header" colspan="6" scope="colgroup"><b>LOA Eligibility</b></th>';
print '</tr>';
print '<tr>';
print '<th class=" header" scope="col"></th>';
print '<th class=" header" scope="col">event Name</th>';
print '<th class=" header" scope="col">Plan & Category</th>';
print '<th class=" header" scope="col">Name</th>';
print '<th class=" header" scope="col">ID<br>Number</th>';
print '<th class=" header" scope="col">Start<br>Date</th>';
print '<th class=" header" scope="col">End<br>Date</th>';
print '</tr>';
print '</thead>';
print '<tbody>';
$count = 0;
    while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
     $count=$count+1; 
     print '<tr>';
     print '<td class=" DataStrong">';
     print '<input name="id[]" type="checkbox" value="';
    print $row[9].'"'.'</td>'.'<td class="DataStrong">'.$row[9].'<td class="DataStrong">'.$row[8].'<td class="DataStrong">'.$row[1].'<td class="DataStrong">'.$row[0].'<td class="DataStrong"><input style="width: 80px" type="text" name="StartDate'.$count.'" value ="'.$row[10].'"'.'<td class="DataStrong"><input style="width: 80px" type="text" name="EndDate'.$count.'" value ="'.$row[11].'"';
    print '</td>';
    print '</tr>';

$_SESSION['corp_Name']=$row[3];
$_SESSION['Name']=$row[1];
$_SESSION['Street_Address']=$row[4];
$_SESSION['ID_Number']=$row[0];
$_SESSION['City']=$row[5];
$_SESSION['State']=$row[6];
$_SESSION['Zip']=$row[7];
$_SESSION['Plan'] = $row[10];
$_SESSION['event_Number']=$row[2];
$_SESSION['Category']=$row[11];
//$_SESSION['event']=$row[12];
}
$_SESSION['counter']=$count;
  print '<td>';
  print '</td>';
  print '<td>';
  print '</td>';
  print '<td class="DataStrong"><input type="submit" value="Submit"></td>';
  print '</body>';
  print '</table>';
?>
<tr>
</tr>
<tr>
<td>
</td>
</tr>
</form>
</table>
</html>

Blulagoon

My normal platform these days is Microsoft SQL server, but with Oracle XE being made available, well I had to take a look.

I think your problem is more with logic than code. I don't see much opportunity for user input other than IdNum and yeardropdown, and don't see any other $POST variables being used elsewhere, although you are setting some $SESSION variables further down the code with information drawn from the db.

Blu

j_70

The only input that the user has is for a checkbox. The ID[] array holds these. The problem that I am having is that for each ID[] value there is an associated StartDate[] and EndDate[]. On the next page (where I access the _POST array), I need to associate the two. I am having difficulty with the logic of how the two are associated. Here is the relavent code from the next page. Within the while loop, I need to reference the associated StartDate and EndDate:

foreach ($_POST['id'] as $k => $v)
{
print_r($_POST['StartDate']);    

$var[] = "'".$v."'"; //This build the where clause from the posted checkboxes.
}
$var = @implode(",", $var);


$query = "select distinct event_name,template,LLX,LLY,URX,URY from event_matrix where exemption_name in ($var)";

$stid = oci_parse($conn, $query);
  if (!$stid) {
   $e = oci_error($conn);
   print htmlentities($e['message']);
   exit;
  }

  $r = oci_execute($stid, OCI_DEFAULT);
  if (!$r) {
  $e = oci_error($stid);
   echo htmlentities($e['message']);
  exit;
  }

oci_close($conn);
    $p = new PDFlib();
    $p->set_parameter("errorpolicy", "return");
    $p->set_parameter("license", $license);
    $p->set_parameter("textformat", "bytes");
   if ($p->begin_document("", "") == 0) {
   die("Error: " . $p->get_errmsg());
   }
   $p->set_info("Title", "Event Registration");


while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {

$tf=0; $tbl=0;
$rowmax = 4; $colmax = 7;
$llx= $row[2]; $lly=$row[3]; $urx=$row[4]; $ury=$row[5];
   $stationery = $p->open_pdi($row[1], "", 0);
if ($stationery == 0){
die("Error: " . $p->get_errmsg());
}

$page = $p->open_pdi_page($stationery, 1, "");
if ($page == 0){
die("Error: " . $p->get_errmsg());
}

   $p->begin_page_ext(595, 842, "");
   $font = $p->load_font("Times", "unicode", "");
   if ($font == 0) {
   die("Error1: " . $p->get_errmsg());
   }
}