Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]

by

The issue is that you’re not saving the mysqli connection. Change your connect to:

$aVar = mysqli_connect('localhost','tdoylex1_dork','dorkk','tdoylex1_dork');

And then include it in your query:

$query1 = mysqli_query($aVar, "SELECT name1 FROM users
    ORDER BY RAND()
    LIMIT 1");
$aName1 = mysqli_fetch_assoc($query1);
$name1 = $aName1['name1'];

Also don’t forget to enclose your connections variables as strings as I have above. This is what’s causing the error but you’re using the function wrong, mysqli_query returns a query object but to get the data out of this you need to use something like mysqli_fetch_assoc http://php.net/manual/en/mysqli-result.fetch-assoc.php to actually get the data out into a variable as I have above.

More Related Contents:

  1. inserting information and image in php and mysql
  2. Call to undefined method mysqli_stmt::get_result
  3. How to display errors for my MySQLi query? [duplicate]
  4. Bind multiple parameters into mysqli query
  5. How can I with mysqli make a query with LIKE and get all results?
  6. When should I use MySQLi instead of MySQL?
  7. Fatal error: Call to a member function fetch_assoc() on a non-object [duplicate]
  8. MySQLi equivalent of mysql_result()?
  9. How to fix Trying to access array offset on value of type null error
  10. How to convert mysqli result to JSON? [duplicate]
  11. mysqli_fetch_array while loop columns
  12. How to bind an array of strings with mysqli prepared statement?
  13. How can I use mysqli_fetch_array() twice?
  14. Warning: mysqli_error() expects exactly 1 parameter, 0 given error
  15. Executing mysqli_query inside a function
  16. using nulls in a mysqli prepared statement
  17. Can’t return a result set in the given context
  18. store_result() and get_result() in mysql returns false
  19. How to prepare statement for update query? [duplicate]
  20. Checking if mysqli_query returned any values?
  21. Warning: mysqli_query() expects parameter 1 to be mysqli, string given in
  22. How can I bind an array of strings with a mysqli prepared statement?
  23. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  24. Fatal error: Call to undefined method mysqli_result::fetch_all()
  25. How to run the bind_param() statement in PHP?
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. Call to undefined method mysqli_result::fetch()
  28. Which is fastest in PHP- MySQL or MySQLi?
  29. Create mysql trigger via PHP?
  30. Cannot figure out how to run a mysqli_multi_query and use the results from the last query

Leave a Comment