query, fetch() array[index based query string], by row
3 サンテミリオン 5 メルロー 赤 1997 5800 images/w3.png 辛口 1
6 シャンパン 1 シャルドネ 白 1999 4000 images/w6.png 肉料理も魚料理にあう 1
2 ジュヴレシャンべルタン 4 ピノノワール 赤 1998 3000 images/w2.png 肉料理にあう 1
5 サンセール 7 ソーヴィニヨンブラン 白 2001 2800 images/w5.jpg 有名なドイツワイン 1
1 シャブリ 4 シャルドネ 白 2001 2400 images/w1.jpg 魚料理にあう 1
4 オーメドック 5 カルベネソー 赤 1997 2200 images/w4.png 後味よい 1
Fetch all of the remaining rows in the result set:by the index of colunmn
Array
(
[0] => Array
(
[wineID] => 3
[0] => 3
[name] => サンテミリオン
[1] => サンテミリオン
[locaID] => 5
[2] => 5
[kind] => メルロー
[3] => メルロー
[color] => 赤
[4] => 赤
[vintage] => 1997
[5] => 1997
[price] => 5800
[6] => 5800
[picture] => images/w3.png
[7] => images/w3.png
[comment] => 辛口
[8] => 辛口
[stID] => 1
[9] => 1
)
[1] => Array
(
[wineID] => 6
[0] => 6
[name] => シャンパン
[1] => シャンパン
[locaID] => 1
[2] => 1
[kind] => シャルドネ
[3] => シャルドネ
[color] => 白
[4] => 白
[vintage] => 1999
[5] => 1999
[price] => 4000
[6] => 4000
[picture] => images/w6.png
[7] => images/w6.png
[comment] => 肉料理も魚料理にあう
[8] => 肉料理も魚料理にあう
[stID] => 1
[9] => 1
)
[2] => Array
(
[wineID] => 2
[0] => 2
[name] => ジュヴレシャンべルタン
[1] => ジュヴレシャンべルタン
[locaID] => 4
[2] => 4
[kind] => ピノノワール
[3] => ピノノワール
[color] => 赤
[4] => 赤
[vintage] => 1998
[5] => 1998
[price] => 3000
[6] => 3000
[picture] => images/w2.png
[7] => images/w2.png
[comment] => 肉料理にあう
[8] => 肉料理にあう
[stID] => 1
[9] => 1
)
[3] => Array
(
[wineID] => 5
[0] => 5
[name] => サンセール
[1] => サンセール
[locaID] => 7
[2] => 7
[kind] => ソーヴィニヨンブラン
[3] => ソーヴィニヨンブラン
[color] => 白
[4] => 白
[vintage] => 2001
[5] => 2001
[price] => 2800
[6] => 2800
[picture] => images/w5.jpg
[7] => images/w5.jpg
[comment] => 有名なドイツワイン
[8] => 有名なドイツワイン
[stID] => 1
[9] => 1
)
[4] => Array
(
[wineID] => 1
[0] => 1
[name] => シャブリ
[1] => シャブリ
[locaID] => 4
[2] => 4
[kind] => シャルドネ
[3] => シャルドネ
[color] => 白
[4] => 白
[vintage] => 2001
[5] => 2001
[price] => 2400
[6] => 2400
[picture] => images/w1.jpg
[7] => images/w1.jpg
[comment] => 魚料理にあう
[8] => 魚料理にあう
[stID] => 1
[9] => 1
)
[5] => Array
(
[wineID] => 4
[0] => 4
[name] => オーメドック
[1] => オーメドック
[locaID] => 5
[2] => 5
[kind] => カルベネソー
[3] => カルベネソー
[color] => 赤
[4] => 赤
[vintage] => 1997
[5] => 1997
[price] => 2200
[6] => 2200
[picture] => images/w4.png
[7] => images/w4.png
[comment] => 後味よい
[8] => 後味よい
[stID] => 1
[9] => 1
)
)
array(6) {
[0]=>
array(20) {
["wineID"]=>
int(3)
[0]=>
int(3)
["name"]=>
string(21) "サンテミリオン"
[1]=>
string(21) "サンテミリオン"
["locaID"]=>
int(5)
[2]=>
int(5)
["kind"]=>
string(12) "メルロー"
[3]=>
string(12) "メルロー"
["color"]=>
string(3) "赤"
[4]=>
string(3) "赤"
["vintage"]=>
int(1997)
[5]=>
int(1997)
["price"]=>
int(5800)
[6]=>
int(5800)
["picture"]=>
string(13) "images/w3.png"
[7]=>
string(13) "images/w3.png"
["comment"]=>
string(6) "辛口"
[8]=>
string(6) "辛口"
["stID"]=>
int(1)
[9]=>
int(1)
}
[1]=>
array(20) {
["wineID"]=>
int(6)
[0]=>
int(6)
["name"]=>
string(15) "シャンパン"
[1]=>
string(15) "シャンパン"
["locaID"]=>
int(1)
[2]=>
int(1)
["kind"]=>
string(15) "シャルドネ"
[3]=>
string(15) "シャルドネ"
["color"]=>
string(3) "白"
[4]=>
string(3) "白"
["vintage"]=>
int(1999)
[5]=>
int(1999)
["price"]=>
int(4000)
[6]=>
int(4000)
["picture"]=>
string(13) "images/w6.png"
[7]=>
string(13) "images/w6.png"
["comment"]=>
string(30) "肉料理も魚料理にあう"
[8]=>
string(30) "肉料理も魚料理にあう"
["stID"]=>
int(1)
[9]=>
int(1)
}
[2]=>
array(20) {
["wineID"]=>
int(2)
[0]=>
int(2)
["name"]=>
string(33) "ジュヴレシャンべルタン"
[1]=>
string(33) "ジュヴレシャンべルタン"
["locaID"]=>
int(4)
[2]=>
int(4)
["kind"]=>
string(18) "ピノノワール"
[3]=>
string(18) "ピノノワール"
["color"]=>
string(3) "赤"
[4]=>
string(3) "赤"
["vintage"]=>
int(1998)
[5]=>
int(1998)
["price"]=>
int(3000)
[6]=>
int(3000)
["picture"]=>
string(13) "images/w2.png"
[7]=>
string(13) "images/w2.png"
["comment"]=>
string(18) "肉料理にあう"
[8]=>
string(18) "肉料理にあう"
["stID"]=>
int(1)
[9]=>
int(1)
}
[3]=>
array(20) {
["wineID"]=>
int(5)
[0]=>
int(5)
["name"]=>
string(15) "サンセール"
[1]=>
string(15) "サンセール"
["locaID"]=>
int(7)
[2]=>
int(7)
["kind"]=>
string(30) "ソーヴィニヨンブラン"
[3]=>
string(30) "ソーヴィニヨンブラン"
["color"]=>
string(3) "白"
[4]=>
string(3) "白"
["vintage"]=>
int(2001)
[5]=>
int(2001)
["price"]=>
int(2800)
[6]=>
int(2800)
["picture"]=>
string(13) "images/w5.jpg"
[7]=>
string(13) "images/w5.jpg"
["comment"]=>
string(27) "有名なドイツワイン"
[8]=>
string(27) "有名なドイツワイン"
["stID"]=>
int(1)
[9]=>
int(1)
}
[4]=>
array(20) {
["wineID"]=>
int(1)
[0]=>
int(1)
["name"]=>
string(12) "シャブリ"
[1]=>
string(12) "シャブリ"
["locaID"]=>
int(4)
[2]=>
int(4)
["kind"]=>
string(15) "シャルドネ"
[3]=>
string(15) "シャルドネ"
["color"]=>
string(3) "白"
[4]=>
string(3) "白"
["vintage"]=>
int(2001)
[5]=>
int(2001)
["price"]=>
int(2400)
[6]=>
int(2400)
["picture"]=>
string(13) "images/w1.jpg"
[7]=>
string(13) "images/w1.jpg"
["comment"]=>
string(18) "魚料理にあう"
[8]=>
string(18) "魚料理にあう"
["stID"]=>
int(1)
[9]=>
int(1)
}
[5]=>
array(20) {
["wineID"]=>
int(4)
[0]=>
int(4)
["name"]=>
string(18) "オーメドック"
[1]=>
string(18) "オーメドック"
["locaID"]=>
int(5)
[2]=>
int(5)
["kind"]=>
string(18) "カルベネソー"
[3]=>
string(18) "カルベネソー"
["color"]=>
string(3) "赤"
[4]=>
string(3) "赤"
["vintage"]=>
int(1997)
[5]=>
int(1997)
["price"]=>
int(2200)
[6]=>
int(2200)
["picture"]=>
string(13) "images/w4.png"
[7]=>
string(13) "images/w4.png"
["comment"]=>
string(12) "後味よい"
[8]=>
string(12) "後味よい"
["stID"]=>
int(1)
[9]=>
int(1)
}
}
WINE array[1]: Fetch all of the remaining rows in the result set:by the index of colunmn
Array
(
[0] => サンテミリオン
[1] => シャンパン
[2] => ジュヴレシャンべルタン
[3] => サンセール
[4] => シャブリ
[5] => オーメドック
)
DESC WINE, Fetch all of the remaining rows in the result set:by the index of colunmn
Array
(
[0] => wineID
[1] => name
[2] => locaID
[3] => kind
[4] => color
[5] => vintage
[6] => price
[7] => picture
[8] => comment
[9] => stID
)
| wineID | name | locaID | kind | color | vintage | price | picture | comment | stID |