Bestelformulier + bevestiging, voedend uit db (1 bezoeker) (1) Gast
 | | |
|
TOPIC: Bestelformulier + bevestiging, voedend uit db
|
|
Bestelformulier + bevestiging, voedend uit db 4 Jaren, 2 Maanden geleden
|
Karma: 0
|
|
Doel: een formulier, ingevuld door de db, dat doorstuurt naar een "bevestiging".
Formulier:
[php]
<?php
session_start();
require_once("site.php");
dbconn();
//$_SESSION['me'] =$user[id];
needlogin();
siteheader();
//menu();
player();
//$res=mysql_query("SELECT * FROM users WHERE id=' ".$_SESSION[me]." ' ") or die(mysql_error()."Failed calling info");
//$user=mysql_fetch_array($res);
echo("<h1 align='center'>Procurement</h1>");
$res=mysql_query("SELECT * FROM rawmaterials") or die(mysql_error()." Couldn't go shopping");
//$raw=mysql_fetch_array($res);
echo("<p align='center'>Order raw materials</p>");
echo("<p align='center'><form name='buyraw' method='post' action='rawbuy.php'>");
echo("<table><tr><td>Resource</td><td>Price (per tonne)</td><td>#tonnes to purchase</td></tr>");
while($raw = mysql_fetch_array($res)){
echo("<tr><td>".$raw['name']."</td><td>".$raw['price']."</td><td><input name='Qty".$raw['id']."' type='text' id='Qty".$raw['id']."' size='7'></td></tr>");
}
echo("<tr><td colspan='3' align='center'> <input type='Submit' name='Submit' value='order resources'> </table>
</form>
</p>");
echo("<p align='center'>Order components</p>
<p align='center'> N/a</p>");
echo("<a href='format.php'>Format pagina</a>");
sitefooter();
die;
?>
[/php]
Bevestiging:
[php]
<?php
session_start();
require_once("site.php");
dbconn();
//$_SESSION['me'] =$user[id];
needlogin();
siteheader();
//menu();
player();
echo("<h1 align='center'>Procurement - raw materials ordered</h1>");
$res=mysql_query("SELECT * FROM rawmaterials") or die(mysql_error()." Could not go shopping");
echo("<table><tr><td><b>Resource</b></td><td><b>Quantity ordered</b></td></tr>");
while($raw = mysql_fetch_array($res)){
$ordered=$_POST["Qty'.$raw[id].'"];
$resourcename = $raw['name'];
echo("<tr><td>".$raw['name']."</td><td>".$ordered."</td></tr>") or die(mysql_error()."Failed buyrow");
}
echo("</table>");
sitefooter();
die;
?>
[/php]
Het formulier wordt heel mooi weergegeven. Echter... De tweede file geeft een hele mooie header, zegt vervolgens 11... en that's it... geen tabel, zoals ik dat zo mooi in gedachten had...
|
|
|
|
|
|
|
 | | |
|