PHP and SQL, How to print multiple columns in the output

Question

i need help for my php script:

This is my index.php:

<?php

error_reporting(E_ALL); ini_set('display_errors', 1);

$db_hostname = '127.0.0.1';
$db_username = 'root';
$db_password = 'password';
$db_database = 'mydatabase';


    $connect = mysqli_connect("$db_hostname","$db_username","$db_password");

    if (!$connect){

           die('Could not connect: ' . mysqli_error());
        
        }

    
    mysqli_select_db($connect, $db_database) or die ("could not find db");


    $output ='';



    if (isset ($_POST['search'])){

     $search = $_POST['search'];

   }


    $query = mysqli_query($connect, "SELECT * FROM user WHERE email LIKE '%$searchq%'") or die("could not search");

    $count = mysqli_num_rows($query);

    
    if($count == 0){

     $output = 'There was no search results !';

   }

    
    else{

         while($row = mysqli_fetch_array($query)){
         $fname = $row['email'];
         $output .='<div> '.$fname.'</div>';}

        }  


?>

<!DOCTYPE html>
<html lang="en">
  <head>
      <meta charset=utf-8" />
      <title>Lookup</title>
  </head>
  <body>

<form action="index.php" method="post">
<input type="text" placeholder="search" name="search">
<input type="submit" value=">>"/>

</form>



<?php

print("$output"); 

?>

  </body>
</html>

So the script works and its return me email from email column where my string is found.
But i have another question, i have another column beside my email column named location, and every email correspond to a location value. So i want to see 2 columns on my OUTPUT.

This is example an of my columns:

| email | location |

| [email protected] | Chicago |

| [email protected] | Mexico |

So this is what result i actually see on my index.php:[email protected] [email protected] [email protected] [email protected]

And this is what i want to see:[email protected] Tokyo [email protected] London [email protected] Paris [email protected] New-York

Thanks for your help.

$row['location']

Jay Blanchard
– Jay Blanchard

2017-07-11 17:52:09 +00:00
Commented Jul 11, 2017 at 17:52 — Jay Blanchard
– Jay Blanchard, Commented Jul 11, 2017 at 17:52

Jacobm001 · Accepted Answer · 2017-07-11 18:05:13Z

3

You're actually pretty close to what you want already. The key is in your while loop.

while($row = mysqli_fetch_array($query)){
    $fname = $row['email'];
    $loc   = $row['location'];
    $output .='<div>' . $fname . ' ' . $loc . '</div>';
}

The $row variable will contain an entry for every column you select in your query. You're using a select * in your query, so you may or may not realize all that's in there. If you want to see the contents, you might find var_dump($row); to be helpful for testing.

edited Jul 11, 2017 at 18:05

answered Jul 11, 2017 at 17:52

Jacobm001

4,5595 gold badges32 silver badges52 bronze badges

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

1 Comment

Harpreet Singh Over a year ago

use $row['location]; as $row['location']; see single quote missing

Harpreet Singh · Accepted Answer · 2017-07-11 17:54:16Z

1

Your else part should be:-

else{

     while($row = mysqli_fetch_array($query)){
     $fname_location = $row['email']."  ".$row['location'];
     $output .='<div> '.$fname_location .'</div>';}

    }

answered Jul 11, 2017 at 17:54

Harpreet Singh

9779 silver badges21 bronze badges

Comments

yardie · Accepted Answer · 2017-07-11 18:07:52Z

0

Change this part:

else{

     while($row = mysqli_fetch_array($query)){
     $fname = $row['email'];
     $output .='<div> '.$fname.'</div>';}

    }

To this:

else{

     while($row = mysqli_fetch_array($query)){
     $fname = $row['email'];
     $ulocation = $row['location '];
     $output .='<div> '.$fname . ' ' . $ulocation.'</div>';}

    }

edited Jul 11, 2017 at 18:07

answered Jul 11, 2017 at 17:52

yardie

1,5671 gold badge14 silver badges29 bronze badges

1 Comment

Harpreet Singh Over a year ago

missing dot . between php variables in output variable

Roshana Pitigala · Accepted Answer · 2017-07-26 05:13:52Z

0

Set another variable $location to receive the location data from db just like you set the $fname

 while($row = mysqli_fetch_array($query)){
     $fname = $row['email'];
     $location = $row['location'];
     $output .='<div> '.$fname . ' ' . $location.'</div>';
 }

edited Jul 26, 2017 at 5:13

Roshana Pitigala

8,8569 gold badges53 silver badges87 bronze badges

answered Jul 16, 2017 at 12:30

staynjokede

971 silver badge10 bronze badges

Collectives™ on Stack Overflow

PHP and SQL, How to print multiple columns in the output

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related