0

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
invoice.php

<form method="post" name="form">
<h1>Enter your Invoice No.</h1>
<table>
<tr>
<td>Invoice No. :</td><td><input name="invoiceno" type="text" size"25"></input></td>
</tr>
</table>
<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>

</FORM>

displaydata.php

<?php
$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());

$invoiceno=$_POST['invoiceno'];

$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

2
Contributors
4
Replies
5
Views
5 Years
Discussion Span
Last Post by gopi17
0

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)?

0

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

0

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.

0

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

displaydata.php

$invoice_no=$row['invoice_no'];
$document_no=$row['document_no'];
$no_pallets=$row['no_pallets'];

$_SESSION['invoice_no']=$invoice_no;
$_SESSION['document_no']=$document_no;
$_SESSION['no_pallets']=$no_pallets;

called in a different form

scan.php

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.