Error on my Website someone can help me?

[-Nástý]

I have this error, i don't know why...

Fatal error: Call to a member function bindValue() on a non-object in C:\xampp\htdocs\index.php on line 81


My Code:

 Spoiler

  <?php
                $sql = 'SELECT id, title, text, image, alttext, date FROM news WHERE hot = :hot ORDER BY date DESC LIMIT';
                $qry = $web->prepare($sql);
                $qry->bindValue(':hot', 0);
                $qry->execute();

                while($dat = $qry->fetch(PDO::FETCH_ASSOC))
                {
                    $id = $dat['id'];
                    $title = $dat['title'];
                    $text = $dat['text'];
                    $img = $dat['image'];
                    $imgalt = $dat['alttext'];
                    $date = $dat['date'];

                    if(strlen($text) > 390)
                    {
                        $text = substr($text, 0, 390);
                        $text = $text . "...";
                    }
                    $text = nl2br($text);

                    $date_array = explode("-",$date);
                    $date = $date_array[2].".".$date_array[1].".".$date_array[0];

                    echo 
                    
                    
                    '<li>
                      <div class="image"><a href="./post.php?id='.$id.'"><img alt="'.$imgalt.'" src="./images/news/general/'.$img.'" /></a></div>
                      <div class="info">
                        <h2><a href="./post.php?id='.$id.'">'.$title.'</a></h2>
                        <div class="date_n_author">'.$date.'</div>
                        <p>'.$text.'</p>
                        <a href="./post.php?id='.$id.'" class="read_more2">Read more</a> </div>
                        <div class="clear">
                      </div>
                    </li>';
                }
            ?>

Someone can hep me pls?

[Contra1234]

From where comes $web?

[stotterer09]

#moved

[Legithos]

Originally Posted by -Nástý

$sql = 'SELECT id, title, text, image, alttext, date FROM news WHERE hot = :hot ORDER BY date DESC LIMIT';
$qry = $web->prepare($sql);
$qry->bindValue(':hot', 0);
$qry->execute();

Your error is on bindValue. Try this:

$server   = "mysql:dbname=DBNAME;host=LOCALHOST";
$user = "root";
$pass = "";

$pdo = new PDO($server,$user,$pass);

$stmt = $pdo->prepare("SELECT id, title, text, image, alttext, date FROM news WHERE hot = :hot ORDER BY date DESC LIMIT");
$stmt->execute([
    "hot" => 0
]);

while($dat = $stmt->fetch()){

      $id = $dat['id'];
      $title = $dat['title'];
      $text = $dat['text'];
      $img = $dat['image'];
      $imgalt = $dat['alttext'];
      $date = $dat['date'];


      ... and so on ...

}

?>

You dont need to bind a value with bindValue(), you can do it with ->execute([ "value" => $value ]);

[False]

It seems the variable $web is not a instance of PDO.
Just do a var_dump of that variable and check what happens, also you should remove the ":" on the first bindValue parameter.
You dont have to rewrite the code as Legithos suggested.

[Legithos]

Originally Posted by False

It seems the variable $web is not a instance of PDO.
Just do a var_dump of that variable and check what happens, also you should remove the ":" on the first bindValue parameter.
You dont have to rewrite the code as Legithos suggested.

The ":" are fine if you use named placeholder like he did in this case.

[False]

Originally Posted by Legithos

The ":" are fine if you use named placeholder like he did in this case.

I know, but it also works without ":" which makes the code cleaner