Sveiki, taigi susidūriau su tokia klaida. Klaida: Kai suvedu visus laukelius, Vardas: asdaddasasd | Žinutė: asdasdasdsddsasd | Man išmeta: "Not database selected", nors esu pasirinkęs per mysql.php failą duomenų bazę, bet vistiek neveikia. Nesuprantu kur klaida. Beje rašiau su viską su DreamWiever. Jei pasakysite kur klaida būsiu dėkingas. Dėkui už dėmesį.
#======================================#
# index.php failas #
#======================================#
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
include("mysql.php");
$sel = "Select * from zinutes ORDER BY data DESC LIMIT 5";
$qq = mysql_query($sel);
$for = mysql_num_rows($qq);
if ($for > 0) {
for ($i=0; $i<$for; ++$i) {
$row = mysql_fetch_assoc($qq);
echo "
".$row['autorius'].": ".$row['zinute']."
>[".date("Y-m-d H:i:s", $row['data'])."]
";
}
} else {
echo "Žinučių nėra.
";
}
echo "
<form action='zinutes.php' method='post'>
Vardas: <input type='text' name='vardas' />
Žinutė: <input type='text' name='zinute' />
<input type='submit' value='Siųsti' />
</form>
";
mysql_close($con);
?>
</body>
</html>
#======================================#
# zinutes.php failas #
#======================================#
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
include("mysql.php");
$vardas = $_POST['vardas'];
$zinute = $_POST['zinute'];
$zinute = htmlspecialchars($zinute);
$er = "";
if (strlen($vardas) < 2) { $er = "Klaida, vardas per trumpas!"; }
elseif (strlen($zinute) < 10) { $er = "Klaida, žinutė per trumpa!";}
else {
mysql_query("INSERT INTO zinutes
(autorius,zinute,data) VALUES
('$vardas','$zinute','".time()."')
") or die(mysql_error());
$er = "";
}
if ($er != "") {
echo $er;
} else {
header("Location: index.php");
}
mysql_close($con);
?>
</body>
</html>
#======================================#
# mysql.php failas #
#======================================#
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
$con = mysql_connect("mysql.hostinger.lt","u718363693_clove","27015852s") or die("Klaida..");
mysql_select_db("zinutes", $con);
?>
</body>
</html>
