Witam,
Skopiowalem dla pomocy formularz i kod php po zmianie, dzieukuje za rade dot INSERT (IMG:
http://forum.php.pl/style_emoticons/default/smile.gif) Ja poprostu bylem przekonany, ze sie inaczej nie da niz nowa tabelke (IMG:
http://forum.php.pl/style_emoticons/default/winksmiley.jpg)
<?php
$dbh = mysql_connect (\"localhost\", \"eter_rap\", \"tlanimassrap\") or die ('I cannot connect to the database because: ' . mysql_error()); $db_name=\"eter_raporty\";
$wysl = 'INSERT INTO `Raporty` (`id`,
`Nick`,
`GG`,
`PlanetaG`,
`Kolonia1`,
`Kolonia2`,
`Kolonia3`,
`Kolonia4`,
`Kolonia5`,
`Kolonia6`,
`Kolonia7`,
`Kolonia8`,
`LM`,
`CM`,
`MT`,
`DT`,
`K`,
`OW`,
`B`,
`REC`,
`SS`,
`N`,
`GS`)
VALUES ('''',
''$_POST[nick]'',
''$_POST[GG]'',
''$_POST[planetag]'',
''$_POST[kolonia1]'',
''$_POST[kolonia2]'',
''$_POST[kolonia3]'',
''$_POST[kolonia4]'',
''$_POST[kolonia5]'',
''$_POST[kolonia6]'',
''$_POST[kolonia7]'',
''$_POST[kolonia8]'',
''$_POST[LM]'',
''$_POST[CM]'',
''$_POST[MT]'',
''$_POST[DT]'',
''$_POST[K]'',
''$_POST[OW]'',
''$_POST[B]'',
''$_POST[REC]'',
''$_POST[SS]'',
''$_POST[N]'',
''$_POST[GS]'')';
if{$wyslpol)
{
$k=\"Twój raport zostal przyjety\";
}else{
$k=\"Blad w wysylaniu\";
}
?>
formularz:
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<form action="rap.php" method="POST">
<tr><td>Nick
</td><td><input name="nick" type="text" size="20" maxlength="30"></td></tr> <tr><td>GG (numer)
</td><td><input name="GG" type="text" size="10" maxlength="9"></td></tr> <tr><td>Planeta Gl
<br>(wspolrzedne np. 1:234:345)
</td><td><input name="planetag" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 1
</td><td><input name="kolonia1" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 2
</td><td><input name="kolonia2" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 3
</td><td><input name="kolonia3" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 4
</td><td><input name="kolonia4" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 5
</td><td><input name="kolonia5" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 6
</td><td><input name="kolonia6" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 7
</td><td><input name="kolonia7" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Kolonia 8
</td><td><input name="kolonia8" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>L Mysliwiec (liczba)
</td><td><input name="LM" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>D Mysliwiec
</td><td><input name="CM" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>M Transport
</td><td><input name="MT" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>D Transport
</td><td><input name="DT" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Sonda Szpieg.
</td><td><input name="SS" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Krazownik
</td><td><input name="K" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Recycler
</td><td><input name="REC" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>OW
</td><td><input name="OW" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Niszczyciel
</td><td><input name="N" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Bombowiec
</td><td><input name="B" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td>Gwiazda Smierci
</td><td><input name="B" type="text" value="0" size="20" maxlength="30"></td></tr> <tr><td><input name="wyslij" type="submit" value="Wyslij"></td></tr>