PHPhulp.nl PHPhulp.nl
35k+ leden Over PHPhulp Offerte opdracht Contact
a

Pizzaria

Door andy op 13-07-2008 15:10
501 views
Hallo leden van PHP Hulp
Ik heb hier een script gemaakt voor een pizzaria en werk nu met variabelen om de prijs weer te geven

Maar hoe wil ik nu doen dat mensen zeg maar 10 soepen willen en 1 pizza dat hij het dan in een database drukt...
Maar dat is niet de grootste probleem de grootste probleem is dat de eigenaar van de pizzaria ook wilt hebben dat je meteen het totaal bedrag ziet onderaan.

Dus als je 10 soepen hebt dat het er dan automatish bij komt te staan wat het bedrag is


Hier is het script

<html>
<head>
<title>Pizzeria  - Voorgerecht</title>
<style type="text/css">
<!--
.texte {  font-family: "Arial"; font-size: 10pt; color: #000000; font-style: normal; font-weight: normal}
.copy { font-family: "Times New Roman", Times, serif; font-size: 9pt; color: #993333; font-style: normal; font-weight: normal }
.txtprijs { font-family: "Arial"; font-size: 9pt; color:#000000; font-style: normal; font-weight: normal}
.txteuroprijs { font-family: "Arial"; font-size: 10pt; color:#000000; font-style: normal; font-weight: bolder}
.redtxt { font-family: "Times New Roman", Times, serif; font-size: 10pt; color: #993333; font-style: normal; font-weight: normal }
-->
</style>
</head>
<?php
include("config.php");
$huwprijs = "3.50";
$huwprijs1 = "4.00";
$huwprijs2 = "4.00";
$huwprijs3 = "4.00";
$huwprijs4 = "4.00";
$huwprijs5 = "4.00";
$huwprijs6 = "4.00";
$huwprijs7 = "5.00";
$huwprijs8 = "5.00";
$huwprijs9 = "6.00";
$huwprijs10 = "6.00";
$huwprijs11 = "4.00";
$huwprijs12 = "4.00";
$huwprijs13 = "4.00";
$huwprijs14 = "4.00";
$huwprijs15 = "5.00";
$huwprijs16 = "5.00";
$huwprijs17 = "5.00";
?>
<body background="images/background.gif">
<p align="center">
<CENTER>
<BR>
<table cellSpacing="0" cellPadding="0" width="485" border="0">
  <tbody>
  	<tr>
	<td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b><h1>Salades</h1></b></span></td>
      <td width="50" align="right"></td>

	</tr>
    <tr>
      <td width="30" align="left">
        <p align="left"><span class="texte"><b></b></span></p>
      </td>
      <td align="left"><span class="texte"><b>Gemengde Salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
    <tr height="5">
      <td width="50" align="left"></td>
      <td align="left"></td>
      <td width="50" align="right"></td>
    </tr>
    <tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Olijven salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs1" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
    <tr height="5">
      <td width="50" align="left"></td>
      <td align="left"></td>
      <td width="50" align="right"></td>
    </tr>
    <tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Feta salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs2" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
    <tr height="5">
      <td width="50" align="left"></td>
      <td align="left"></td>
      <td width="50" align="right"></td>
    </tr>
    <tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Sardine salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs3" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
    <tr height="5">
      <td width="50" align="left"></td>
      <td align="left"></td>
      <td width="50" align="right"></td>
    </tr>
    <tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Makreel salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs4" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
    <tr height="5">
      <td width="50" align="left"></td>
      <td align="left"></td>
      <td width="50" align="right"></td>
    </tr>
    <tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Garnalen salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs5" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
    <tr height="5">
      <td width="50" align="left"></td>
      <td align="left"></td>
      <td width="50" align="right"></td>
    </tr>
    <tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Inktvis salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs6" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
  </tbody>
</table>
</CENTER>
<br>
<CENTER>
<table cellSpacing="0" cellPadding="0" width="485" border="0">
    <tr>
      <td width="30" align="left">
        <p align="left"><span class="texte"><b></b></span></p>
      </td>
      <td align="left"><span class="texte"><b>Couscous salade</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs7" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
    <tr height="5">
      <td width="50" align="left"></td>
      <td align="left"></td>
      <td width="50" align="right"></td>
    </tr>
    <tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Sulatana salade (fantasie van de kok)</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs8" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
		<tr>
	<td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b><h1>Soepen</h1></b></span></td>
      <td width="50" align="right"></td>

	</tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Marokkaanse tomatensoep</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs9" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Uiensoep</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs10" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Tomatensoep</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs11" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Groentensoep</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs12" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Kippensoep</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs13" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Vissoep</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs14" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
	<tr>
	<td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b><h1>Kinder menu</h1></b></span></td>
      <td width="50" align="right"></td>

	</tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Patat shoarma</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro;<?php echo"$huwprijs15" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Patat kip</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs16" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
	<tr>
      <td width="30" align="left"><span class="texte"><b></b></span></td>
      <td align="left"><span class="texte"><b>Patat hamburger</b></span></td>
      <td width="50" align="right"><span class="txteuroprijs">&euro; 
        <?php echo"$huwprijs17" ?></span></td>
    </tr>
    <tr>
      <td width="30" align="left"></td>
      <td align="left"><span class="txtprijs"><TD class=mainTxt width=53><INPUT maxLength=5 value=0 size=5 name=aantalkopen></span></td>
      <td width="50" align="right"></td>
    </tr>
</table>
</CENTER>
</body>

</html>


mod_edit: Robert_Deiman

Ik heb even code tags [ignore]
[/ignore]om je code geplaatst..
a
andytjuh Bruggeman
16-07-2008 23:27
Ok super bedankt hij werkt :D

maar nu 1 probleem :S

Hij wil hem niet in de database invoegen :S vanalles geprobeert

Kan iemand vinden hoe dat kan ?

Hier is de database

CREATE TABLE `bestelling` (
  `ip` varchar(255) NOT NULL default '',
  `gemendesalade` varchar(255) NOT NULL default '0',
  `id` varchar(255) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



En hier is het script


<html>
<head>
<title>Pizzeria Antonello - Spagghetti</title>
<style type="text/css">
<!--
.texte {  font-family: "Arial"; font-size: 10pt; color: #000000; font-style: normal; font-weight: normal}
.copy { font-family: "Times New Roman", Times, serif; font-size: 9pt; color: #993333; font-style: normal; font-weight: normal }
.txtprijs { font-family: "Arial"; font-size: 9pt; color:#000000; font-style: normal; font-weight: normal}
.txteuroprijs { font-family: "Arial"; font-size: 10pt; color:#000000; font-style: normal; font-weight: bolder}
.redtxt { font-family: "Times New Roman", Times, serif; font-size: 10pt; color: #993333; font-style: normal; font-weight: normal }
-->
</style>
</head>
<SCRIPT language="JavaScript">function bereken_prijs()
{
  var prijs1 = Number(document.getElementById('prijs_pizza1').value);
  var aantal1 = Math.floor( Number(document.getElementById('aantal_pizza1').value) );

  var prijs2 = Number(document.getElementById('prijs_pizza2').value);
  var aantal2 = Math.floor( Number(document.getElementById('aantal_pizza2').value) );

  var prijs3 = Number(document.getElementById('prijs_pizza3').value);
  var aantal3 = Math.floor( Number(document.getElementById('aantal_pizza3').value) );

  var totaal = (prijs1 * aantal1) + (prijs2 * aantal2) + (prijs3 * aantal3) ;

  document.getElementById('totaal_prijs').innerHTML = 'totaal: €' + totaal;
} </SCRIPT>


<?php 
// Connects to Our Database 
mysql_connect("localhost", "truecrime_crime", "IA5XrARS") or die(mysql_error()); 
mysql_select_db("truecrime_crime") or die(mysql_error()); 
?> 

<body background="images/background.gif">
<p align="center">
<CENTER>
<BR>
<table cellSpacing="0" cellPadding="0" width="485" border="0">
 <?
 if(isset($_POST['submit'])) {
$ip = $_SERVER['REMOTE_ADDR']; 
$aantal_pizza1          = $_POST['aantal_pizza1'];
mysql_query("UPDATE `bestelling` SET `gemendesalade`=`gemendesalade`+'$aantal_pizza1',`ip`=`ip`+'$ip' where `id`='0'") or die (mysql_error());

echo"Je bestelling is ontvangen";
}
$prijs_pizza1 = 2.5;
$prijs_pizza2 = 3.5;
$prijs_pizza3 = 3.0;

$pagina_content = '<form method="POST">
  <table>
  <tr>
    <th>
      Pizza
    </th>
    <th>
      Prijs
    </th>
    <th>
      aantal
    </th>
  </tr>

  <tr>
    <td>
      Margarita: 
    </td>
    <td>
      €'. $prijs_pizza1 .' 
    </td>
    <td>
      <input type="text" name="aantal_pizza1" id="aantal_pizza1" class="input_aantal"> 
      <input type="hidden" name="prijs_pizza1" id="prijs_pizza1" value="'. $prijs_pizza1 .'">
    </td>
  </tr>

  <tr>
    <td>
      Hawaï: 
    </td>
    <td>
      €'. $prijs_pizza2 .' 
    </td>
    <td>
      <input type="text" name="aantal_pizza2" id="aantal_pizza2" class="input_aantal"> 
      <input type="hidden" name="prijs_pizza2" id="prijs_pizza2" value="'. $prijs_pizza2 .'">
    </td>
  </tr>

  <tr>
    <td>
      Peperoni: 
    </td>
    <td>
      €'. $prijs_pizza3 .' 
    </td>
    <td>
      <input type="text" name="aantal_pizza3" id="aantal_pizza3" class="input_aantal"> 
      <input type="hidden" name="prijs_pizza3" id="prijs_pizza3" value="'. $prijs_pizza3 .'">
    </td>
  </tr>
  <tr>
    <td>
      <input type="button" onClick="bereken_prijs();" value="Bereken prijs">
    </td>
  </tr>
  </table>
<div id="totaal_prijs"></div>
';

echo 
'<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 TRADITIONAL //NL">
<html>
  <style>
    .input_aantal{width: 40px; }
  </style>
  <head>
    <title>Pizzeria</title>
    <link REL=stylesheet HREF="style.css" TYPE="text/css" />
    <link REL="SHORTCUT ICON" HREF="images/ico.ico" />
  </head>
  <body>
    '. $pagina_content .'
     <input type="submit" name="submit" value="Bestel">
	</form>
      <td width="50" align="right"></td>
    </tr>
</table>
</CENTER>
</body>

</html>'
?>

R
Robert Deiman
16-07-2008 23:34
Hoe kan je een update query doen als er nog niets in staat? Bij een update (de naam zegt het al) werk je de boel bij, bij een INSERT (ook daar zegt de naam het al) voeg je een nieuwe rij toe. Probeer maar eens ;)
a
andytjuh Bruggeman
16-07-2008 23:35
HAHha tuurlijk robert helemaal vergeten :D

Het werkt nu toppie man :D

Reageren

Inloggen om te reageren