php-pdoSelect LIKE query example with PHP PDO

$st = $pdo->prepare('SELECT * FROM test WHERE name LIKE :name');
$st->execute([':name' => '%A%']);
foreach ( $st as $row ) {
  print_r($row);
}ctrl + cgithub

`$pdo->prepare` prepare given query to execute	`$st->execute(` run query on the server
`LIKE :name` use standard named placeholder in `LIKE` query	`%A%` wrap searched value around with `%` or `_` depending on your goals

Usage example

<?php

$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');

$st = $pdo->prepare('SELECT * FROM test WHERE name LIKE :name');
$st->execute([':name' => '%A%']);

foreach ( $st as $row ) {
  print_r($row);
}

output

Array
(
    [id] => 1
    [0] => 1
    [age] => 25
    [1] => 25
    [name] => A
    [2] => A
)

Select with prepared statement in PHP PDO
Select IN array with PHP PDO
Select with prepared statement and bind values in PHP PDO

More of Php Pdo

How to get results after PHP PDO statement execute()
Set charset in PHP PDO
Fetch single column value with PHP PDO
Set execution timeout with PHP PDO
Transaction example with PHP PDO
Get current database name with PHP PDO
How to bind table name in PHP PDO
Commit transaction in PHP PDO
How to install PHP PDO for Mysql in Ubuntu 22.04
Bind current datetime with PHP PDO

See more codes...

php-pdoSelect LIKE query example with PHP PDO

Usage example

output

Related

More of Php Pdo