Issue looping through database and showing results php

Question

I am trying to loop through my database and then shown all user names. Unfortunately I have tried many different ways but can not get it to work. I am currently trying this

  <?php  
   $result= mysqli_query("SELECT * FROM users");
 while($userRow = mysqli_fetch_array($result)){
      echo $userRow['user_name'];
 }
 ?>

The issue is that I am getting this error and can not work out how to get this working. Warning: mysqli_query() expects at least 2 parameters, 1 given

I am able to show a single row using

<?php print($userRow['user_name']); ?>

But I can not work out how to loop through every user in my 'user' table

give connection object as a first parameter

Sugumar Venkatesan
– Sugumar Venkatesan

2015-12-10 06:48:57 +00:00
Commented Dec 10, 2015 at 6:48 — Sugumar Venkatesan
– Sugumar Venkatesan, Commented Dec 10, 2015 at 6:48

Sadikhasan · Accepted Answer · 2015-12-10 06:49:32Z

1

You have to pass first argument as Connection object you have to pass in mysqli_query() function.

mysqli_query($con,"SELECT * FROM users");

Reference

answered Dec 10, 2015 at 6:49

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sugumar Venkatesan · Accepted Answer · 2015-12-10 06:51:21Z

0

you have first create link like this

$link = mysqli_connect("localhost", "my_user", "my_password", "world");

and then you have use the link to query the database like this

$result= mysqli_query($link, "SELECT * FROM users");

answered Dec 10, 2015 at 6:51

Sugumar Venkatesan

4,04410 gold badges49 silver badges83 bronze badges

Collectives™ on Stack Overflow

Issue looping through database and showing results php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related