Får även upp detta felmeddelandet när jag kör post_comment.php som jag inte begriper:
Fatal error: Call to a member function bind_param() on boolean in /storage/content/41/116941/php.kitas.se/public_html/post_comment.php on line 27
Någon som förstår?
post_comment.php
Kod: Markera allt
<?php
$servernamn = "10.209.1.164";
$anv= "116941_jd93933";
$pass= "*****";
$db= "116941-php";
if(!$conn = mysqli_connect($servernamn, $anv, $pass, $db)){
die("Kunde inte ansluta till databasen");
}
mysqli_select_db($conn,"116941-php");
$name = $_POST["name"];
$comment = $_POST["comment"];
$comment_length =mb_strlen($comment, "UTF-8");
if($comment_lenght > 100)
{
header("location: index.php?error=1");
}
else
{
$sql = "INSERT INTO comments namn, kommentar VALUES (?,?)";
$stmt = $conn-> prepare($sql);
$stmt-> bind_param("ss", $name, $comment);
$stmt-> execute();
$stmt-> close();
header("location: index.php");
}
?>
Kod: Markera allt
<html>
<h1>Comment</h1>
</html>
<?php
$servernamn = "10.209.1.164";
$anv= "116941_jd93933";
$pass= "*******";
$db= "116941-php";
if($conn = mysqli_connect($servernamn, $anv, $pass, $db))
{
echo "Ansluten till databasen";
}
else
{
die("Ej ansluten: " . $conn-> connect_error);
}
$conn->select_db("comments");
$sql = "SELECT * FROM comments";
if(!$find_comments = $conn-> query($sql))
{
die("Fel, kontrollera SQL: ".$sql);
}
while ($row = $find_comments->fetch_assoc())
{
$comment_name = $row['name'];
$comment = $row['comment'];
echo "<p>$comment_name - $comment</p>";
}
if(isset($_GET['error']))
{
echo "";
}
?>
<html>
<form action="post_comment.php" method="POST">
<input type="text" name="name" value="Your Name"><br>
<textarea name="comment" cols="50" rows="2">Enter a comment</textarea>
<input type="submit" value="Comment">
</form>
</html>