Query to Form to Query

[murpe]

Hi all. I was wondering if the following is possible under php:

1) User inputs information into form1 and submits it (query.php)
2) query.php passes database query returns to 'form2'.
3) One field on 'form2' can be selected and a new query is run and data presented.

And so on (this meaning that other information queried can also be selected as well).

Here is the visual layout:
User wants to see information for a certain date. User enters date and presses 'submit'. Database is queried for the data and a listing of id number records is returned. User than then select (url link) one of the records (in this case by id number). A new form is created with the id number as the key and displays all other record information under this one id (i.e. customer name, address, etc etc).

Is this possible and how many background forms (pages) are we talking about here outside that of the query.php?

-- M

[bastien]

need 2 pages

1. the query page
   -allows user to enter date (use drop downs for consistency)
   -searches the db to collect the data
   -shows the data as links

 //main code block
 if (!$_POST['submit']){

      //function call to show date form
      show_date_form();

 }else{

      //function call to run_query
      run_query();

 }

2. forms page for editing data
   -shows form with data in it ready for editing
   -on submit runs query to update changes.

   
        //main code block
        if (!$_POST['submit']){
   
     //function call to show date form
     show_form();
   
        }else{
   
         //function call to run_query
         run_update();
   
    }
     

[murpe]

From what I just saw above, it really doesn't do much for me.

What is in those functions I am calling? Have any working examples or sites with examples of this type of layout?

-- M

[murpe]

Well, I have broken down the script and utilizing actions as the pointers, running a query and then displaying the results in table format. The retrieve action works correctly, querying the data base by the inputted date from the queryform.html.

Several columns and rows are produced when activated: PON DTSENT PROVISIONER PROVNAME

The issue is when the output is produced in table format, how do I create only on the first column of the table for each record id found a url link and pass the record id (in this case 'PON') number found? Only PON should have a link to re-query the database, and then return all information about this PON only in table format as well.

Example 1: (Retrieve Query)

Date: 06-JUN-03
PON DTSENT PROVISIONER PROVNAME
0000002270551002 06-JUN-03 mspriss Miss Priss

A table (similar to above) would be displayed with the url of 0000002270551002 available to be selected for information data retrieval.

Example 2: (PON Query)
Would return all information found in the database for the PON number only, no matter how old the records were and display them in table format.

<?php

putenv("ORACLE_SID=test");
$username = "test";
$passwd = "test";
$db="(DESCRIPTION = 
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) 
   (CONNECT_DATA = (SID = test)) 
)";

$conn = OCILogon($username,$passwd,$db);

if (!$conn) {
   echo "Connection failed";
   echo "Error Message: [" . OCIError($conn) . "]";
   exit;
}
else 
{
   echo "Connected to Database!\n\n";
}

$action = $_REQUEST['action'];

if ($action == '') { $action = "retrieve"; }

if ($action == 'retrieve') {

$date = $_POST['date'];

$stmt = OCIParse($conn, "select * from ASR_REPORT_EXTRACT where DTSENT = '$date'");

OCIExecute($stmt);

$nrows = OCIFetchStatement($stmt,$results);
if ( $nrows > 0 ) {
   print "<TABLE BORDER=\"1\">\n";
   print "<TR>\n";
   while ( list( $key, $val ) = each( $results ) ) {
      print "<TH>$key</TH>\n";
   }
   print "</TR>\n";

   for ( $i = 0; $i < $nrows; $i++ ) {
      reset($results);
      print "<TR>\n";
      while ( $column = each($results) ) {   

         $data = $column['value'];
         print "<TD>$data[$i]</TD>\n";
      }
      print "</TR>\n";
   }
   print "</TABLE>\n";
} else {
   echo "No data found<BR>\n";
}      

print "$nrows Records Selected<BR>\n";

OCIFreeStatement($stmt);
OCILogoff($conn);
}


// Query Database for PON Number information & return all results

if ($action == 'pon') {

$ponid = $_POST['ponid'];

$stmt = OCIParse($conn, "select * from ASR_REPORT_EXTRACT where PON = '$ponid'");

OCIExecute($stmt);

$nrows = OCIFetchStatement($stmt,$results);
if ( $nrows > 0 ) {
   print "<TABLE BORDER=\"1\">\n";
   print "<TR>\n";
   while ( list( $key, $val ) = each( $results ) ) {
      print "<TH>$key</TH>\n";
   }
   print "</TR>\n";

   for ( $i = 0; $i < $nrows; $i++ ) {
      reset($results);
      print "<TR>\n";
      while ( $column = each($results) ) {   

         $data = $column['value'];
         print "<TD>$data[$i]</TD>\n";
      }
      print "</TR>\n";
   }
   print "</TABLE>\n";
} else {
   echo "No data found<BR>\n";
}      

print "$nrows Records Selected<BR>\n";

OCIFreeStatement($stmt);
OCILogoff($conn);
}

?>