お世話になってます。
今、phpとJS(XMLHTTPREQUEST)を使って、Mysqlから取得しそれを反映させたい
のですが、なぜか一部取得できません。どこが不味いのでしょうか?
お分かりの方おられましたら、ご教示下さい。
mysql(レコード)
id username hold_position
1 sdfdddddddddd aaaaaaaaaaaaaaa
2 ksdfjsdlfjsdkfjal sasdfsdfasdfadsfads
http://sssss.xsrv.jp/ssss6/public/roundcube/skins/elastic/deps/tester2.php
<?php $username="aaaaaa"; $password="bbbbbb" try{ $pdo = new PDO("mysql:host={hostname}; dbname={dbname}; charset=utf8", $username, $password); $sql = "select username, hold_position from uploaders"; $stmt = $pdo->prepare($sql); $stmt->execute(); while($result = $stmt->fetchAll(PDO::FETCH_ASSOC)){ if(!empty($result)){ $message[] = $result; } } $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); }catch(PDOException $e){ echo "接続失敗: " . $e->getMessage() . "\n"; exit(); } $ehime = ''; foreach($message as $value){ foreach($value as $key => $value2){ $ehime = $value2["username"]; $ehime2 = $value2["hold_position"]; $nitta[] = $ehime; $nitta[] = $ehime2; } } header("Content-Type: text/javascript; charset=utf-8"); echo json_encode($nitta); ?>
JS
<script language="javascript" type="text/javascript"> var request = new XMLHttpRequest(); request.open('GET', 'http://sssss.xsrv.jp/ssss6/public/roundcube/skins/elastic/deps/tester2.php',true); request.resposeType = 'json'; request.addEventListener('load', function(response){ var data = this.response; alert(data); }); request.send(); </script>
alertの結果
array(2){ ["hold_position"]=>string(65)"sasdfsdfasdfadsfads" ["username"]=>string(40)"ksdfjsdlfjsdkfjal" } {"hold_position":"sasdfsdfasdfadsfads","username":"ksdfjsdlfjsdkfjal"}
(修正後)
<?php try{ $username = "asasdasdasd"; $password = "safsadfasdfdsaf"; $pdo = new PDO("mysql:host=mysql8093.xserver.jp; dbname=gay86_roundcubemail; charset=utf8", $username, $password); $sql = "select username, hold_position from uploaders"; $stmt = $pdo->prepare($sql); $stmt->execute(); header("Content-Type: application/json; charset=utf-8"); echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC)); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); }catch(PDOException $e){ echo "接続失敗: " . $e->getMessage() . "\n"; exit(); } ?>
回答2件
あなたの回答
tips
プレビュー