Populate PHP Array With Results of MySqlI Query

Question

I am trying to create a php array that holds all fields and rows of the mysql query that is executed. I have tried the below syntax, but when I do a echo nothing is displayed.

<?php
$con=mysqli_connect("server", "user", "pass", "db");

if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$sql="SELECT * FROM testTable LIMIT 10";
$result = mysqli_query($con,$sql);


foreach($array as $index => $value){
    echo "<p>\$index: {$index}; \$value: {$value[0]}</p>";
   var_export($value);
}

mysqli_free_result($result);

mysqli_close($con);
?>```

If I change the foreach loop and use $result instead of $array - it will print on screen 

    $index: 0; $value:

    $index: 1; $value:

And I want the actual elements (or is values the right word) of the array.

What is $array? Surely you meant foreach($result as $index => $value){? You're not doing anything with the result of the query. — Obsidian Age
– Obsidian Age, Commented Jul 28, 2019 at 22:11
if I use $result it prints on screen $index: 0; $value: $index: 1; $value: - I want the actual values — HotTomales
– HotTomales, Commented Jul 28, 2019 at 22:14
@cotton - are saying I'll have to iterate each of the fields returned from the select statement in the print statement? — HotTomales
– HotTomales, Commented Jul 29, 2019 at 0:35

Jerome · Accepted Answer · 2019-07-29 01:09:15Z

1

Okay, following on from your edit and what Obsidian said. Your loop is now correct you just need to update your echo now. Try this and let me know the result:

foreach($result as $index => $value){
    echo "<p>\$index: " . $index . "; \$value: " . $value . "</p>";
    var_export($value);
}

Okay, all good. The $value is just an array. Try this instead:

foreach($result as $index => $value){
    echo "<p>\$index: " . $index . "; \$value: "; print_r($value);  echo "</p>";
    var_export($value);
}

edited Jul 29, 2019 at 1:09

answered Jul 29, 2019 at 0:53

Jerome

8841 gold badge12 silver badges38 bronze badges

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

4 Comments

HotTomales Over a year ago

Hi - this outputs the below

php $index: 0; $value: Array  array ( 'salesman' => 'Bob Jones', 'NumberOfSales' => '1', 'MonthSales' => '0.000000', 'LastMOnth' => '0.000000', 'TwoMonths' => '0.000000', ) ?>

so it seems the var_export works but the echo does not

Jerome Over a year ago

@HotTomales I've updated my answer. Check if that works.

HotTomales Over a year ago

YES! That is exactly what I was after. Thank you so much!

Jerome Over a year ago

No problem. Happy to help :-)

Collectives™ on Stack Overflow

Populate PHP Array With Results of MySqlI Query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related