Tijden veranderen
Post Script
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php include "_config.php"; ?>
<table border="0" cellpadding="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="30%"><font face="verdana" size="2">Categorie</font></td>
<td width="50%">
<?php <select size="1" name="database">
<option value="$sql_query = "INSERT INTO actie (naam_spel, screenshot, html) "; ">Actie</option>
<option value="$sql_query = "INSERT INTO avontuur (naam_spel, screenshot, html) "; ">Avontuur</option>
<option value="$sql_query = "INSERT INTO behendigheid (naam_spel, screenshot, html) "; ">Behendigheid</option>
<option value="$sql_query = "INSERT INTO casino_en_bord (naam_spel, screenshot, html) "; ">Casino en Bord</option>
<option value="$sql_query = "INSERT INTO film_en_tv (naam_spel, screenshot, html) "; ">Film en TV</option>
<option value="$sql_query = "INSERT INTO humor (naam_spel, screenshot, html) "; ">Humor</option>
<option value="$sql_query = "INSERT INTO multiplayer (naam_spel, screenshot, html) "; ">Multiplayer</option>
<option value="$sql_query = "INSERT INTO puzzel (naam_spel, screenshot, html) "; ">Puzzel</option>
<option value="$sql_query = "INSERT INTO race (naam_spel, screenshot, html) "; ">Race</option>
<option value="$sql_query = "INSERT INTO sport (naam_spel, screenshot, html) "; ">Sport</option>
</select>
?>
</td>
</tr>
<tr>
<td width="30%"><font face="verdana" size="2">Naam Spel</font></td>
<td width="50%">
</font>
<input type="text" name="naam_spel" size="30"></td>
</tr>
<tr>
<td width="30%"><font face="verdana" size="2">Screenshot</font></td>
<td width="50%">
<input type="text" name="screenshot" size="30"></td>
</tr>
<tr>
<td width="30%"><font face="verdana" size="2">Adres</font></td>
<td width="50%">
<input type="text" name="html" size="30"></td>
</tr>
<tr>
<td width="30%"> </td>
<td width="50%"><input type="submit" value="Ok" name="submit"></td>
</tr>
</table>
</td>
</tr>
</table></form>
<table border="0" cellpadding="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="30%"><font face="verdana" size="2">Categorie</font></td>
<td width="50%">
<?php <select size="1" name="database">
<option value="$sql_query = "INSERT INTO actie (naam_spel, screenshot, html) "; ">Actie</option>
<option value="$sql_query = "INSERT INTO avontuur (naam_spel, screenshot, html) "; ">Avontuur</option>
<option value="$sql_query = "INSERT INTO behendigheid (naam_spel, screenshot, html) "; ">Behendigheid</option>
<option value="$sql_query = "INSERT INTO casino_en_bord (naam_spel, screenshot, html) "; ">Casino en Bord</option>
<option value="$sql_query = "INSERT INTO film_en_tv (naam_spel, screenshot, html) "; ">Film en TV</option>
<option value="$sql_query = "INSERT INTO humor (naam_spel, screenshot, html) "; ">Humor</option>
<option value="$sql_query = "INSERT INTO multiplayer (naam_spel, screenshot, html) "; ">Multiplayer</option>
<option value="$sql_query = "INSERT INTO puzzel (naam_spel, screenshot, html) "; ">Puzzel</option>
<option value="$sql_query = "INSERT INTO race (naam_spel, screenshot, html) "; ">Race</option>
<option value="$sql_query = "INSERT INTO sport (naam_spel, screenshot, html) "; ">Sport</option>
</select>
?>
</td>
</tr>
<tr>
<td width="30%"><font face="verdana" size="2">Naam Spel</font></td>
<td width="50%">
</font>
<input type="text" name="naam_spel" size="30"></td>
</tr>
<tr>
<td width="30%"><font face="verdana" size="2">Screenshot</font></td>
<td width="50%">
<input type="text" name="screenshot" size="30"></td>
</tr>
<tr>
<td width="30%"><font face="verdana" size="2">Adres</font></td>
<td width="50%">
<input type="text" name="html" size="30"></td>
</tr>
<tr>
<td width="30%"> </td>
<td width="50%"><input type="submit" value="Ok" name="submit"></td>
</tr>
</table>
</td>
</tr>
</table></form>
Zou iemand me verder kunnen helpen??
Gewijzigd op 01/01/1970 01:00:00 door Giga
TABLE genres
id
genre
TABLE games
id
Name
Description
Genre_id
Dat is al veel werkbaarder, verder moet je niet de query in je select zetten, maar alleen eerst het genre, of evt zelfs alleen het id dat in je db (bij de hiervoor genoemde opzet) voor een genre geld.
http://www.essetee.be/newphp/
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?php <select size="1" name="database">
<option value="$sql_query = "INSERT INTO actie (naam_spel, screenshot, html) "; ">Actie</option>
<option value="$sql_query = "INSERT INTO avontuur (naam_spel, screenshot, html) "; ">Avontuur</option>
<option value="$sql_query = "INSERT INTO behendigheid (naam_spel, screenshot, html) "; ">Behendigheid</option>
<option value="$sql_query = "INSERT INTO casino_en_bord (naam_spel, screenshot, html) "; ">Casino en Bord</option>
<option value="$sql_query = "INSERT INTO film_en_tv (naam_spel, screenshot, html) "; ">Film en TV</option>
<option value="$sql_query = "INSERT INTO humor (naam_spel, screenshot, html) "; ">Humor</option>
<option value="$sql_query = "INSERT INTO multiplayer (naam_spel, screenshot, html) "; ">Multiplayer</option>
<option value="$sql_query = "INSERT INTO puzzel (naam_spel, screenshot, html) "; ">Puzzel</option>
<option value="$sql_query = "INSERT INTO race (naam_spel, screenshot, html) "; ">Race</option>
<option value="$sql_query = "INSERT INTO sport (naam_spel, screenshot, html) "; ">Sport</option>
</select>
?>
<option value="$sql_query = "INSERT INTO actie (naam_spel, screenshot, html) "; ">Actie</option>
<option value="$sql_query = "INSERT INTO avontuur (naam_spel, screenshot, html) "; ">Avontuur</option>
<option value="$sql_query = "INSERT INTO behendigheid (naam_spel, screenshot, html) "; ">Behendigheid</option>
<option value="$sql_query = "INSERT INTO casino_en_bord (naam_spel, screenshot, html) "; ">Casino en Bord</option>
<option value="$sql_query = "INSERT INTO film_en_tv (naam_spel, screenshot, html) "; ">Film en TV</option>
<option value="$sql_query = "INSERT INTO humor (naam_spel, screenshot, html) "; ">Humor</option>
<option value="$sql_query = "INSERT INTO multiplayer (naam_spel, screenshot, html) "; ">Multiplayer</option>
<option value="$sql_query = "INSERT INTO puzzel (naam_spel, screenshot, html) "; ">Puzzel</option>
<option value="$sql_query = "INSERT INTO race (naam_spel, screenshot, html) "; ">Race</option>
<option value="$sql_query = "INSERT INTO sport (naam_spel, screenshot, html) "; ">Sport</option>
</select>
?>
Dit gaat dus nooit werken.
probeer dit eens:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
?>
<form method="POST" name="addgame" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<!-- nog meer form onderdelen -->
<select size="1" name="genre">
<option value="1">Actie</option>
<option value="2">Avontuur</option>
<option value="3">Behendigheid</option>
<option value="4">Casino en Bord</option>
<option value="5">Film en TV</option>
<option value="6">Humor</option>
<option value="7">Multiplayer</option>
<option value="8">Puzzel</option>
<option value="9">Race</option>
<option value="10">Sport</option>
</select>
</form>
<?php
//gebasseerd op Roberts Datamodel
if($_SERVER['REQUEST_METHOD'] == "POST")
{
$query = "INSERT INTO games
SET
(Name, Description, Genre )
VALUES
('".$naam."','".$omschrijving."','".$_POST['genre']."')";
if(!mysql_query($query))
{
echo 'Uw spel is niet toegevoegd.';
//echo mysql_error();
// In de testfase is het makkelijk om je SQL errors weer te geven
}
else
{
echo 'Uw spel is succesvol toegevoegd.';
}
}
?>
ini_set('display_errors', 1);
error_reporting(E_ALL);
?>
<form method="POST" name="addgame" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<!-- nog meer form onderdelen -->
<select size="1" name="genre">
<option value="1">Actie</option>
<option value="2">Avontuur</option>
<option value="3">Behendigheid</option>
<option value="4">Casino en Bord</option>
<option value="5">Film en TV</option>
<option value="6">Humor</option>
<option value="7">Multiplayer</option>
<option value="8">Puzzel</option>
<option value="9">Race</option>
<option value="10">Sport</option>
</select>
</form>
<?php
//gebasseerd op Roberts Datamodel
if($_SERVER['REQUEST_METHOD'] == "POST")
{
$query = "INSERT INTO games
SET
(Name, Description, Genre )
VALUES
('".$naam."','".$omschrijving."','".$_POST['genre']."')";
if(!mysql_query($query))
{
echo 'Uw spel is niet toegevoegd.';
//echo mysql_error();
// In de testfase is het makkelijk om je SQL errors weer te geven
}
else
{
echo 'Uw spel is succesvol toegevoegd.';
}
}
?>
Dit is niet getest maar een schopje in de goede richting.
Gewijzigd op 01/01/1970 01:00:00 door Jurgen assaasas
INSERT INTO games
SET
Is niet de juiste Syntax
Gewijzigd op 01/01/1970 01:00:00 door Klaasjan Boven
Zou ik de script mogen weten..
Ja misschien er te snel overheen getypt maar zoiets moet het zijn, zijn orginele script klopt voor geen meter. En idd lidwoord fouten zijn idd heeeeeeeeel irritant.