[PDO] SELECT * FROM WHERE

SELECT * FROM WHERE

Bonjour, je suis nouveau sur ce forum, j'ai récemment créer une page php dans laquelle je voudrai afficher les infos de la ligne correspondant je vous laisse mon code ci-dessous,
Je n'arrive pas à trouver l'erreur..

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<?php
    session_start();
    $_SESSION['url'] = $url;
 
    $serveur = "//";
    $dbname = "//";
    $user = "//";
    $pass = "//";
 
  $dsn = "mysql:host=$serveur;dbname=$dbname"; 
 
  $sql = "SELECT * FROM quizz WHERE url = :url ";
  $info=mysqli_fetch_assoc($sql);
 
  try{
   $pdo = new PDO($dsn, $user, $pass);
   $stmt = $pdo->prepare($sql);
   $stmt->bindParam(":url",$url);
 
   $stmt->execute() or die(print_r($stmt->errorInfo()));
 
 
  }catch (PDOException $e){
    echo $e->getMessage();
  }
 
?>
<html>
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<link rel="icon" type="/image/png" href="/images/icon.png" />
<link rel="apple-touch-icon" href="/images/icon.png" />
<meta http-equiv="pragma" content="no-cache" />
<link href="/css/style_reponses.css?t= <? echo time(); ?>" rel="stylesheet" type="text/css">
<title>
 
</title>
</head>
<body>
<?php echo $info['quizz_name'];?>
</body>
</html>

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, string given in LIGNE 13 = "$info=mysqli_fetch_assoc($sql);"

Essaye d'échapper les éléments de ta requête par des guillemets ' ' ou ‘ ‘
genre :
Code:

1 2 $sql = "SELECT * FROM ‘quizz‘ WHERE url = ‘:url ‘";

Code:

1
2
3
4
5
6
7
8
9
10
 
$url = "https://www.google.fr";
 
$pdo = new PDO($dsn, $user, $pass);
$sql = "SELECT * FROM quizz WHERE url = :url ";
$stmt = $pdo->prepare($sql);
$stmt->bindValue('url', $url, PDO::PARAM_STR);
$stmt->execute() or die(print_r($stmt->errorInfo()));
$result = $stmt->fetchAll();
var_dump($result);