I am in the process of completing a php program. The issue i am having is getting the data to display on a page after submission so that the data can be printed and handed to the customers.
My current code is

if(isset($_POST['name'])) {
    $date = $_POST['date'];
    $name = $_POST['name'];
    $address = $_POST['address'];
    $tel = $_POST['telephone'];
    $cell = $_POST['cellphone'];
    $email = $_POST['email'];
    $equip = $_POST['equipment'];
    $manu = $_POST['manufacturer'];
    $model = $_POST['model'];
    $pri = $_POST['priority'];
    $notes = $_POST['notes'];

<table width="601" border="1" cellpadding="2">
    <td width="181"><?php echo $msg; ?></td>
    <td width="82">Priority:</td>
    <td><?php echo $msg; ?></td>
    <td width="140">Customer Name:</td>
    <td colspan="2"><?php echo $name; ?></td>
    <td width="162">&nbsp;</td>
    <td><?php echo $email; ?></td>

<div id="disc">

<p> <button type="button" onclick="window.print();" >Print</button> | <a href="customer_device.html.php"><button type="button">Add New</button></a> </p>

This is code from the submission page

$q = "INSERT INTO customer (custid, date, custName, address1, address2, phone, cellphone, email, equipment, manufacturer, model, serial, imei, notes, priority) VALUES (' ', '$cd', '$cn','$ad1','$ad2','$p','$cp','$e', '$ty', '$mn', '$mo', '$sn', '$in', '$n', '$pr')";      
        $result = @mysqli_query ($dbcon, $q); // Run the query.
        if ($result) { // If it ran OK.
        header ("location: customer_device_print.html.php"); 

Any help would be really appreciated.

3 Years
Discussion Span
Last Post by itisnot_me

on your submission script, instead of

if ($result) { // If it ran OK.
        header ("location: customer_device_print.html.php"); 

you could use

           echo '<script type="text/javascript">
window.location = "customer_device_print.html.php?cell='.$cell; echo '"

and then on customer_device_print.html.php use $cell = $_GET['cell']; then you can then run a mysql query to pull the data relevant to that cell number and echo the data throughout the page.


$cell = $_GET['cell'];
$data = mysql_query("SELECT * FROM customer  WHERE cell='$cell' ") 
or die(mysql_error()); 
 while($info = mysql_fetch_array( $data ))

{ ?>

your page here 

<? } ?>

So I take it your redirect works alright, so all you need to do is:

$sql = "SELECT * FROM database WHERE ... "; #Query
$query = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($query);
<body onload="window.print()">

<h1>Order #<?= $row['orderID'] ?></h1> <!-- 'orderID' being the column in your DB -->
<hr />
<p>Some other content...</p>


Use a really simple HTML file to output the results, and the same idea works if you want to display a print page on your submission page. Just insert this code beneath the stuff you already have.

Edited by mattster

This topic has been dead for over six months. 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.