English 中文(简体)
我如何将数据库的记录转换成阵列?
原标题:How can I convert record set from database to array?
  • 时间:2011-09-08 02:05:49
  •  标签:
  • php

How can I convert record set from database to array? It has 1 table named: tblproduct, with the following schema:

 product_id | product_name | product_desc | product_price | product_img

在我从数据库中选择数据时,我希望以以下格式填写:

$product_array = array(
  "105" => array( product_id  =>  105 ,  product_name  =>  Blackberry 8900 ,
                  product_desc  =>   ,  product_price  =>  1150.00 ,
                  product_img  =>  products/product5.jpg ),
  "106" => array( product_id  =>  106 ,  product_name  =>  Headphone with mic ,
                  product_desc  =>   ,  product_price => 148.85 , 
                  product_img  =>  products/product8.jpg )
);

最佳做法

最佳回答

假设你正在使用MySQL(你没有具体说明你的房舍管理事务),并且有以下一线:

$result = mysql_query( SELECT * FROM `tblproduct` );

您可以使用:

while($row = mysql_fetch_assoc($result))
    $product_array[$row[ product_id ]] = $row;
问题回答

暂无回答




相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签