Dakle imam 3 fajla.
prvi fajl je html forma
<html?
<body>
<form action="insert.php" method="post">
Ime i prezime: <input type="text" name="imeprezime" />
Telefon: <input type="text" name="telefon" />
Godine: <input type="text" name="godine" />
<input type="submit" />
</form>
</body>
</html>
dugi fajl je insert.php koji kreira bazu i tabelu, i ubacuje podatke iz html
<html>
<body>
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Ne moze se konektrovati: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE baza",$con))
{
echo "Baza je kreirana";
}
else
{
echo "Greska pri kreiranju: " . mysql_error();
}
mysql_close($con);
mysql_select_db("baza", $con);
$sql = "CREATE TABLE Zadrugari
(
ImePrezime varchar(15),
Telefon varchar(15),
Godine int
)";
mysql_query($sql,$con);
mysql_close($con);
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("baza", $con);
$sql="INSERT INTO Zadrugari (ImePrezime, Telefon, Godine)
VALUES
('$_POST[imeprezime]','$_POST[telefon]','$_POST[godine]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>
</body>
</html>
treci fajl je baza.php koji sluzi za citanje/pregled baze
<html>
<body>
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("baza", $con);
$result = mysql_query("SELECT * FROM Zadrugari");
echo "<table border='1'>
<tr>
<th>Ime i Prezime</th>
<th>Telefon</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['ImePrezime'] . "</td>";
echo "<td>" . $row['Telefon'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
</body>
</html>
Nisam pravio nikakve baze preko fantastica ili ne znam cega, samo sam napravio ova 3 fajla i uploadovao ih, btw greska koju mi izbaci glasi
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'peter'@'localhost' (using password: YES) in /home/gosevski/public_html/baza/insert.php on line 11
Ne moze se konektrovati: Access denied for user 'peter'@'localhost' (using password: YES)
Unapred Hvala,
Aleksandar