Обучение/Помощь новичкам | LIKE
Тема закрыта by
Евгений
Причина: Не актульно
Причина: Не актульно
Что не так с запросом?
________
посл. ред. 29.08.2015 в 21:33; всего 1 раз(а); by Евгений
$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 %?% ?
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>
$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>
благодарю :)