No wiec pisze swoj pierwszy wiekrzy skrypt i oczywiscie problem:/
W pliku form.php user podaje swoje dane i wykonywana jest akcja z pliku submit.php , jednak submit.php wywala taki blad:
<?php
nie moge dodac useraSomething is wrong in your syntax obok 'imie', 'zawod', 'miasto', '23', 'podpis', 'mail@mail.pl', '20755' w linii 1
?>
form.php
<? include(\"../config.php\"); ?>
<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-2'>
<link rel=\"stylesheet\" type=\"text/css\" href=\"../main.css\">
</head>
<body bgcolor=\"#2B2B2B\">
<form name='create' action='submit.php' method='post'>
<table width='49%' height='255' border='0'>
<tr>
<td width='51%' height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Nick*:</font></td>
<td width='49%'><input type='text' name='nick'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Hasło*:</font></td>
<td><input type='password' name='pass'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Imię
i nazwisko:</font></td>
<td><input type='text' name='imie'></td>
</tr>
<tr>
<td height='21'><font color=\"
<? echo $news_content ?>\" size=\"-2\" face=\"Verdana, Arial, Helvetica, sans-serif\">Zawód</font></td>
<td><input type='text' name='zawod'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Miasto:</font></td>
<td><input type='text' name='miasto'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Wiek:</font></td>
<td><input type='text' name='wiek'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Podpis:</font></td>
<td><textarea name='podpis'></textarea></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>E-Mail*:</font></td>
<td><input type='text' name='mail'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Numer
GG:</font></td>
<td><input type='text' name='gg'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Avatar:</font></td>
<td><input type='text' name='avi'></td>
</tr>
<tr>
<td height='21'><font color='
<? echo $news_content ?>' size=\"-2\" face='Verdana, Arial, Helvetica, sans-serif'>* - pola wymagane</font></td>
<td><input type='submit' value='OK'></td>
</tr>
</table>
</form>
</body>
</html>
submit.php
<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-2'>
<link rel=\"stylesheet\" type=\"text/css\" href=\"../main.css\">
</head>
<body bgcolor=\"#2B2B2B\">
<?
include(\"../config.php\");
$grafikplus = \"0\";
$typ = \"usr\";
function dodaj_usera()
{
include(\"../config.php\");
$sql = mysql_connect ($adres, $user_baza, $haslo_baza) or
die(\"Nie moge polaczyc sie z baza MySQL\"); mysql_select_db(\"$nazwa_baza\") or die(\"Nie moge wejsc do tabeli<br>\".mysql_error()); $zapytanie = \"INSERT INTO users VALUES ('', '$_POST[nick]', '$_POST[pass]'', '$_POST[imie]', '$_POST[zawod]', '$_POST[miasto]', '$_POST[wiek]', '$_POST[podpis]', '$_POST[mail]', '$_POST[gg]', '$_POST[grafikplus]', '$_POST[typ]', '$_POST[avi]')\";
$wykonaj = mysql_query($zapytanie) or
die(\"nie moge dodac usera\".mysql_error()); echo \"<font color='$news_title' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Dziekujemy. Teraz możesz się zalogować.</font>\"; }
if(($nick == \"\") || ($pass == \"\") || ($mail == \"\")){
echo \"<font color='$news_title' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Niestety ale nie podałeś któregoś z wymaganych pól.</font>\"; }
else{
if(eregi(\"^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$\",$mail)) {
dodaj_usera();
}
else{
echo \"<font color='$news_title' size='-2' face='Verdana, Arial, Helvetica, sans-serif'>Popraw adres e-mail</font>\"; }
}
?>
</body>
</html>
Z gory dziekuje za pomoc (IMG:
http://forum.php.pl/style_emoticons/default/smile.gif)
Ten post edytował proszek 30.12.2004, 15:07:17