Help - Storing retrieved MySQLdata

Raffikki529

Hi everyone!

I've just started learning php a while back and I am having a problem figuring this out. I've spent days searching for a solution but I think I don't know the correct terms etc...

I have a form that submits to a php page with the amounts of products, the generated data retrieved from the mysql database (id, supplier, product_name) displays perfectly inside a table. If I try to assign the information retrieved from the database to a variable, the variable is returned blank or as 1.

So how can store this information(table with retrieved data) and send it via email?

<html>
<body bgcolor="#333333" style="color:white; font-family:Verdana, Geneva, sans-serif;" >

                                                                    <table border="1" bordercolor="#000000" bgcolor="#00FFFF" style="color:black" width="985px">

                                                                    <tr>
                                                                    <th width="300px">Product</th>
                                                                    <th width="300px">Part #</th>
                                                                    <th width="300px">Supplier</th>
                                                                    <th>Amount</th>
                                                                    </tr>

<?                                                                        


$host = "localhost";
$user = "root";
$pass = "";
$database = "products";

$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");

$query = "SELECT * FROM products ORDER BY supplier, product";
$resultID = mysql_query($query, $linkID) or die("Data not found.");


while($row = mysql_fetch_array($resultID))

      {

        $fok = $row['id'];
        $amount = $_POST[$fok] . "</td>";

if ($amount != 0) {






                                                        echo "<tr><td>";
                                                        echo $row['Product'] . "</td><td>";


                                                        echo $row['Part_Number'] . "</td><td>";

                                                        echo $row['Supplier'] . "</td><td>";

                                                        echo $amount;

                                                        echo "</tr>";






            }
    }
    echo "</table>";
    ?>

</html>

This file is included in a submit.php file.
If the inc file is set as a variable and displayed again, it displays "1".

 $to = "admin@email.com";
           $headers = "From: orders@email.com";
           $subject = "Order from " . - $_POST['Name'];
           $name_field = $_POST['Name'];
           $surname_field = $_POST['Surname'];
           $tel_field = $_POST['Tel'];
           $info_field = $_POST['Info'];
           $address_field = $_POST['Address'];









                                                        $inc = include( 'inc.php' );                        



                                                        $body = "From: $name_field\n $surname_field\n Email: $email_field\n Tel: $tel_field\n Information:\n $info_field Products:\n $inc;";
                                                        $thanks = "Thank you for using our online order system! We are processing your order and will get back to you soon!";






                                                        echo "<br>";
                                                        echo "<br>";
                                                        echo "Order has been submitted";
                                                        echo "<br>";
                                                        echo "<br>";





             mail($to, $subject, $body, $headers);
             mail($email_field, $subject, $thanks, $headers);

                echo $inc;

The $inc variable at the bottom of the file still displays incorrectly. The $inc doesn't show the data retrieved from the mysql database. It only displays when the file is included, it only shows the data once, it is not stored in the variable, why? Should I use xml?

dagon

every where you use echo to create the table instead assign it to a var, then use that in the email

echo "<tr><td>";
echo $row['Product'] . "</td><td>";

becomes

$table.="<tr><td>";
$table.= $row['Product'] . "</td><td>";

Raffikki529

Is this correct?

while($row = mysql_fetch_array($resultID))

	{

		$fok = $row['id'];
		$amount = $_POST[$fok] . "</td>";

if ($amount != 0) {






														$table.= "<tr><td>";
														$table.= $row['Product'] . "</td><td>";


														$table.= $row['Part_Number'] . "</td><td>";

														$table.= $row['Supplier'] . "</td><td>";

														$table.= $amount;

														$table.= "</tr>";






			}
	}

	$table.= "</table>";
	?>

It displays undefined variable...😕

dagon

you need to be a lot clear if you expect any help, what is the exact error message, what is the code it refers to.

Raffikki529

Sorry about that - Notice: Undefined variable: table in C:\server\wamp\www\form\inc.php on line 42

dagon

a notice is not an error and shouldn't stop it working, post the script and what the problem is.

halojoy

$inc = include( 'inc.php' );  

$body = "From: $name_field\n $surname_field\n Email: $email_field\n
 Tel: $tel_field\n Information:\n $info_field Products:\n $inc;";

You have misunderstood how include works.
The way you use it, $inc will never be anything but 1. Which means it was success to include 'inc.php'
You can not get any Products from database using $inc variable this way.

You should make some other variables be set in 'inc.php'
Maybe an array() called $products

And so you can use it like:

include( 'inc.php' );  //where $products get some values

$body = "From: $name_field\n $surname_field\n Email: $email_field\n
 Tel: $tel_field\n Information:\n $info_field Products:\n $products ";

Raffikki529

Okay.

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Persons");

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['FirstName'] . "</td>";
  echo "<td>" . $row['LastName'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>

I would like this table, with the data retrieved from the mysql database, to be stored as a variable. I would then like to email this table with all the information.

  mail( "someone@example.com", "Subject: $subject",
  $retrieved_mysql_data, "From: $email" );

I can't seem to figure it out...😕

dagon

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Persons");

$retrieved_mysql_data= "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  $retrieved_mysql_data.= "<tr>";
  $retrieved_mysql_data.= "<td>" . $row['FirstName'] . "</td>";
  $retrieved_mysql_data.= "<td>" . $row['LastName'] . "</td>";
  $retrieved_mysql_data.= "</tr>";
  }
$retrieved_mysql_data.= "</table>";

mysql_close($con);


  mail( "someone@example.com", "Subject: $subject",
  $retrieved_mysql_data, "From: $email" ); 
?>

Raffikki529

Thanks halojoy.

I really suck at array🙁s, what would the code(array) look like in the most simple form? Like in the case of my previous reply...

Raffikki529

Thanks dagon!

The array works in the same way.

I finally got it! WOW Thanks guys I appreciate your help!!!!😃

It seems I still have a long way to go with php...:o