Multiple rows to one item in PHP array

Question

I have some PHP that retrieves data from a database table and populates an array depending on a query.

I want to merge two fields together, they are 'organisation' and 'full address' and store this in one item under 'ADDRESS'. How can I add both rows together?

I have tried 'ADDRESS' => $row['organisation'] + $row['full_address'], but I don't think I am looking along the correct lines.

    <?php

if (isset($_GET['query'])) {
    // Connect to our database
    $conn = pg_connect("host=myhost port=myport dbname=mydb user=myuser password=mypass");

    // Retrieve the query
    $query = $_GET['query'];

    // Search the database for all similar items
    $sql = pg_query($conn, "SELECT * FROM addresses.llpg_basic WHERE (lpi_logical_status_desc = 'Approved / Preferred LPI' OR lpi_logical_status_desc = 'Provisional LPI') AND full_address ILIKE '%{$query}%'");
    $array = array();

    while ($row = pg_fetch_array($sql)) {
        $address = array(
        'ADDRESS' => $row['full_address'],
        'POSTCODE' => $row['postcode'],
        'UPRN' => $row['uprn'],
        'USRN' => $row['usrn'],
        'X' => $row['xref'],
        'Y' => $row['yref']
        );
        array_push($array, $address);
    }

    sort($array);

    $jsonstring = json_encode($array);

    // Return the json array
    echo $jsonstring;
}

?>

have you tried 'ADDRESS' => $row['organisation'] .$row['full_address'], — Sahil Gulati
– Sahil Gulati, Commented May 2, 2017 at 12:03
Maybe at 'ADDRESS' => $row['organisation'] + $row['full_address'] you mean to try use 'ADDRESS' => $row['organisation'] . ' ' . $row['full_address']. the . is the concatenate operator. — alistaircol
– alistaircol, Commented May 2, 2017 at 12:03

hassan · Accepted Answer · 2017-05-02 13:12:39Z

2

you can concatenate your columns :

$sql = pg_query($conn, "SELECT *, full_address || ',' || organisation AS concatenated_string FROM addresses.llpg_basic  WHERE (lpi_logical_status_desc = 'Approved / Preferred LPI' OR lpi_logical_status_desc = 'Provisional LPI') AND full_address ILIKE '%{$query}%");

or using concat function :

$sql = pg_query($conn, "SELECT *, concat(full_address,' ', organisation) AS concatenated_string FROM addresses.llpg_basic  WHERE (lpi_logical_status_desc = 'Approved / Preferred LPI' OR lpi_logical_status_desc = 'Provisional LPI') AND full_address ILIKE '%{$query}%");

after that you may access your concatenated string as :

'ADDRESS' => $row['concatenated_string'],

Either, if you need to concatenate strings in php you need to use periods instead of plus

'ADDRESS' => $row['organisation'] . $row['full_address'],

edited May 2, 2017 at 13:12

answered May 2, 2017 at 12:04

hassan

8,3282 gold badges28 silver badges40 bronze badges

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

Comments

Eggsalad · Accepted Answer · 2017-05-02 12:04:24Z

0

How about this?

'ADDRESS' => $row['organisation'] . "\n" . $row['full_address'],

answered May 2, 2017 at 12:04

Eggsalad

3832 silver badges9 bronze badges

Comments

Dipanwita Kundu · Accepted Answer · 2017-05-02 12:13:21Z

0

Try to modify your query like this:

`$sql = pg_query($conn, "SELECT *, concat(organisation,", ",full_address) myfull_address FROM addresses.llpg_basic WHERE (lpi_logical_status_desc = 'Approved / Preferred LPI' OR lpi_logical_status_desc = 'Provisional LPI') AND full_address ILIKE '%{$query}%'");`

answered May 2, 2017 at 12:13

Dipanwita Kundu

1,6451 gold badge10 silver badges14 bronze badges

Collectives™ on Stack Overflow

Multiple rows to one item in PHP array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related