 |
|
ต้องการที่จะแสดงข้อมูลของ 2 ตารางนี้ โดยข้อมูลเชื่อมโยงกัน ไม่ทราบว่าต้องทำแบบไหนครับ เพราะลองเฟสข้อมูลแล้ว ข้อมูลซ้ำกัน
โครงสร้างตาราง `tbl_attend`
--
CREATE TABLE `tbl_attend` (
`id_attend` int(11) NOT NULL auto_increment,
`id_researcher` int(11) NOT NULL,
`id_institution` int(11) NOT NULL,
`id_type` int(11) NOT NULL,
`begin` text character set utf8 NOT NULL,
`issue` text character set utf8 NOT NULL,
PRIMARY KEY (`id_attend`)
โครงสร้างตาราง `tbl_bold`
--
CREATE TABLE `tbl_bold` (
`id_bold` int(11) NOT NULL auto_increment,
`id_researcher` int(11) NOT NULL,
`id_type` int(11) NOT NULL,
`special` text character set utf8 NOT NULL,
PRIMARY KEY (`id_bold`)
2 ตารางนี้ เป็นการเชื่อมโยงกันของข้อมูล
โครงสร้างตาราง `tbl_institution`
--
CREATE TABLE `tbl_institution` (
`id_institution` int(11) NOT NULL auto_increment,
`institution` text character set utf8 NOT NULL,
`detail_service` text character set utf8 NOT NULL,
`charge` text character set utf8 NOT NULL,
`service_pdf` text character set utf8 NOT NULL,
`tel` text character set utf8 NOT NULL,
PRIMARY KEY (`id_institution`)
โครงสร้างตาราง `tbl_researcher`
--
CREATE TABLE `tbl_researcher` (
`id_researcher` int(11) NOT NULL auto_increment,
`researcher` text character set utf8 NOT NULL,
`pic` text character set utf8 NOT NULL,
PRIMARY KEY (`id_researcher`)
โครงสร้างตาราง `tbl_type`
--
CREATE TABLE `tbl_type` (
`id_type` int(11) NOT NULL auto_increment,
`types` text character set utf8 NOT NULL,
PRIMARY KEY (`id_type`)
ตารางข้อมูลที่ต้องนำมาใช้
Code
Code (PHP)
include "../include/config.inc.php";
$list_page = 1;
if (empty($page)){
$page=1;
$n=0;
}
if($id_attend!=""){
$sql = "select * from tbl_attend where id_type='1'";
}else $sql = "select * from tbl_attend where id_type='1'";
$result = mysql_db_query($dbname,$sql) or die(mysql_error());
$NRow = mysql_num_rows($result);
$rt = $NRow%$list_page;
if($rt!=0) {
$totalpage = floor($NRow/$list_page)+1;
}
else {
$totalpage = floor($NRow/$list_page);
}
$goto = ($page-1)*$list_page;
$sql = "SELECT tbl_attend.*,tbl_researcher.*,tbl_institution.*,tbl_type.* FROM tbl_attend,tbl_researcher,tbl_institution,tbl_type WHERE tbl_researcher.id_researcher = tbl_attend.id_researcher AND tbl_institution.id_institution = tbl_attend.id_institution AND tbl_type.id_type = tbl_attend.id_type AND tbl_attend.id_type = '1' order by tbl_attend.id_researcher limit $goto,$list_page";
$sql1 = "SELECT * FROM tbl_bold WHERE id_type = '1'";
$dbquery1 = mysql_db_query($dbname, $sql1);
$dbquery = mysql_db_query($dbname, $sql);
while ($result = mysql_fetch_array($dbquery)) //ช่วงการเรียกข้อมูล ซึ่งผมแก้ไม่ตก
{
echo $id_attend = $result[id_attend];
$id_researcher = $result[id_researcher];
$researcher = $result[researcher];
$institution = $result[institution];
$tel = $result[tel];
$types = $result[types];
$pic = $result[pic];
$name_pic = "../images/person/$pic";
$name_picn = "../images/person/noperson";
$special = $result[special];
$n++;
//$n--;
If ($bg=="#D5D5D5"){$bg="#E5E5E5";}Else{$bg="#D5D5D5";}
?>
<tr bgcolor="<?=$bg;?>">
<td align=center valign="middle" nowrap><font color="#3d3d3d">
<?=$n;?>
.</font></td>
<td align="left" valign="middle" nowrap><font color="#3d3d3d">
<?=$researcher;?>
</font></td>
<td align="center" valign="middle" nowrap><font color="#3d3d3d">
<?=$institution;?>
</font></td>
<td align="center" valign="middle" nowrap><font color="#3d3d3d">
<?=$tel;?>
</font></td>
<td align="center" valign="middle" nowrap><font color="#3d3d3d">
<?=$special;?>
</font></td>
<td align="center" valign="middle" nowrap><font color="#3d3d3d">
<?=$types;?>
</font></td>
<td align="center" valign="middle" nowrap><? if($pic!=""){?>
<a href="<?=$name_pic;?>"><img src="<?=$name_pic;?>" alt="" width="110" height="130" border="0"></a>
<? } else {?>
<img src="<?=$name_picn;?>" alt="" width="110" height="130" border="0">
<? } ?></td>
</tr>
<? }?>
<!--End Row -->
</tbody>
</table>
<?
Tag : PHP, CakePHP
|
|
|
 |
 |
 |
 |
| Date :
2011-04-01 10:00:44 |
By :
fujisawa10 |
View :
3053 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
