in t
Ik heb net een script gemaakt om dingen aan een tabel in de database toe te voegen
Ik kan alle velden invullen maar zodra ik op verzenden klik gebeurt er niks
Wie weet waar het aan ligt hier even de scrips die ermee te maken hebben
---toevoegen.php---
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
<?php
error_reporting(E_ALL);
include("includes/config.php");
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
{
$insert = "
INSERT
INTO wars
(
'author',
'opponent',
'opponenttag',
'date',
'time',
'map1',
'map2',
'ourscore',
'opponentscore',
'xpilineup',
'opponentlineup',
'extrainfo',
'report'
)
VALUES
(
'',
'".$_POST['author']."',
'".$_POST['opponent']."',
'".$_POST['opponenttag']."',
'".$_POST['date']."',
'".$_POST['time']."',
'".$_POST['map1']."',
'".$_POST['map2']."',
'".$_POST['ourscore']."',
'".$_POST['opponentscore']."',
'".$_POST['xpilineup']."',
'".$_POST['opponentlineup']."',
'".$_POST['extrainfo']."',
'".$_POST['report']."'
)
"or die(mysql_error());
$query = mysql_query($insert) or die(mysql_error());
}
}
echo "<h2>War toevoegen</h2>
<form method='post' action=''>
<table border='1'>
<tr>
<td>auteur:</td>
<td><input type='text' name='author' value='".$_POST['author']."'></td>
</tr> <tr>
<td>tegenstander:</td>
<td><input type='text' name='opponent' value='".$_POST['opponent']."'></td>
</tr> <tr>
<td>tag tegenstander:</td>
<td><input type='text' name='opponenttag' value='".$_POST['opponenttag']."'></td>
</tr> <tr>
<td>datum:</td>
<td><input type='text' name='date' value='".$_POST['date']."'></td>
</tr> <tr>
<td>tijd:</td>
<td><input type='text' name='time' value='".$_POST['time']."'></td>
</tr> <tr>
<td>map1:</td>
<td><input type='text' name='map1' value='".$_POST['map1']."'></td>
</tr> <tr>
<td>map2:</td>
<td><input type='text' name='map2' value='".$_POST['map2']."'></td>
</tr> <tr>
<td>eigenscore:</td>
<td><input type='text' name='ourscore' value='".$_POST['ourscore']."'></td>
</tr> <tr>
<td>scoretegenstander:</td>
<td><input type='text' name='opponentscore' value='".$_POST['opponentscore']."'></td>
</tr> <tr>
<td>eigen reactie:</td>
<td><input type='text' name='xpilineup' value='".$_POST['xpilineup']."'></td>
</tr> <tr>
<td>reactie tegenstander:</td>
<td><input type='text' name='opponentlineup' value='".$_POST['opponentlineup']."'></td>
</tr>
<tr>
<td>extra info:</td>
<td><input type='text' name='extrainfo' value='".$_POST['extrainfo']."'></td>
</tr>
<tr>
<td>raport:</td>
<td><input type='text' name='report' value='".$_POST['report']."'></td>
</tr>
<tr>
<td> </td>
<td><input type='submit' name='Toevoegen' value='Toevoegen'></td>
</tr>
</table>
</form>";
?>
error_reporting(E_ALL);
include("includes/config.php");
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
{
$insert = "
INSERT
INTO wars
(
'author',
'opponent',
'opponenttag',
'date',
'time',
'map1',
'map2',
'ourscore',
'opponentscore',
'xpilineup',
'opponentlineup',
'extrainfo',
'report'
)
VALUES
(
'',
'".$_POST['author']."',
'".$_POST['opponent']."',
'".$_POST['opponenttag']."',
'".$_POST['date']."',
'".$_POST['time']."',
'".$_POST['map1']."',
'".$_POST['map2']."',
'".$_POST['ourscore']."',
'".$_POST['opponentscore']."',
'".$_POST['xpilineup']."',
'".$_POST['opponentlineup']."',
'".$_POST['extrainfo']."',
'".$_POST['report']."'
)
"or die(mysql_error());
$query = mysql_query($insert) or die(mysql_error());
}
}
echo "<h2>War toevoegen</h2>
<form method='post' action=''>
<table border='1'>
<tr>
<td>auteur:</td>
<td><input type='text' name='author' value='".$_POST['author']."'></td>
</tr> <tr>
<td>tegenstander:</td>
<td><input type='text' name='opponent' value='".$_POST['opponent']."'></td>
</tr> <tr>
<td>tag tegenstander:</td>
<td><input type='text' name='opponenttag' value='".$_POST['opponenttag']."'></td>
</tr> <tr>
<td>datum:</td>
<td><input type='text' name='date' value='".$_POST['date']."'></td>
</tr> <tr>
<td>tijd:</td>
<td><input type='text' name='time' value='".$_POST['time']."'></td>
</tr> <tr>
<td>map1:</td>
<td><input type='text' name='map1' value='".$_POST['map1']."'></td>
</tr> <tr>
<td>map2:</td>
<td><input type='text' name='map2' value='".$_POST['map2']."'></td>
</tr> <tr>
<td>eigenscore:</td>
<td><input type='text' name='ourscore' value='".$_POST['ourscore']."'></td>
</tr> <tr>
<td>scoretegenstander:</td>
<td><input type='text' name='opponentscore' value='".$_POST['opponentscore']."'></td>
</tr> <tr>
<td>eigen reactie:</td>
<td><input type='text' name='xpilineup' value='".$_POST['xpilineup']."'></td>
</tr> <tr>
<td>reactie tegenstander:</td>
<td><input type='text' name='opponentlineup' value='".$_POST['opponentlineup']."'></td>
</tr>
<tr>
<td>extra info:</td>
<td><input type='text' name='extrainfo' value='".$_POST['extrainfo']."'></td>
</tr>
<tr>
<td>raport:</td>
<td><input type='text' name='report' value='".$_POST['report']."'></td>
</tr>
<tr>
<td> </td>
<td><input type='submit' name='Toevoegen' value='Toevoegen'></td>
</tr>
</table>
</form>";
?>
---includes/config.php---
Code (php)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
<?php
$hostname = "localhost";
$username = "gebruikersnaam";
$password = "wachtwoord";
$database = "databese";
$clannaam = "test";
mysql_connect($hostname,$username,$password) or die(mysql_error());
mysql_select_db($database);
?>
$hostname = "localhost";
$username = "gebruikersnaam";
$password = "wachtwoord";
$database = "databese";
$clannaam = "test";
mysql_connect($hostname,$username,$password) or die(mysql_error());
mysql_select_db($database);
?>
en de db tabel is
CREATE TABLE `wars` (
`id` int(3) NOT NULL default '0',
`author` text NOT NULL,
`opponent` tinytext NOT NULL,
`opponenttag` tinytext NOT NULL,
`date` date NOT NULL default '0000-00-00',
`time` time NOT NULL default '00:00:00',
`map1` tinytext NOT NULL,
`map2` tinytext NOT NULL,
`ourscore` int(2) NOT NULL default '0',
`opponentscore` int(2) NOT NULL default '0',
`xpilineup` text NOT NULL,
`opponentlineup` text NOT NULL,
`extrainfo` longtext NOT NULL,
`report` longtext NOT NULL
) TYPE=MyISAM;
het enige wat aan de tabel niet klop is de regel id want die staad op auto_increment
dit is de error die ik krijg
Notice: Undefined index: author in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 53
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 53
Notice: Undefined index: opponent in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 56
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 56
Notice: Undefined index: opponenttag in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 59
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 59
Notice: Undefined index: date in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 62
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 62
Notice: Undefined index: time in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 65
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 65
Notice: Undefined index: map1 in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 68
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 68
Notice: Undefined index: map2 in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 71
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 71
Notice: Undefined index: ourscore in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 74
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 74
Notice: Undefined index: opponentscore in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 77
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 77
Notice: Undefined index: xpilineup in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 80
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 80
Notice: Undefined index: opponentlineup in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 83
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 83
Notice: Undefined index: extrainfo in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 87
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 87
Notice: Undefined index: report in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 91
Notice: Undefined variable: fout in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 91
en dit is de error die ik krijg als ik op toevoegen klik als ik de velden heb ingevult
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 ''author', 'opponent', 'opponenttag',
groetjes robert
Gewijzigd op 17/07/2005 15:06:00 door Robert stevens
Gewijzigd op 17/07/2005 15:05:00 door robert stevens
moet je vervangen door dit: `
in dit stuk code:
(
'author',
'opponent',
'opponenttag',
'date',
'time',
'map1',
'map2',
'ourscore',
'opponentscore',
'xpilineup',
'opponentlineup',
'extrainfo',
'report'
)
'".$_POST['extrainfo']."',
'".$_POST['report']."'
)
"or die(mysql_error());
en haal or die (mysql_error())
daar weg, dat klopt niet/kan daar niet
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 ''author', 'opponent', 'opponenttag',
deze
Column count doesn't match value count at row 1
ik heb gedaan wat sebastiaan en ruud zijden
vermoed van niet ?
(
'author',
'opponen
en
VALUES
(
'',
bij values geef je als eerste een lege waarde door ( waarschijnlijk bedoelt voor een id veld (autoincrement= zelf vullend
of
bij VALUES '' , weghalen
of bij de veldnamen het veld noemen ID ?
VALUES
(
hier een lege string===> '',
'".$_POST['author']."',
Dus moet je bij
INSERT
INTO wars
(
hier dit zetten===> id,
author,
Edit: PS. Die ' kunnen weg..
Gewijzigd op 17/07/2005 15:49:00 door - SanThe -
Notice: Undefined index: author in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 52
Notice: Undefined index: opponent in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 55
Notice: Undefined index: opponenttag in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 58
Notice: Undefined index: date in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 61
Notice: Undefined index: time in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 64
Notice: Undefined index: map1 in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 67
Notice: Undefined index: map2 in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 70
Notice: Undefined index: ourscore in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 73
Notice: Undefined index: opponentscore in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 76
Notice: Undefined index: xpilineup in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 79
Notice: Undefined index: opponentlineup in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 82
Notice: Undefined index: extrainfo in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 86
Notice: Undefined index: report in /data/members/free/tripod/nl/d/j/s/djstarlight/htdocs/clanwarscript/toevoegen.php on line 90
Rafael:
Waarom los je ze niet gewoon op?
Het gaat hier dus om niet bestaande array indexen ( zonder naar het script te kijken ).
Quote:
Waarom los je ze niet gewoon op?
Het gaat hier dus om niet bestaande array indexen ( zonder naar het script te kijken ).
Het gaat hier dus om niet bestaande array indexen ( zonder naar het script te kijken ).
Omdat de meesten hier de simpelste oplossing willen, zonder te kijken of dit wel de beste is :)