How to display multiple array value in PHP?

Question

I am having an trouble in displaying values in PHP.

Value pass through URL career.php?mode=1,2,3

Here is my code

$id = $_GET['mode']; // Id get from URL
    //echo $id;
    $query = "SELECT `job_title` FROM `job` WHERE `job_id` IN ($id)";
    $res    = mysqli_query($conn, $query);

    foreach(($row = mysqli_fetch_array($res)) as $key1){
          $key[] = $key1;
    }

PHP Code:

<?php echo $key;?>

Hence it is in looping so it shows the last looped value. Is it possible to display the all values through loop.

Help me out guys!!

Create a variable outside (for example: $myArray) the foreach loop, than array_push() the $key1) — node_modules
– node_modules, Commented Jun 29, 2016 at 12:46
If you'd like to see what's in the $key array, you can use print_r($key) — Nick
– Nick, Commented Jun 29, 2016 at 12:47
Yes I have tried with print_r it shows the last loop value only ? — Prashanth
– Prashanth, Commented Jun 29, 2016 at 12:55

Peter · Accepted Answer · 2016-06-29 13:12:26Z

2

You have multiple options to output an array.

Echo and foreach

You c an loop through your array and echo each $key and $value

foreach ($keys as $key => $value) {
    echo $key." : ".$value."<br />";
}

print_r and var_dump

This is mostly used in debugging.

print_r($keys);

var_dump($keys);

Imploding

You can implode your array to echo the concatted values.

// The first parameter is the devider or separator
echo implode('', $keys);

Is it possible to display more than one value from the column?

Yes, ofcourse. Look at the following example:

foreach ($keys as $value) {
    echo $value['columnone'];
    echo $value['columntwo'];
    echo $value['columnthree'];
}

Resources

edited Jun 29, 2016 at 13:12

answered Jun 29, 2016 at 12:50

Peter

9,1868 gold badges69 silver badges100 bronze badges

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

1 Comment

Prashanth Over a year ago

Is is possible to display more than one values from the same column?

Saty · Accepted Answer · 2016-06-29 12:59:37Z

1

As your code in open for sql injection you need to use bind and prepare statement . Use while loop to echo your data as

$ids[] = $_GET['mode']; // store it into array
$query = "SELECT `job_title` FROM `job` WHERE `job_id` IN (";
$query .= implode(',', array_fill(0, count($ids), '?'));// bind your param
$query .= ') ';
$stmt = $conn->prepare($query);
call_user_func_array(array($stmt, 'bind_param'), $ids);//Call a callback with an array of parameters
$stmt->execute();
$stmt->bind_result($job_title);// bind result

while ($stmt->fetch()) {// use wlile loop here
    printf("%s\n", $job_title);//echo  result
}

answered Jun 29, 2016 at 12:59

Saty

22.5k7 gold badges35 silver badges52 bronze badges

Comments

Gerard Cuadras · Accepted Answer · 2016-06-29 12:47:54Z

0

You can do something like this:

$mysqli = new mysqli("server", "user", "password", "db");
$id = $_GET['mode'];
$query = "SELECT `job_title` FROM `job` WHERE `job_id` IN ($id)";    
if($res = $mysqli->query($query)){    
    while($obj = $result->fetch_object()){
        echo $obj->job_title;
    }
}
$res->close();

answered Jun 29, 2016 at 12:47

Gerard Cuadras

1,6631 gold badge17 silver badges24 bronze badges

Comments

Adi Azarya · Accepted Answer · 2016-06-29 12:50:38Z

0

Try this:

<?
    $servername = "localhost";
    $username = "yourUSERNAME";
    $password = "yourPASS";
    $dbname = "yourDBNAME";

    $conn = new mysqli($servername, $username, $password, $dbname);

    if ($conn->connect_error) {
         die("Connection failed: " . $conn->connect_error);
         exit();}

        $id = $_GET['mode']; // Id get from URL
            //echo $id;
            $query = "SELECT `job_title` FROM `job` WHERE `job_id`=".$id."";
            $result = $conn->query($sql);
            while($row=$result->fetch_assoc()){ 
           //do something...
            }
     $conn ->close(); 
?>

tip: put your connection on another connection.php file.

like:

require('Connect.php');

answered Jun 29, 2016 at 12:50

Adi Azarya

4,5134 gold badges21 silver badges28 bronze badges

1 Comment

Prashanth Over a year ago

Is is possible to display more than one values from the same column?

gre_gor · Accepted Answer · 2016-06-29 13:11:48Z

-1

$cars = array
  (
  array("Volvo",22,18),

  array("BMW",15,13),

  array("Saab",5,2),

  array("Land Rover",17,15)

  );

for ($row = 0; $row < 4; $row++) {

  echo "<p><b>Row number $row</b></p>";

  echo "<ul>";

  for ($col = 0; $col < 3; $col++) {

    echo "<li>".$cars[$row][$col]."</li>";

  }

  echo "</ul>";

}

edited Jun 29, 2016 at 13:11

gre_gor

6,65812 gold badges104 silver badges105 bronze badges

answered Jun 29, 2016 at 13:02

Ashish Rana

31 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to display multiple array value in PHP?

5 Answers 5

Echo and foreach

print_r and var_dump

Imploding

Is it possible to display more than one value from the column?

Resources

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Echo and foreach

print_r and var_dump

Imploding

Is it possible to display more than one value from the column?

Resources

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related