SELECT * FROM in MySQLi

by

I could be wrong, but for your question I get the feeling that bind_param() isn’t really the problem here. You always need to define some conditions, be it directly in the query string itself, of using bind_param() to set the ? placeholders. That’s not really an issue.

The problem I had using MySQLi SELECT * queries is the bind_result() part. That’s where it gets interesting. I came across this post from Jeffrey Way: http://jeff-way.com/2009/05/27/tricky-prepared-statements/(This link is no longer active). The script basically loops through the results and returns them as an array — no need to know how many columns there are, and you can still use prepared statements.

In this case it would look something like this:

$stmt = $mysqli->prepare(
  'SELECT * FROM tablename WHERE field1 = ? AND field2 = ?');
$stmt->bind_param('ss', $value, $value2);
$stmt->execute();

Then use the snippet from the site:

$meta = $stmt->result_metadata();

while ($field = $meta->fetch_field()) {
  $parameters[] = &$row[$field->name];
}

call_user_func_array(array($stmt, 'bind_result'), $parameters);

while ($stmt->fetch()) {
  foreach($row as $key => $val) {
    $x[$key] = $val;
  }
  $results[] = $x;
}

And $results now contains all the info from SELECT *. So far I found this to be an ideal solution.

More Related Contents:

  1. Insert Mutiple Record into Database Using Php Mysql
  2. Object of class mysqli_result could not be converted to string
  3. SELECT COUNT(*) AS count – How to use this count
  4. Mysqli update throwing Call to a member function bind_param() error [duplicate]
  5. mysqli bind_param() expected to be a reference, value given
  6. Should I manually check for errors when calling “mysqli_stmt_prepare”?
  7. mysqli_real_escape_string() expects exactly 2 parameters, 1 given
  8. INSERT – Number of bind variables doesn’t match number of fields in prepared statement
  9. Mysql No connection could be made because the target machine actively refused it
  10. How to connect to MySQL database in PHP using mysqli extension?
  11. How do I count query result rows?
  12. Bind Param with array of parameters
  13. How do you use IN clauses with mysqli prepared statements [duplicate]
  14. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  15. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  16. Using wildcards in prepared statement – MySQLi
  17. How to fetch all in assoc array from a prepared statement?
  18. Fatal error: Call to undefined function mysqli_result()
  19. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  20. Why I am getting an error when using w3school tutorial? [duplicate]
  21. Using wildcards in prepared statement
  22. mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
  23. How to remove the fatal error when fetching an assoc array
  24. Fatal error: Call to undefined method mysqli_stmt::get_result()
  25. PHP MySQLi Multiple Inserts
  26. Fatal error: Call to a member function prepare() on a non-object in
  27. Set character set using MySQLi
  28. How do I ensure I caught all errors from MySQLi::multi_query?
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. How to get a list of databases?

Leave a Comment