PHP上で、SQLを実行し、それを連想配列に変換する処理をしたのですが、その連想配列の要素数を取得しようと、
countを使うのですが、一つの行の要素数しか出てきません。
全部の要素数を取得する方法はありますでしょうか?
SQLの実行結果が$result
それに対して、mysqli_fetch_arrayの処理をして、変数
$dataに格納。
$data = mysqli_fetch_array($result,MYSQLI_ASSOC)
その$dataにcount($data)を実行しても、行の要素数14しか
表示されない。
echo count($data,COUNT_RECURSIVE);
としても同じ。
$dataの中身を念のため、確認してみると以下の通り。Arrayごとに分かれてしまっているためか!?
なぜ分かれるのかは不明です。
print_r($data);
【$dataの中身】
Array ( [access_type] => (102) [this] => 6 [one] => 44 [two] => 6 [three] => 0 [four] => 0 [five] => 0 [six] => 0 [seven] => 0 [eight] => 0 [nine] => 0 [ten] => 0 [eleven] => 0 [year] => 0 ) Array ( [access_type] => (201) [this] => 6 [one] => 40 [two] => 15 [three] => 0 [four] => 0 [five] => 0 [six] => 0 [seven] => 0 [eight] => 0 [nine] => 0 [ten] => 0 [eleven] => 0 [year] => 0 ) Array ( [access_type] => (103) [this] => 1 [one] => 22 [two] => 5 [three] => 0 [four] => 0 [five] => 0 [six] => 0 [seven] => 0 [eight] => 0 [nine] => 0 [ten] => 0 [eleven] => 0 [year] => 0 ) Array ( [access_type] => (301) [this] => 1 [one] => 8 [two] => 4 [three] => 5 [four] => 18 [five] => 0 [six] => 0 [seven] => 0 [eight] => 0 [nine] => 0 [ten] => 0 [eleven] => 0 [year] => 0 ) Array ( [access_type] => (202) [this] => 0 [one] => 16 [two] => 2 [three] => 0 [four] => 0 [five] => 0 [six] => 0 [seven] => 0 [eight] => 0 [nine] => 0 [ten] => 0 [eleven] => 0 [year] => 0 ) Array ( [access_type] => (203) [this] => 0 [one] => 12 [two] => 4 [three] => 0 [four] => 0 [five] => 0 [six] => 0 [seven] => 0 [eight] => 0 [nine] => 0 [ten] => 0 [eleven] => 0 [year] => 0 ) Array ( [access_type] => (204) [this] => 0 [one] => 1 [two] => 2 [three] => 0 [four] => 0 [five] => 0 [six] => 0 [seven] => 0 [eight] => 0 [nine] => 0 [ten] => 0 [eleven] => 0 [year] => 0 )
回答1件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2015/12/17 04:27
2015/12/17 04:46
2015/12/17 05:04
2015/12/17 05:16
2015/12/17 05:42
2015/12/18 02:52