PHP return array inside a loop

Question

i am creating a function that loops through records and i want to return the array of items

if(!function_exists("TicketAttachments")) {
    function TicketAttachments($update_sequence) {
        global $conn, $pdo_conn;

        $results = array();
        $sql="SELECT * from ticket_updates where ticketnumber = '".$update_sequence."' and type = 'attachment' ";
        $rs=mysql_query($sql,$conn);
        while($result=mysql_fetch_array($rs)) {
            $results["link"] = 'media/ticket_attachments/'.$result["notes"];
            $results["name"] = $result["notes"];
        }

        return $results;
    }
}

i am calling it here:

$attachments = TicketAttachments($TicketUpdate["sequence"]);
foreach($attachments as $att) {
    echo $att["name"];
}

but this is echoing h5 whereas name = 55388-20150929124302-screen dump 28092015.docx

$att["name"]; this line doesn't do anything. did you mean to echo? — FuzzyTree
– FuzzyTree, Commented Sep 29, 2015 at 12:19
check my update - this is how i have it. i had been testing and forgot to add it back in — charlie
– charlie, Commented Sep 29, 2015 at 12:20

savedario · Accepted Answer · 2015-09-29 15:22:50Z

4

I think you need to combine the array

if(!function_exists("TicketAttachments")) {
    function TicketAttachments($update_sequence) {
        global $conn, $pdo_conn;

        $results = array();
        $sql="SELECT * from ticket_updates where ticketnumber = '".$update_sequence."' and type = 'attachment' ";
        $rs=mysql_query($sql,$conn);
        while($result=mysql_fetch_array($rs)) {
            $results[] = array(
                "link"=>'media/ticket_attachments/'.$result["notes"],
                "name" => $result["notes"];
            );
        }
        return $results;
    }
}

edited Sep 29, 2015 at 15:22

savedario

94716 silver badges27 bronze badges

answered Sep 29, 2015 at 12:21

Ajeet Kumar

8151 gold badge7 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

PHP return array inside a loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related