Use Data in feedback form after retrieving from database

vipul73

I have created a page to retrieve data from a database

I have created a database "orders" in Mysql and have a table named "spaces" in that.

Now the data is being retrieved successfully.

I would like use the data in a feedback form and it should be sent to the e-mail address specified in the feedback form i.e. I should get the name of the package etc. in the e-mail after the user orders a product from our site.


<?php 

$db = mysql_connect("localhost", "root"); 

mysql_select_db("orders",$db); 

// display individual record 
if (!empty($_GET['id']) && is_numeric($_GET['id'])) { 
    $sql = "SELECT package, amount, currency, duration FROM spaces WHERE id=".$_GET['id']; 
    $result = mysql_query($sql, $db) or die(mysql_error().'<p>'.$sql.'</p>'); 

if (mysql_num_rows($result) == 1) { 
    $myrow = mysql_fetch_assoc($result); 
    echo 'Package Name: '.$myrow['package'].'<br />'; 
    echo 'Amount: '.$myrow['currency'].''; 
    echo ' '.$myrow['amount'].'<br />'; 
    echo 'Duration: '.$myrow['duration'].'<br />'; 

} else { 
    // no records found 
    echo 'There is no record with an ID of '.$_GET['id']; 
} 
} else { 
    // no records to display 
    echo 'Sorry, no records were found!'; 
} 

?>

nemonoman

Dear Vipul: It sounds like you have the opportunity to learn some php/mysql programming. The task you've set is doable, but it's YOUR task.

Get started on your programming adventure! Let us know when you've hit a brick wall and we'll see what we can do to help. But I don't think there's anyone who is going to post all the code you need to do the stuff you want to do; not for free at least...

Nemo

vipul73

I have tried using mail() and passing the value through hidden fields would work.

But how do I pass value of retrieved data to a hidden field?

stolzyboy

show us what you tried with the mail(), maybe you aren't implementing it correctly, ie post some code you use when doing
that

vipul73

<?php

$db = mysql_connect("localhost", "root");

mysql_select_db("orders",$db);

// display individual record
if (!empty($_GET['id']) && is_numeric($_GET['id'])) { 
    $sql = "SELECT package, amount, currency, duration FROM spaces WHERE id=".$_GET['id']; 
    $result = mysql_query($sql, $db) or die(mysql_error().'<p>'.$sql.'</p>'); 

if (mysql_num_rows($result) == 1) { 

$myrow = mysql_fetch_assoc($result); 
$message= "Package Name: $myrow['package']<br>
Amount: $myrow['currency'] $myrow['amount']<br>
Duration: $myrow['duration']<br>"; 
$message_email= "Package Name: $myrow['package']\n Amount: $myrow['currency'] $myrow['amount']\n
Duration: $myrow['duration']\n"; 

print $message;
mail($rec_email,$subject,$message_email,"From: $sender_email);

}

else { 
        // no records found 
        echo 'There is no record with an ID of '.$_GET['id']; 
    } 
} else { 
    // no records to display 
    echo 'Sorry, no records were found!'; 
}

?>

stolzyboy

<?
$db = mysql_connect("localhost", "root");

mysql_select_db("orders",$db);

// display individual record
if (!empty($_GET['id']) && is_numeric($_GET['id'])) { 
    $sql = "SELECT package, amount, currency, duration FROM spaces WHERE id=".$_GET['id']; 
    $result = mysql_query($sql, $db) or die(mysql_error().'<p>'.$sql.'</p>'); 

if (mysql_num_rows($result) == 1) {
while ($row = mysql_fetch_array($result))
{
$package = $row['package'];
$currency = $row['currency'];
$amount = $row['amount'];
$duration = $row['duration'];
}

$to  = "Whom Ever <whomever@wherever.com>";

$subject = "Whatever Subject";

$message = "
<html>
<head>
<title></title>
</head>
<body>
Package Name: $package<br>
Amount: $currency $amount<br>
Duration: $duration<br>
</body>
</html>
";

$headers  = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";

$headers .= "From: You <you@you.com>\r\n";
$headers .= "Cc: [email]notyou@you.com[/email]\r\n";

mail($to, $subject, $message, $headers);
}
?>