Loading...
Что не так с запросом?

$sql = $db->prepare('SELECT * FROM `res` WHERE `key` LIKE ?' ) ;
$sql -> execute([$text]);
$sql = $sql -> fetchAll();

________
посл. ред. 29.08.2015 в 21:33; всего 1 раз(а); by Евгений
* вместо смайла -> )
Евгений , SELECT * FROM `res` WHERE `key` LIKE '%". $_REQUEST['search'] ."%'
RezzidenT , а через плейсхолдеры?
LIKE %?% ?
http://phpfaq.ru/faq#like
Евгений , Result:
$sql = $db-
^ ^
syntax error: $ sql = $ db
correction: db
syntax error: -
> prepare
correction: : BEGIN prepare
>prepare
('SELECT * FROM `res` WHERE `key` LIKE ?' ;
^ ^
syntax error: ( 'SELECT * FROM `res` WHERE `key`...
correction: 'SELECT * FROM `res` WHERE `key`...
syntax error: ;
correction: FROM <string literal> ;
$sql -> execute
^
syntax error: $ sql -
> execute
correction: execute
([$text]);
^ ^
syntax error: ( [ $ text
correction: text
syntax error: ] ) ;
correction: ;
$sql = $sql -
^
syntax error: $ sql = $ sql -
> fetchAll
correction: fetchAll
> fetchAll();
^
syntax error: ( ) ;
correction: : BEGIN END ;
^
syntax error: <end>
expected: <ascii identifier> <delimited identifier> <identifier>
<unicode identifier> ALLOCATE ALTER BEGIN CALL CASE CLOSE COMMIT
CONNECT CREATE DEALLOCATE DELETE DESCRIBE DISCONNECT DROP END
EXECUTE FETCH FOR FREE GET GRANT HOLD IF INSERT ITERATE LEAVE
LOOP MERGE OPEN PREPARE RELEASE REPEAT RESIGNAL RETURN REVOKE
ROLLBACK SAVEPOINT SELECT SET SIGNAL START UPDATE WHILE
correction: END <end>
Mobiaaa (29.08.2015 в 21:54)
http://phpfaq.ru/faq#like

благодарю :)
Онлайн: 6
Время:
Gen. 0.0997
(c) Bym.Guru 2010-2026