PHP/SQL - Setting SQL Result to a list

Question

I was wondering how to turn a SQL Query into a variable like this one:

$in = "Lambo 1; Trabant 2; Car 3;";

$result=mysqli_query($conn,$sql_query);

The query currently comes back with Lambo 1; Trabant 2; Car 3; but how would I change it into $in? As if I currently run it through another func I getexplode() expects parameter 2 to be string,

Full code:

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
    $host = 'localhost';
    $username = '';
    $password = '';
    $database = '';
    $conn = mysqli_connect($host,$username,$password,$database);

$SteamID = "STEAM_0:0:81010017";
$sql_query="SELECT _Inventory FROM Players Where _SteamID='$SteamID'";

$result=mysqli_query($conn,$sql_query);


$in = $result;
foreach (explode(";", $in) as $element) {
        $element = trim($element);
        if (strpos($element, " ") !== false ) {
                list($car, $number) = explode(" ", $element);
                echo $car;
        }
}


?>

have you tried using mysql_fetch_array() instead of sql_query()? — bMalum
– bMalum, Commented May 22, 2016 at 19:46
see the answers with the hint from my comment - this should work. — bMalum
– bMalum, Commented May 22, 2016 at 19:53

Mantis Support · Accepted Answer · 2016-05-22 19:47:38Z

1

mysqli_query returns false or a mysqli_result object.

You need to add something to actually get the results - either by calling fetch_object, fetch_array, fetch_assoc as shown below:

while ($row = $result->fetch_array()){
    $group_arr[] = $row;
}

answered May 22, 2016 at 19:47

Mantis Support

3442 silver badges6 bronze badges

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

2 Comments

PaulB3434 Over a year ago

Hmm, still doesn't work when using this line of code, still bringing up a HTTP 500 Error

vp_arth Over a year ago

need to add something means not need to use this line of code

Mumen Yassin · Accepted Answer · 2016-05-22 19:47:06Z

0

change your $in variable to:

$in = mysqli_fetch_array($result)[0];

answered May 22, 2016 at 19:47

Mumen Yassin

5121 gold badge4 silver badges16 bronze badges

3 Comments

PaulB3434 Over a year ago

Breaks the code and just displays a HTTP Error 500.

Mumen Yassin Over a year ago

can you var_dump($result)??

PaulB3434 Over a year ago

Thanks, a small typo in the code caused it. Accepting your answer.

Collectives™ on Stack Overflow

PHP/SQL - Setting SQL Result to a list

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related