Adaugare informatii dintr-un form in baza de date
Scris: 04-Mai-2008, 12:34:49
Deci am forumular-ul html:
Acum codul continand query-ul care introduce acele informatii in baza de date:
Si acum codul care afiseaza acele informatii introduse:
Si mie imi da asta:
Ce am gresit?
Cod: Selectaţi tot
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<center>
<form method="post" action="****************">
Nume clan: <br /><input class="textbox" name="prov[nclan]" type="text"><br />
ClanLeader: <br /><input class="textbox" name="prov[nclanl]" type="text"><br />
ID Y! Messenger ClanLeader: <br /><input class="textbox" name="prov[idclanl]" type="text"><br />
Jucatori disponibili: <br /><input class="textbox" name="prov[jucatori]" type="text"><br />
Data (a se introduce si ora!): <br /><input class="textbox" name="prov[data]" type="text"><br /><br />
<input name="trimite" type="submit" value="Trimite!">
</form>
</center>
</body>
</html>Cod: Selectaţi tot
<?php
// Conectare la baza de date
$Host = "*******";
$User = "*******";
$Parola = "******";
$DB = "******";
$Tabel = "******";
// Inserare Query Provocare Meci :-) si redirect (daca)
$Conn = mysql_connect ($Host, $User, $Parola);
$Query = "INSERT INTO $Tabel VALUES('0', '".$prov["nclan"]."', '".$prov["nclanl"]."', '".$prov["idclanl"]."', '".$prov["jucatori"]."', '".$prov["data"]."')";
if (mysql_db_query ($DB, $Query, $Conn)) {
echo '<script language="JavaScript">
document.location.href="*********";
</script>';
} else {
echo "eroare";
}
// Deconectare de la baza de date
mysql_close ($Conn);
?>Cod: Selectaţi tot
<?php
$sql = mysql_query("SELECT * FROM `provoaca`");
echo '<table border="1">';
echo '<tr><td>ID</td><td>Nume Clan</td><td>Nume ClanLeader</td><td>Y! Messenger</td><td>Jucatori disponibili</td><td>Data</td></tr>';
while ($row = mysql_fetch_row($sql)) {
echo '<tr><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td><td>'.$row[3].'</td><td>'.$row[4].'</td><td>'.$row[5].'</td></tr>';
}
echo "</table>";
?>Ce am gresit?