 |
|
Code
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<? include "connect.php"; ?>
<?
$strSQL = "SELECT a.id_tb_tv,b.id_tb,b.tb_name,b.descrition_table,c.id_view,c.view_names,e.id_field,e.field_name,e.description_field,d.id_tb_tf FROM table_view a LEFT JOIN (table_name b,view_name c) on (a.id_tb=b.id_tb and a.id_view=c.id_view) LEFT JOIN table_field d on (d.id_tb=b.id_tb ) LEFT JOIN field_name e on (d.id_field = e.id_field) ";
/* $strSQL = "SELECT a.id_tb_tv,b.id_tb,b.tb_name,b.descrition_table,c.id_view,c.view_names,e.id_field,e.field_name,e.description_field,d.id_tb_tf FROM table_view a ,table_name b ,view_name c , field_name e , table_field d where (a.id_tb=b.id_tb) and (a.id_view=c.id_view) and (d.id_tb=b.id_tb) and (d.id_field=e.id_field) ORDER BY a.id_tb_tv,d.id_tb_tf"; */
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
?>
<!-- SELECT d.id_tb_tf,e.id_field,e.field_name,e.description_field,b.id_tb,b.tb_name FROM table_field d inner join (table_name b,field_name e) on (d.id_tb=b.id_tb and d.id_field=e.id_field) group by d.id_tb_tf -->
<center><table width="1000" border="1" bgcolor="#FFFFFF" align="center" cellpadding="3" cellspacing="0" bordercolor="#0000FF">
<tr>
<th width="102"> <div align="center">ID Join Table View </div></th>
<th width="102"> <div align="center">ID Join Table Field</div></th>
<th width="193"> <div align="center">ID table </div></th>
<th width="193"> <div align="center">ID View </div></th>
<th width="193"> <div align="center">Table name </div></th>
<th width="193"> <div align="center"> field name </div></th>
<th width="193"> <div align="center">View name </div></th>
<th width="1500" <div align="center">Description </div></th>
</tr>
<?
$i=0;
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr bgcolor="<? echo $bg?>" onMouseOver="this.style.backgroundColor='#99FF99'" onMouseOut="this.style.backgroundColor=''" valign="top">
<td valign="top"><div align="center"> <?=$objResult["id_tb_tv"];?></a></div></td>
<td valign="top"><div align="center"><?=$objResult["id_tb_tf"];?></a></div></td>
<td valign="top"><?=$objResult["id_tb"];?></td>
<td valign="top"><?=$objResult["id_view"];?></td>
<td valign="top"><?=$objResult["tb_name"];?></td>
<td valign="top"> <?=$objResult["field_name"];?></td>
<td valign="top"><?=$objResult["view_names"];?></td>
<td valign="top" ><?=$objResult["descrition_table"];?></td>
</tr>
<?
$i++;
}
?>
</td>
</table>
</body>
</html>
Tag : PHP, MySQL, HTML/CSS, JavaScript, Ajax, jQuery
|
|
|
 |
 |
 |
 |
| Date :
2016-07-08 11:32:06 |
By :
chakpetch |
View :
913 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
