Config Router

  • Google Sheets
  • CCNA Online training
    • CCNA
  • CISCO Lab Guides
    • CCNA Security Lab Manual With Solutions
    • CCNP Route Lab Manual with Solutions
    • CCNP Switch Lab Manual with Solutions
  • Juniper
  • Linux
  • DevOps Tutorials
  • Python Array
You are here: Home / Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]

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

August 23, 2021 by James Palmer

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.

the mysqli_queryexcepts 2 parameters , first variable is mysqli_connectequivalent variable , second one is the query you have provided
$name1 = mysqli_connect(localhost,tdoylex1_dork,dorkk,tdoylex1_dork);

$name2 = mysqli_query($name1,”SELECT name FROM users ORDER BY RAND() LIMIT 1”);

Related

Filed Under: Uncategorized

Recent Posts

  • How do I give user access to Jenkins?
  • What is docker volume command?
  • What is the date format in Unix?
  • What is the difference between ARG and ENV Docker?
  • What is rsync command Linux?
  • How to Add Music to Snapchat 2021 Android? | How to Search, Add, Share Songs on Snapchat Story?
  • How to Enable Snapchat Notifications for Android & iPhone? | Steps to Turn on Snapchat Bitmoji Notification
  • Easy Methods to Fix Snapchat Camera Not Working Black Screen Issue | Reasons & Troubleshooting Tips to Solve Snapchat Camera Problems
  • Detailed Procedure for How to Update Snapchat on iOS 14 for Free
  • What is Snapchat Spotlight Feature? How to Make a Spotlight on Snapchat?
  • Snapchat Hack Tutorial 2021: Can I hack a Snapchat Account without them knowing?

Copyright © 2025 · News Pro Theme on Genesis Framework · WordPress · Log in