C
C
Carlyndow Marlifi2021-06-25 21:56:58
PHP
Carlyndow Marlifi, 2021-06-25 21:56:58

How to make a fetch in prepared PDO queries?

I use PDO

$base = new PDO($dsn, $db_user, $db_pass, $opt);
$base -> query("SET NAMES 'UTF8'"); 

  function acc($sql, $params = array()) {
    global $base;
    $stmt = $base -> prepare($sql);
    $stmt -> execute($params);
    $stmt = $stmt->FetchAll(PDO::FETCH_ASSOC);
    return $stmt;
  } 
$result= acc("SELECT * FROM `name` WHERE `article` LIKE '%$article%' AND `article2` LIKE '%$article2%'"); // надо выполнить запрос такого типа, но этот вариант опасный
$result= acc("SELECT * FROM `name` WHERE `article` LIKE ? AND `article2` LIKE ?", array('%$article%','%$article2%')); //пробовал так, но - облом

In general, I need to make such a request, but through prepared expressions. Tell me how to do it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
C
Carlindow Murleafy, 2021-06-26
@petushok55

FanatPHP has already helped

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question