Create a dynamic mysql query using php variables

by

Just check if the variables contain a value and if they do, build the query like so:

$sql = [];
$parameters = [];
    
if ($stationFilter) {
    $sql[] = " STATION_NETWORK = ?";
    $parameters[] = $stationFilter;
}
if ($verticalFilter) {
    $sql[] = " VERTICAL = ?";
    $parameters[] = $verticalFilter;
}

$query = "SELECT * FROM tableName";

if ($sql) {
    $query .= ' WHERE ' . implode(' AND ', $sql);
}
$stmt = $mysqli->prepare($query);

if ($parameters) {
    $stmt->bind_param(str_repeat('s', count($array), ...$parameters);
}
$stmt->execute();
$result = $stmt->get_result();
$data = $result->fetch_all(MYSQLI_ASSOC);

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Save the data into a database and return another value from database using PHP
  4. Problame with files on SQL
  5. Im trying to create some temporary tables in mysql using php
  6. How to include a PHP variable inside a MySQL statement
  7. How can I do ‘insert if not exists’ in MySQL?
  8. How to apply bindValue method in LIMIT clause?
  9. Can I parameterize the table name in a prepared statement?
  10. Getting raw SQL query string from PDO prepared statements
  11. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  12. MySQL Prepared statements with a variable size variable list
  13. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  14. PDO with INSERT INTO through prepared statements [closed]
  15. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  16. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  17. Comma separated values in MySQL “IN” clause
  18. Doing a while / loop to get 10 random results
  19. Do SQL connections opened with PDO in PHP have to be closed
  20. MYSQL Select from tables based on multiple rows
  21. How to execute raw queries with Laravel 5.1?
  22. How to convert ISO8601 to Date format in php
  23. How do you do multiple SQL statements in one mysql_query?
  24. MySQL/SQL retrieve first 40 characters of a text field?
  25. how do I get month from date in mysql
  26. php/mysql zip code proximity search
  27. Updating column so that it contains the row position
  28. Aggregated query without GROUP BY
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment