turning concatenate strings into one single string as a variable in php

Question

I have a form field and would like to check for each input field if it is already exist in database.

Below is my php code:

$sql_query = "SELECT * FROM test_table";
if($result_query = $connect->query($sql_query))
{
    $items = array("firstName", "lastName", "country", "phone");

    //$names variable contains stored values which i've declared at the beginning
    $names = array($firstName, $lastName, $country, $phone);

    foreach(array_combine($items, $names) as $item => $name)
    {
        $array_items = "";
        $check_query = "SELECT $item FROM test_table WHERE $item = '".$name."'";
        $result_check_query = $connect->query($check_query);
        if($row_query = $result_check_query->num_rows)
        {
         $array_items .= $item . ", ";
        }
        echo $array_items . "gettype()=> " . gettype($array_items);
        echo "<br>";
    }
    print_r ( "<br>" . $array_items); 
}

The results from echo $array_items is as below:

The problem is when i print/echo out $array_items outside foreach loop, it only gets phone

how can i get all the individual strings as one and assigned it to a variable in php?

thanks in advance.

if there're link to old post, please provide me the link. i do not know the term use to search for this kind of problem.

do you want array at the end as a final output (containating group string outputs in seperate indexes)? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Oct 13, 2017 at 6:00

Amit Kumar · Accepted Answer · 2017-10-13 05:54:49Z

1

Please try this code

$sql_query = "SELECT * FROM test_table";
if($result_query = $connect->query($sql_query))
{
    $items = array("firstName", "lastName", "country", "phone");

    //$names variable contains stored values which i've declared at the beginning
    $names = array($firstName, $lastName, $country, $phone);
    $array_items = "";
    foreach(array_combine($items, $names) as $item => $name)
    {

        $check_query = "SELECT $item FROM test_table WHERE $item = '".$name."'";
        $result_check_query = $connect->query($check_query);
        if($row_query = $result_check_query->num_rows)
        {
         $array_items .= $item . ", ";
        }
        echo $array_items . "gettype()=> " . gettype($array_items);
        echo "<br>";
    }
    print_r ( "<br>" . $array_items); 
}

The problem with your code is assignment of $array_items variable in foreach loop. Each time loop execute it set the value to blank ($array_items = "";)

answered Oct 13, 2017 at 5:54

Amit Kumar

4772 silver badges15 bronze badges

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

1 Comment

Charlie HC Over a year ago

Oh my.. thank you very much. how dumb am i to put the initial variable in foreach loop.

Collectives™ on Stack Overflow

turning concatenate strings into one single string as a variable in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related