~ PDO @ php ~

| php | No Comments

get assoc array from db ONLY

$rtn= $query->fetchAll(PDO::FETCH_ASSOC);
Array
(
    [hmvID] => 1
    [insertDate] => 2016-03-16 15:18:53
    [requestType] => EAN
    [requestData] => 4547557009859
    [requestDate] => 2016-03-16 17:45:38
    [status] => 1
    [type] => CD
    [title] => ジレンマ(期間生産限定盤)(アニメ盤)
    [artist] => ecosystem
    [ReleaseDate] => 2011-11-30
    [sPhoto] => http://ecx.images-amazon.com/images/I/512THFU3PrL._SL75_.jpg
    [XLPhoto] => http://ecx.images-amazon.com/images/I/512THFU3PrL.jpg
    [ListPrice] => ¥ 1,337
    [LowestNewPrice] => ¥ 570
    [ASIN] => B005OCSU7Y
    [EAN] => 4547557009859
    [SeikodoProductCode] => 
    [DetailPageURL] => http://www.amazon.co.jp/%E3%82%B8%E3%83%AC%E3%83%B3%E3%83%9E-%E6%9C%9F%E9%96%93%E7%94%9F%E7%94%A3%E9%99%90%E5%AE%9A%E7%9B%A4-%E3%82%A2%E3%83%8B%E3%83%A1%E7%9B%A4-ecosystem/dp/B005OCSU7Y%3FSubscriptionId%3DAKIAIMFGLRVRLCPPHX7A%26tag%3Dpuiconnie-22%26linkCo
    [currentStorage] => 房間貓柱CD櫃
    [tag] => 銀魂
)

get assoc and int array from db

$rtn= $query->fetchAll();
Array
(
    [hmvID] => 1
    [0] => 1
    [insertDate] => 2016-03-16 15:18:53
    [1] => 2016-03-16 15:18:53
    [requestType] => EAN
    [2] => EAN
    [requestData] => 4547557009859
    [3] => 4547557009859
    [requestDate] => 2016-03-16 17:45:38
    [4] => 2016-03-16 17:45:38
    [status] => 1
    [5] => 1
    [type] => CD
    [6] => CD
    [title] => ジレンマ(期間生産限定盤)(アニメ盤)
    [7] => ジレンマ(期間生産限定盤)(アニメ盤)
    [artist] => ecosystem
    [8] => ecosystem
    [ReleaseDate] => 2011-11-30
    [9] => 2011-11-30
    [sPhoto] => http://ecx.images-amazon.com/images/I/512THFU3PrL._SL75_.jpg
    [10] => http://ecx.images-amazon.com/images/I/512THFU3PrL._SL75_.jpg
    [XLPhoto] => http://ecx.images-amazon.com/images/I/512THFU3PrL.jpg
    [11] => http://ecx.images-amazon.com/images/I/512THFU3PrL.jpg
    [ListPrice] => ¥ 1,337
    [12] => ¥ 1,337
    [LowestNewPrice] => ¥ 570
    [13] => ¥ 570
    [ASIN] => B005OCSU7Y
    [14] => B005OCSU7Y
    [EAN] => 4547557009859
    [15] => 4547557009859
    [SeikodoProductCode] => 
    [16] => 
    [DetailPageURL] => http://www.amazon.co.jp/%E3%82%B8%E3%83%AC%E3%83%B3%E3%83%9E-%E6%9C%9F%E9%96%93%E7%94%9F%E7%94%A3%E9%99%90%E5%AE%9A%E7%9B%A4-%E3%82%A2%E3%83%8B%E3%83%A1%E7%9B%A4-ecosystem/dp/B005OCSU7Y%3FSubscriptionId%3DAKIAIMFGLRVRLCPPHX7A%26tag%3Dpuiconnie-22%26linkCo
    [17] => http://www.amazon.co.jp/%E3%82%B8%E3%83%AC%E3%83%B3%E3%83%9E-%E6%9C%9F%E9%96%93%E7%94%9F%E7%94%A3%E9%99%90%E5%AE%9A%E7%9B%A4-%E3%82%A2%E3%83%8B%E3%83%A1%E7%9B%A4-ecosystem/dp/B005OCSU7Y%3FSubscriptionId%3DAKIAIMFGLRVRLCPPHX7A%26tag%3Dpuiconnie-22%26linkCo
    [currentStorage] => 房間貓柱CD櫃
    [18] => 房間貓柱CD櫃
    [tag] => 銀魂
    [19] => 銀魂
)

 

トラックバック

このブログ記事に対するトラックバックURL:

コメント & トラックバック

No comments yet.

Comment feed

コメントする

Smiley face

August 2018
S M T W T F S
« Jul    
 1234
567891011
12131415161718
19202122232425
262728293031