Passing a regular expression to the ? variable in mysqli php

Asked Mar 28 '17 at 03:30

Active Mar 28 '17 at 03:30

Viewed 20 times

Making a php webpage which queries data based on variables in a form using a prepared statement and I want the prepared statement to include a wildcard to just dump all records if no input is given:

if (!($stmt = $conn->prepare("SELECT * FROM wan_equipment WHERE EQUIP_CND LIKE ?"))) {
    echo "Prepare failed: (" . $conn->errno . ") " . $conn->error;
}

So if the value '*' is bound, I want the SQL to select all records, but if I bind like so:

if(isset($_POST['tagfilter'])) {$tft = $_POST['tagfilter'];} else {$tft = '*' ;}
if (!$stmt->bind_param('s', $tft)) {
    echo "Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error;
}

Then make a variable dump of the result, I get an empty array instead of a full dump.

What variable can I pass as $tft in order to make the SQL select all?

asked Mar 28 '17 at 03:30

user2727391

1

Have you tried to use the SQL wildcard `%` instead of `*`? – segFault Mar 28 '17 at 03:35
2

That did it, herpity derpity wrong wild card. Thanks for pointing that out! – user2727391 Mar 28 '17 at 03:44
Or you'd have to use `regexp` in place of `like` and `.*`. – chris85 Mar 28 '17 at 04:00

Passing a regular expression to the ? variable in mysqli php

0 Answers0