为什么我的mysqli语句不适用于flex 4.5？

Question

hi there i'm working with flex 4.5 and php, i have a services php file with a query that is actually workink this query retreives an specific product info. but when i want to get the statement with like?% is not working here is the working code

public function getProductsByName2($searchStr) {
     $stmt = mysqli_prepare($this->connection,
          "SELECT
              products.id,
              products.codb,
              products.nombre,
              products.precio,
              products.cantidad
           FROM products where products.nombre LIKE ?");
      $this->throwExceptionOnError();


      mysqli_stmt_bind_param($stmt, 's', $searchStr);

this code actually works gets an specific product information but must match exactly the name , if i want to retrieve all names starting with "c" for example i should have something like this

public function getProductsByName2($searchStr) {
     $stmt = mysqli_prepare($this->connection,
          "SELECT
              products.id,
              products.codb,
              products.nombre,
              products.precio,
              products.cantidad
           FROM products where products.nombre LIKE CONCAT('%',?,'%')");
      $this->throwExceptionOnError();


      mysqli_stmt_bind_param($stmt, 's', $searchStr);

but somehow is not working please any help is appreciated

Answer 1

I have never seen the "%" added with MYSQL's CONCAT-Method. Rather, I'd add the % within the PHP scope - so:

// ...
FROM products where products.nombre LIKE ?");
// ...
mysqli_stmt_bind_param($stmt, 's', '%' . $searchStr . '%');

Hope this helps.