PHP make Array from MYSQL

Question

i working on Authorize.net gateway i need to create below array for itemized bill

$sql= "select *  from shop where cusid = '1'";
 $sqlexc= mysql_query($sql) or die(mysql_error());

$line_items = array();
while ($title = mysql_fetch_array($sqlexc)) {
    $line_items[] = ('Coupon',' $title[6]', '1', '0.99', 'Y');
}

how to create below kind of array

/*    $line_items = array(
    "Coupon1','description','2','10.99','Y'",
    "Coupon2','description','2','10.99','Y'",
    "Coupon3','description','2','10.99','Y'",);*/

You may want to re-read the array you want to output, don't think that's what you mean. — Duniyadnd
– Duniyadnd, Commented Jun 30, 2012 at 2:43
Your array doesn't make sense. What are your double quotes, single quotes and commas mean? Is this an array of strings? Or is this an array of objects that contain 4 properties? — robonerd
– robonerd, Commented Jun 30, 2012 at 2:47

Kris · Accepted Answer · 2012-06-30 03:04:26Z

0

uh.. if you want it to be exactly the same...

$i=0;
$line_items = array();   
while ($title = mysql_fetch_array($sqlexc)) {
    $line_items[] = "Coupon" . ++$i . "', '" . $title[6] . "', '2', '10.99', 'Y'";
}

However I would use mysql_fetch_assoc over mysql_fetch_array (actually I would switch to PDO as mysql is deprecated)

edited Jun 30, 2012 at 3:04

answered Jun 30, 2012 at 2:50

Kris

6,1222 gold badges33 silver badges46 bronze badges

how to add comma to the last records like $line_items = array( "Coupon1','description','2','10.99','Y'", "Coupon2','description','2','10.99','Y'", "Coupon3','description','2','10.99','Y'",);

mahe
– mahe

06/30/2012 04:36:57
Commented Jun 30, 2012 at 4:36
You don't need one.. That is purely optional. Look at php.net/manual/en/language.types.array.php Look at "The comma after the last array element is optional and can be omitted."

Kris
– Kris

06/30/2012 04:49:28
Commented Jun 30, 2012 at 4:49

Add a comment |

gittirat · Accepted Answer · 2012-06-30 04:03:06Z

0

$line_items = array();
while ($title = mysql_fetch_array($sqlexc)) {
    $line_items[] = $title;
}
foreach ($line_items as $row){
    echo $row[0]." ".$row[1]." ".$row[2]." ".$row[3]."<br>";
}

answered Jun 30, 2012 at 4:03

gittirat

1

Add a comment |

Collectives™ on Stack Overflow

PHP make Array from MYSQL

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related