001.<?
002.ob_start();
003.?>
006.<head>
007.</head>
008.<?
009.
010.
011.include 'config.inc';
012.
013.echo $hostname;
014.$link = mysql_connect("$hostname", "$username", "$password");
015.if (!$link) {
016. die('Could not connect: ' . mysql_error());
017.}
018. echo 'Connected successfully<br>';
019.
020.
021.mysql_select_db(navapanc_reru) or die("cannot connect DB");
022.
023.
024.
025.$sql ="SELECT * FROM sign";
026.
027.
028.$dbquery = mysql_db_query(navapanc_reru, $sql);
029.
030.
031.$num_rows = mysql_num_rows($dbquery);
032.
033.
034.?>
035.<body onload="MM_preloadImages('images/Menu-02.png','images/Menu-03.png','images/Menu-05.png','images/Menu-06.png')">
036.<form id="form1" name="form1" method="post" action="">
037. <table width="1104" border="0" align="center">
038. <tr>
039. <td width="1093"><img src="images/Menu-by-finance_01.png" width="566" height="48" /><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image8','','images/Menu-02.png',1)"><img src="images/Menu-by-finance_02.png" name="Image8" width="137" height="48" border="0" id="Image8" /></a><a href="update.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','images/Menu-03.png',1)"><img src="images/Menu-by-finance_03.png" name="Image4" width="137" height="48" border="0" id="Image4" /></a><a href="LocateDataTime.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','images/Menu-05.png',1)"><img src="images/Menu-by-finance_05.png" name="Image6" width="132" height="48" border="0" id="Image6" /></a><a href="contact.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image7','','images/Menu-06.png',1)"><img src="images/Menu-by-finance_06.png" name="Image7" width="149" height="48" border="0" id="Image7" /></a></td>
040. <td width="10"> </td>
041. </tr>
042. <tr>
043. <td><table width="1131" height="29" border="0" cellpadding="3" cellspacing="2">
044. <tr class="heading">
045. <td width="5%" align="left" bgcolor="#D2E4FF">ระดับ</td>
046. <td width="5%" align="left" bgcolor="#D2E4FF">วันที</td>
047. <td width="7%" align="left" bgcolor="#D2E4FF">ชื่อ-นามสกุล</td>
048. <td width="7%" align="left" bgcolor="#D2E4FF">เบอร์โทร</td>
049. <td width="7%" align="left" bgcolor="#D2E4FF">ที่อยู่</td>
050. <td width="13%" align="left" bgcolor="#D2E4FF">จังหวัด</td>
051. <td width="12%" align="left" bgcolor="#D2E4FF">ประเภทรถยนต์</td>
052. <td width="5%" align="left" bgcolor="#D2E4FF">ยี่ห้อ</td>
053. <td width="12%" align="left" bgcolor="#D2E4FF">ปีจดทะเบียน</td>
054. <td width="9%" align="left" bgcolor="#D2E4FF">อีเมล์ </td>
055. <td width="13%" align="left" bgcolor="#D2E4FF">ยอดจัด</td>
056. <td width="10%" align="left" bgcolor="#D2E4FF">วันที่ส่ง</td>
057. <td width="10%" align="left" bgcolor="#D2E4FF">สาขาหลัก</td>
058. <td width="10%" align="left" bgcolor="#D2E4FF">ส่งต่อให้</td>
059. <td width="10%" align="left" bgcolor="#D2E4FF">สถานะ</td>
060. <td width="10%" align="left" bgcolor="#D2E4FF">update</td>
061. </tr>
062. <?
063.$bgcolor = "#FFFFD2";
064.$i=0;
065. $tt = 0;
066.while($i < $num_rows)
067. {
068.
069. $tt = $tt+1 ;
070. $result = mysql_fetch_array($dbquery);
071. $sign_id = $result[sign_id];
072. $width = $result[width];
073. $date = $result[date];
074. $long = $result[long];
075. $name = $result[name];
076. $tell = $result[tell];
077. $add = $result[add];
078. $address = $result[address];
079. $detail = $result[detail];
080. $car = $result[car];
081. $year = $result[year];
082. $sex = $result[sex];
083. $ssk = $result[ssk];
084. $branch = $result[branch];
085. $status = $result[status];
086. if($bgcolor == "#FFFFD2")
087. {
088. $bgcolor = "#E6FFEC";
089. } else
090. {
091. $bgcolor = "#FFFFD2";
092. }
093.
094. echo "<tr class=\"data\">";
095.
096. echo "<td width=\"5%\" bgcolor=\"$bgcolor\">$tt</td>";
097. echo "<td width=\"15%\" bgcolor=\"$bgcolor\">$date</td>";
098. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$name</td>";
099. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$tell</td>";
100. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$add</td>";
101. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$address</td>";
102. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$sex</td>";
103. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$car</td>";
104. echo "<td width=\"5%\" bgcolor=\"$bgcolor\">$year</td>";
105. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$detail</td>";
106. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$width</td>";
107. echo "<td width=\"25%\" bgcolor=\"$bgcolor\">$long</td>";
108. echo "<td width=\"10%\" bgcolor=\"$bgcolor\">$ssk</td>";
109. echo "<td width=\"25%\" bgcolor=\"$bgcolor\">$branch</td>";
110. echo "<td width=\"25%\" bgcolor=\"$bgcolor\">$status</td>";
111. echo "<td width=\"10%\" bgcolor=\"$bgcolor\"><a href=\"updateform.php?sign_id=$sign_id&&width=$width&&long=$long&&name=$name&&tell=$tell&&detail=$detail&&add=$add&&address=$address&&car=$car&&year=$year&&sex=$sex&&ssk=$ssk \">update</a></td>";
112.
113.
114.
115. echo "</tr>";
116. $i++;
117. }
118.
119.mysql_close($link);
120.
121.
122.?>
123.</td>
124. <td> </td>
125. <td> </td>
126. </tr>
127. <tr>
128. <td> </td>
129. <td> </td>
130. <td> </td>
131. </tr>
132.</table>
