Willem Massoels Willem Massoels - 1 year ago 64
SQL Question

Retrieve Value of a single column

I need to retrieve data from a single column and put in an API (Json) But for some reason I get the title from the column aswel.

$sql = "SELECT workingJson FROM dataTable";

I assumed it would be like workingJson.Value but no luck.

Here is the API.php


// Create connection

// Check connection
if (mysqli_connect_errno())
echo "Failed to connect to MySQL: " . mysqli_connect_error();

// This SQL statement selects ALL from the table 'Locations'
$sql = "SELECT column1 FROM database";

// Check if there are results
if ($result = mysqli_query($con, $sql))
// If so, then create a results array and a temporary one
// to hold the data
$resultArray = array();
$tempArray = array();

// Loop through each row in the result set
while($row = $result->fetch_object())
// Add each row into our results array
$tempArray = $row;
array_push($resultArray, $tempArray);

// Finally, encode the array to JSON and output the results
echo json_encode($resultArray);

// Close connections

enter image description here

Answer Source

Edit per your comments:

To just return the values and not the keys in PHP, you could change your code to this:

// Loop through each row in the result set
while($row = $result->fetch_object())
    // Add value to array
    array_push($resultArray, $row->column1);

You have no need for $tempArray in this case.