[RESOLVED] Array to Variable for Reuse

[scopley]

I'm extremely new to PHP and have run into a bit of a snag. What I am trying to do is run a database query that returns an array. I would like to save the array in a variable so that it can be used in an autosuggest box.

I can echo the array on screen but an unsure on how to save it to a usable variable plus Im getting an Undefined Offset 1 error message on line 25.

function getEmail($conn)
{
	$query = "select EMAIL_ADR from COMMON.EMAILS order by EMAIL_ADR";
	$emailResults = oci_parse($conn, $query);
	oci_execute($emailResults);
	while ($list = oci_fetch_array($emailResults))
	{
		for($i=0; $i<count($list); $i++)
		{
			echo $list[$i] ."<br />"; //line 25

	}
}

}

Any help would be much appreciated!

[halojoy]

This will put all emails into array $emails.
I think it will work

function getEmail($conn)
{
	$query = "select EMAIL_ADR from COMMON.EMAILS order by EMAIL_ADR";
	$emailResults = oci_parse($conn, $query);
	oci_execute($emailResults);

$emails = array();
while ($item = oci_fetch_array($emailResults))
{
    $emails[] = $item; // add this one into array
}
return $emails;

}

///////////


$email_adr = getEmail($conn);

foreach( $email_adr AS $item ){
    echo $item . '<br>';
}

[scopley]

Thanks so much for your response. I'm getting 1190 responses which is the correct number but they all say 'Array'. I'm not getting the values.

[halojoy]

We can better use
$emails[] = $item['EMAIL_ADR']

($emails[] = $item[0] ... will work, too)

So try this:

function getEmail($conn)
{
    $query = "select EMAIL_ADR from COMMON.EMAILS order by EMAIL_ADR";
    $emailResults = oci_parse($conn, $query);
    oci_execute($emailResults);

$emails = array();
while ($item = oci_fetch_array($emailResults)) // loop resulting rows, one by one
{
    $emails[] = $item['EMAIL_ADR']; // add this one into array
}
return $emails;

}

///////////


$email_adr = getEmail($conn);

echo count($email_adr).'<br />';

foreach( $email_adr AS $item ){
    echo $item . '<br>';
} 

[scopley]

THANK YOU SO MUCH! That did the trick. I had been struggling with this for few days now.