Join ตารางแล้วแสดงข้อมูล Master-Detail (mysqli) ไม่ได้
error ว่า ???
Date :
2016-02-26 09:17:40By :
ห้ามตอบเกินวันละ 2 กระทู้
เขียน JOIN ไว้ยังไงบ้างครับ
Date :
2016-02-26 09:40:48By :
mr.win
error ตรง $result=mysqli_fetch_array($query,MYSQLI_ASSOC); อ่ะค่ะCode (PHP) <body>
<?php
ini_set('display_errors', 1);
error_reporting(~0);
$serverName = "localhost";
$userName = "root";
$userPassword = "root";
$dbName = "project_dolphin";
$strDolphin_id = null;
if(isset($_GET["Dolphin_id"]))
{
$strDolphin_id = $_GET["Dolphin_id"];
}
$serverName = "localhost";
$userName = "root";
$userPassword = "root";
$dbName = "project_dolphin";
$conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
$sql = "SELECT * FROM dolphin_sighting
LEFT JOIN add_dolphin ON dolphin_sighting.Dolphin_id = add_dolphin.Dolphin_id
LEFT JOIN sighting ON dolphin_sighting.Sighting_id = sighting.Sighting_id
WHERE Dolphin_id = '".$strDolphin_id."' ";
$query = mysqli_query($conn,$sql);
$result=mysqli_fetch_array($query,MYSQLI_ASSOC);
?>
<table width="284" border="1">
<tr>
<th width="120">Dolphin_id</th>
<th width="120">Name</th>
<th width="120">Sighting_id</th>
<th width="120">Location</th>
</tr>
<tr>
<td><?php echo $result["Dolphin_id"];?></td>
<td><?php echo $result["Name"];?></td>
<td><?php echo $result["Sighting_id"];?></td>
<td><?php echo $result["Location"];?></td>
</tr>
</table>
<?php
mysqli_close($conn);
?>
</body>
</html>
Date :
2016-02-27 11:37:16By :
oil
Code (PHP) echo $sql;
Date :
2016-02-27 12:00:00By :
mr.win
มีข้อมูลทั้งหมด 3 ตาราง คือCode (PHP) $sql = "SELECT * FROM add_dolphin";
Code (PHP) $sql = "SELECT * FROM dolphin_sighting
LEFT JOIN add_dolphin ON dolphin_sighting.Dolphin_id = add_dolphin.Dolphin_id
LEFT JOIN sighting ON dolphin_sighting.Sighting_id = sighting.Sighting_id";
ประวัติการแก้ไข
Date :
2016-02-28 00:27:23By :
oil
ช่วยหน่อยนะค๊า ยังไม่ออกเลย TT
Date :
2016-02-28 21:53:59By :
oil
Server 05
Load balance : Server 05
