Hey ik ben nieuw met PHP en MySQL. Ik krijg telkens op mijn website de volgende error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Dit is mijn script:
Dit is mijn formulier:
Ik ben echt wanhopig want ik zie niet wat ik fout heb gedaan.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Dit is mijn script:
PHP:
$mysql = mysql_connect("localhost","user","pass") or die("Fout: Er is geen verbinding met de MySQL-server tot stand gebracht.");
mysql_select_db("leerling_10115Hgr5park",$mysql) or die("Fout: Het openen van de database is mislukt.");
$Week_nummer = mysql_query("SELECT Week_nummer FROM Bungalows",$mysql) or die(mysql_error());
$prijs = mysql_query("SELECT prijs FROM Bungalows WHERE max_aantal_pers = '$aantal_pers' AND '$berekening')",$mysql) or die(mysql_error());
$berekening = mysql_query("SELECT Week_nummer FROM Bungalows WHERE Week_nummer => '$Week_intrek' AND Week_nummer <= 'Week_vertrek')",$mysql) or die(mysql_error());
mysql_query("INSERT INTO Klant (Voornaam,Tussenvoegsel,Achternaam,Straat,Huisnummer,Postcode,Woonplaats,Telefoonnummer,aantal_pers,prijs) VALUES ('$Voornaam','$Tussenvoegsel','$Achternaam','$Straat','$Huisnummer','$Postcode','$Woonplaats','$Telefoonnummer','$aantal_pers','$prijs')",$mysql) or die(mysql_error());
mysql_query("INSERT INTO Reserveringen(Week_intrek,Week_vertrek,Week_geboekt,bungalow_soort) VALUES ('$Week_intrek','$Week_vertrek','$Week_geboekt','$bungalow_soort')",$mysql) or die(mysql_error());
mysql_query("INSERT INTO Rekening(Kosten_klant) VALUES ('$prijs')",$mysql) or die(mysql_error());
mysql_close($mysql) or die("Het verbreken van de verbinding met de MySQL-server is mislukt.");
print("De reservering:<br />Voornaam:<p class='Voornaam'>$Voornaam<p /><br />Tussenvoegsel:<p class='Tussenvoegsel'>$Tussenvoegsel</p><br />Achternaam:<p class='Achternaam'>$Achternaam</p><br />Straat:<p class='Straat'>$Straat</p><br />Huisnummer:<p class='Huisnummer'>$Huisnummer</p><br />Postcode:<p class='Postcode'>$Postcode</p><br />Woonplaats:<p class='Woonplaats'>$Woonplaats</p><br />Telefoonnummer:<p class='Telefoonnummer'>$Telefoonnummer</p><br />Aantal personen:<p class='aantal_pers'>$aantal_pers<p /><br />Soort bungalow:<p class='bungalow_soort'>$bungalow_soort<p /><br />Week van intrek:<p class='Week_intrek'>$Week_intrek<p /><br />Week van vertrek:<p class='Week_vertrek'>$Week_vertrek<p /><br />Week geboekt:<p class='Week_geboekt'>$Week_geboekt<p /><br />Bungalow soort:<p class='bungalow_soort'>$bungelow_soort<p /><br /><br />Prijs:<p class='prijs'>$prijs<p /><br />wordt zo spoedig mogelijk in behandeling genomen. We laten via email weten of de gekozen bungalow beschikbaar is.");
Dit is mijn formulier:
PHP:
<p> M.b.v. onderstaand formulier kunt u uw bungalow reserveren.<br />
</p>
<form action="beheer.php" method="post">
<p> Voorletters:<br />
<input type="text" size="12" maxlength="12" name="Voornaam" /><br /><br />
Tussenvoegsel:<br />
<input type="text" size="7" maxlength="7" name="Tussenvoegsel" /><br /><br />
Achternaam:<br />
<input type="text" size="12" maxlength="12" name="Achternaam" /><br /><br />
Straat en huisnummer:<br />
<input type="text" size="20" maxlength="255" name="Straat" />
<input type="text" size="5" maxlength="5" name="Huisnummer" /><br /><br />
Postcode:<br />
<input type="text" size="6" maxlength="6" name="Postcode" /><br /><br />
Woonplaats:<br />
<input type="text" size="20" maxlength="100" name="Woonplaats" /><br /><br />
Telefoonnummer:<br />
<input type="text" size="11" maxlength="11" name="Telefoonnummer" /><br /><br />
Welke week intrekken:<br />
<label>
<select name="Week_intrek" id="Week_intrek">
<option value="" selected></option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="52">52</option>
</select>
</label>
<br /><br />
Welke week vertrekken:<br />
<label>
<select name="Week_vertrek" id="Week_vertrek">
<option value="" selected></option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="52">52</option>
</select>
</label>
<br /><br />
Welke soort bungalow:<br />
<label>
<select name="bungalow_soort" id="bungalow_soort">
<option value="" selected></option>
<option value="4A">4A</option>
<option value="4B">4B</option>
<option value="6A">6A</option>
<option value="6B">6B</option>
<option value="8A">8A</option>
</select>
</label>
<br /><br />
Aantal personen:<br />
<input type="text" size="5" maxlength="1" name="aantal_pers" />
<br /><br />
Hoeveelste week van het jaar is het deze week:<br />
<label>
<select name="Week_geboekt" id="Week_geboekt">
<option value="" selected></option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
<option value="32">32</option>
<option value="33">33</option>
<option value="34">34</option>
<option value="35">35</option>
<option value="36">36</option>
<option value="37">37</option>
<option value="38">38</option>
<option value="39">39</option>
<option value="40">40</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
<option value="45">45</option>
<option value="46">46</option>
<option value="47">47</option>
<option value="48">48</option>
<option value="49">49</option>
<option value="50">50</option>
<option value="52">52</option>
</select>
</label>
<br /><br />
<input type="submit" value="Verzend" />
<input type="reset" value="Maak alles leeg" />
</p>
</form>
Ik ben echt wanhopig want ik zie niet wat ik fout heb gedaan.
Laatst bewerkt: