Guys, need some help regarding this issue, i have a php file, which requests an invoice_no(invoice.php), then searches the database and returns the other value associated to it(eg,document_no,PO_no) to another php file(displaydata.php). Now the problem is, i wanna send the invoice_no not only to displaydata.php but to another file test.php.

This is what i did so far

<form method="post" name="form">
<h1>Enter your Invoice No.</h1>
<td>Invoice No. :</td><td><input name="invoiceno" type="text" size"25"></input></td>
<input type="submit" name="submit" value="Submit" onclick="form.action='displaydata.php';"></input>
<input type="submit" name="submit" value="Back" onclick="form.action='main_login.php';"></input>



$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="testing"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die(mysql_error());


$sql="SELECT * FROM $tbl_name WHERE invoice_no = '$invoiceno'";
$result = mysql_query($sql);

$row = mysql_fetch_array($result) or die(mysql_error());

echo "Invoice:      ".$row['invoice_no'] . "<br>"; 
echo "Document No.:      ".$row['document_no']. "<br>"; 
echo "Number of Pallets: ".$row['no_pallets']. "<br>"; 
echo "Container No.: ".$row['container_no']. "<br>"; 
echo "Part No.: ".$row['part_no']. "<br>"; 
echo "Supplier Part No.: ".$row['spart_no']. "<br>"; 
echo "PO No.: ".$row['po_no']. "<br>"; 
echo "Status: ".$row['ship_status']. "<br>"; 


thank u in advance

6 Years
Discussion Span
Last Post by gopi17

Hi gopi17,

could you not send the form data to test.php first, have that page do whatever it needs to, then send the data to displaydata.php (in the URL using $_GET or as session data using $_SESSION)?


hmm...the thing is i'm not doing anything to the data, in displaydata.php...just comparing and displaying anything attached to it...i'll try with the session thingy...thanks


if the display.php page is just what you pasted above, maybe you could just add the display code to the bottom of test.php, or include("display.php"); in test.php? That way you don't need to send the form data to more that 1 place.


okay...somehow i manage to solve the problem...




called in a different form


echo "Invoice number :" .$_SESSION['invoice_no']."<br>";
echo "Document No. :" .$_SESSION['document_no']."<br>";
echo "Number of Pallets.:" .$_SESSION['no_pallets']."<br>";

regarding the submit button...

<form method="post" name="form">
<input type="submit" name="submit" value="Back" onclick="form.action='main_login.php';"></input>
<input type="submit" name="submit" value="Submit" onclick="form.action='displaydata.php';"></input>
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.