spíš to spadá pod databáze...

Ahoj lidičky,
může mi někdo opravit ty chyby ve zdrojáku pro databázi s názvem testyphpjk a heslem heslicko ? Na wz ani ic mi to nechce fachat...
index.phtml

<?

    /* Pocatecni prihlaseni ke strance ? */

    if ($jmeno=="" && $prijmeni=="" &&

        $email=="" && $narozen=="") { $firsttime="true"; };

    

    /* Inicializace filtru pro prazdna pole */

    if ($jmeno=="") { $jmeno="*"; };

    if ($prijmeni=="") { $prijmeni="*"; };

    if ($email=="") { $email="*"; };

    if ($narozen=="") { $narozen="*"; };

?>



<FORM ACTION=index.phtml METHOD=GET>

<TABLE>

<TR><TD>Jmeno:	<TD><INPUT TYPE=TEXT NAME=jmeno VALUE="<?echo $jmeno?>" SIZE=40>

<TR><TD>Prijmeni:<TD><INPUT TYPE=TEXT NAME=prijmeni VALUE="<?echo $prijmeni?>" SIZE=40>

<TR><TD>E-mail:	<TD><INPUT TYPE=TEXT NAME=email VALUE="<?echo $email?>" SIZE=40>

<TR><TD>Narozen:<TD><INPUT TYPE=TEXT NAME=narozen VALUE="<?echo $narozen?>" SIZE=10>

</TABLE>

<BR><INPUT TYPE=SUBMIT VALUE="Prohledej adresar">

</FORM>



<FORM ACTION=new.phtml METHOD=GET>

<INPUT TYPE=SUBMIT VALUE="Pridej novou adresu">

</FORM>



<?

    if ($firsttime!="true"):

?>



<HR>

<H2>Výsledky prohledávání</H2>



<TABLE>

<TR><td>Jmeno</td><td>E-mail</td><td>Datum narození</td><td>Úprava</td><td>Smazání</td>

<?

	mysql_Connect("localhost");

	/* prevod * na % pro operator like */

         $_jmeno = ereg_replace("\*", "%", $jmeno);

         $_prijmeni = ereg_replace("\*", "%", $prijmeni);

         $_email = ereg_replace("\*", "%", $email);

         $_narozen = ereg_replace("\*", "%", $narozen);

	$result = mysql("jkj", "select * from adresar where " +

		"jmeno like '$_jmeno' and prijmeni like '$_prijmeni' and " +

		"email like '$_email' and narozen like '$_narozen'");

	$num = mysql_NumRows($result);

	if ($num==0):

	    echo "<TR><TH COLSPAN=5>Dotazu nevyhovuje zadna adresa!\n";

	else:

	    $i = 0;

	    while ($i<$num):

		echo "<TR><TD>" + mysql_Result($result, $i, "jmeno") + " " +

		     mysql_Result($result, $i, "prijmeni");

	 	echo "<TD>" + mysql_Result($result, $i, "email");

	 	echo "<TD>" + mysql_Result($result, $i, "narozen");

	 	echo "<TD><A HREF='edit.phtml?id=" + 

		     mysql_Result($result, $i, "id") + "'>Uprav</A>";

	 	echo "<TD><A HREF='delete.phtml?id=" + 

		     mysql_Result($result, $i, "id") + "'>Smaz</A>";

		$i++;

	    endwhile;

	endif;

	mysql_Close();

?>

</TABLE>



<?

    endif;

?>

add.phtml

<?
mysql_Connect("localhost");
$result = mysql("jkj", "insert into adresar values (0, '$jmeno'," +
"'$prijmeni', '$email', '$narozen')");
if ($result==0):
echo "<H1>Nova adresa byla uspesne pridana</H1>";
else:
echo "<H1>Novou adresu se nepodarilo pridat</H1>";
endif;
mysql_Close();
?>

delete.phtml

<?
mysql_Connect("localhost");
$result = mysql("jkj", "delete from adresar where id=$id");
if ($result==0):
echo "<H1>Adresa byla uspesne smazana.</H1>";
else:
echo "<H1>Adresu se nepodarilo smazat.</H1>";
endif;
mysql_Close();
?>

edit.phtml

<?
mysql_Connect("localhost");
$result = mysql("jkj", "select * from adresar where id='$id'");
$jmeno = mysql_Result($result, 0, "jmeno");
$prijmeni = mysql_Result($result, 0, "prijmeni");
$email = mysql_Result($result, 0, "email");
$narozen = mysql_Result($result, 0, "narozen");
mysql_Close();
?>

<FORM ACTION=update.phtml METHOD=GET>
<TABLE>
<TR><TD>Jmeno: <TD><INPUT TYPE=TEXT NAME=jmeno VALUE="<?echo $jmeno>" SIZE=40>
<TR><TD>Prijmeni:<TD><INPUT TYPE=TEXT NAME=prijmeni VALUE="<?echo $prijmeni>" SIZE=40>
<TR><TD>E-mail: <TD><INPUT TYPE=TEXT NAME=email VALUE="<?echo $email>" SIZE=40>
<TR><TD>Narozen:<TD><INPUT TYPE=TEXT NAME=narozen VALUE="<?echo $narozen>" SIZE=10>
</TABLE>
<BR><INPUT TYPE=HIDDEN NAME=id VALUE=<?echo $id>>
<INPUT TYPE=SUBMIT VALUE="Proved zmenu udaju">
</FORM>

<FORM ACTION=index.phtml METHOD=GET>
<INPUT TYPE=SUBMIT VALUE="Zpet">
</FORM>

new.phtml

<FORM ACTION=add.phtml METHOD=GET>
<TABLE>
<TR><TD>Jmeno: <TD><INPUT TYPE=TEXT NAME=jmeno SIZE=40>
<TR><TD>Prijmeni:<TD><INPUT TYPE=TEXT NAME=prijmeni SIZE=40>
<TR><TD>E-mail: <TD><INPUT TYPE=TEXT NAME=email SIZE=40>
<TR><TD>Narozen:<TD><INPUT TYPE=TEXT NAME=narozen SIZE=10>
</TABLE>
<BR><INPUT TYPE=SUBMIT VALUE="Pridej adresu">
</FORM>

<FORM ACTION=index.phtml METHOD=GET>
<INPUT TYPE=SUBMIT VALUE="Zpet">
</FORM>

update.phtml

<?
mysql_Connect("localhost");
$result = mysql("jkj", "update adresar set jmeno='$jmeno', " +
"prijmeni='$prijmeni', email='$email', narozen='$narozen' " +
"where id=$id");
if ($result==0):
echo "<H1>Adresa byla uspesne zmenena.</H1>";
else:
echo "<H1>Adresu se nepodarilo zmenit.</H1>";
endif;
mysql_Close();
?>

Pozn.: Databázím moc nerozumím, tak mi to prosím opravte, zkopírujte a nechte tady. Díky.

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /3w/wz.cz/t/testyphpjk/index.phtml on line 47



Warning: mysql(): Access denied for user 'nobody'@'195.122.194.232' (using password: NO) in /3w/wz.cz/t/testyphpjk/index.phtml on line 55



Warning: mysql(): A link to the server could not be established in /3w/wz.cz/t/testyphpjk/index.phtml on line 55



Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /3w/wz.cz/t/testyphpjk/index.phtml on line 56



Warning: mysql_close(): no MySQL-Link resource supplied in /3w/wz.cz/t/testyphpjk/index.phtml on line 73





Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /3w/wz.cz/t/testyphpjk/add.phtml on line 8



Warning: mysql(): Access denied for user 'nobody'@'195.122.194.232' (using password: NO) in /3w/wz.cz/t/testyphpjk/add.phtml on line 10



Warning: mysql(): A link to the server could not be established in /3w/wz.cz/t/testyphpjk/add.phtml on line 10



Warning: mysql_close(): no MySQL-Link resource supplied in /3w/wz.cz/t/testyphpjk/add.phtml on line 16

Tušim, že jsem to stahoval ze stránek Jirky Koseka, tak by to mohlo bejt ok...