001.<?php
002.include'include/master.php';
003.include'include/condb.php';
004.?>
005.<!DOCTYPE html>
006.<html lang="en"><!-- InstanceBegin template="/Templates/Fahsaung.dwt" codeOutsideHTMLIsLocked="false" -->
007. <head>
008. <meta charset="utf-8">
009. <!-- Title here -->
010. <!-- InstanceBeginEditable name="doctitle" -->
011. <title>ศูนย์ไตเทียมฟ้าสั่ง</title>
012. <!-- InstanceEndEditable -->
013. <!-- Description, Keywords and Author -->
014. <meta name="description" content="Your description">
015. <meta name="keywords" content="Your,Keywords">
016. <meta name="author" content="ResponsiveWebInc">
017.
018. <meta name="viewport" content="width=device-width, initial-scale=1.0">
019.
020. <!-- Styles -->
021. <!-- Bootstrap CSS -->
022. <link href="css/bootstrap.min.css" rel="stylesheet">
023. <!-- Flex Slider CSS -->
024. <link href="css/flexslider.css" rel="stylesheet">
025. <!-- Pretty Photo -->
026. <link href="css/prettyPhoto.css" rel="stylesheet">
027. <!-- Font awesome CSS -->
028. <link href="css/font-awesome.min.css" rel="stylesheet">
029. <!-- Custom CSS -->
030. <link href="css/style.css" rel="stylesheet">
031. <!-- Color Stylesheet - orange, blue, pink, brown, red or green-->
032. <link href="css/purple.css" rel="stylesheet">
033.
034. <!-- Favicon -->
035. <link rel="shortcut icon" href="img/favicon/favicon.png">
037.
038.<style type="text/css">
039.
040.td {
041. padding:3px;
042.}
043.
044.
045.@font-face {
046. font-family: "Tahoma";
047. font-size: 12px;
048.}
049.
050.</style>
051.
052. <!-- InstanceBeginEditable name="head" -->
053.<?php
054. ini_set('display_errors', 1);
055. error_reporting(~0);
056.
057. $strKeyword = null;
058.
059. if(isset($_POST["txtKeyword"]))
060. {
061. $strKeyword = $_POST["txtKeyword"];
062. }
063.?>
064.
065. <!-- InstanceEndEditable -->
066. </head>
067.
068. <body>
069.
070.<!-- Header starts -->
071.<?php head(); ?>
072.<!-- Header ends -->
073.
074. <!-- Navigation Starts -->
075. <?php nav(); ?>
076. <!--/ Navigation Ends -->
077.<div class="content">
078. <div class="container">
079. <div class="row">
080. <div class="col-md-12">
081.<!-- InstanceBeginEditable name="Content" -->
082.<?php
083.$sql = "SELECT Name FROM dz WHERE Name LIKE '%".$strKeyword."%' ";
084.$query = mysqli_query($conn,$sql);
085. ?>
086.<h2>Dialyzer</h2>
087.<form name="frmSearch" method="post" action="<?php echo $_SERVER['SCRIPT_NAME'];?>">
088.<table width="450">
089. <tr>
090. <td width="58">คำค้น</td>
091. <td width="132"><input class="form-control" style="width:150px;" type="search" name="txtKeyword" value="<?php echo $strKeyword;?>"></td>
092. <td width="82"><button type="submit" class="btn btn-default" aria-label="Left Align"> <span class="glyphicon glyphicon-search" aria-hidden="true"> ค้นหา</span> </button></td>
093. <td width="188"><button type="button" class="btn btn-success" onClick ="window.location = 'add-dz.php'" aria-label="Left Align"> <span class="glyphicon glyphicon-plus" aria-hidden="true"> Dialyzer</span> </button></td>
094. </tr>
095.</table>
096.</form>
097.<table width="300" border="1">
098. <tr>
099. <td height="38" align="center" bgcolor="#0099FF"><font size="+1" color="#FFFFFF">Dialyzer</font></td>
100. <td width="80" align="center" bgcolor="#0099FF"><font color="#FFFFFF">แก้ไข/ลบ</font></td>
101. </tr>
102. <tr>
103.<?php
104.while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
105.{
106.?>
107. <td width="238"><?php echo $result["Name"];?></td>
108. <td align="center"><div class="btn-group" role="group" aria-label="...">
109. <button type="button" class="btn btn-warning btn-sm" onclick="location.href='add-dz.php'" aria-label="Left Align"> <span class="glyphicon glyphicon-pencil" aria-hidden="true"></span> </button>
110. <button type="button" class="btn btn-danger btn-sm" aria-label="Left Align"> <span class="glyphicon glyphicon-remove" aria-hidden="true"></span> </button>
111.</div></td>
112. </tr>
113.<?php
114.}
115.?>
116.</table>
117.<?php
118.$conn->close();
119.?>
120.<!-- InstanceEndEditable -->
121. <!-- Service ends -->
122. </div>
123. </div>
124. </div>
125.</div>
126. <!-- Footer -->
127.<?php foot(); ?>
128. <!--/ Footer -->
129.
130. <!-- Scroll to top -->
131. <span class="totop"><a href="#"><i class="fa fa-angle-up"></i></a></span>
132.
133. <!-- Javascript files -->
134. <!-- jQuery -->
135. <!-- InstanceBeginEditable name="EditRegion4" -->
136.
137. <!-- InstanceEndEditable -->
138. <!-- Bootstrap JS -->
139. <script src="js/bootstrap.min.js"></script>
140. <!-- Isotope, Pretty Photo JS -->
141. <script src="js/jquery.isotope.js"></script>
142. <script src="js/jquery.prettyPhoto.js"></script>
143. <!-- Support Page Filter JS -->
144. <script src="js/filter.js"></script>
145. <!-- Flex slider JS -->
146. <script src="js/jquery.flexslider-min.js"></script>
147. <!-- Respond JS for IE8 -->
148. <script src="js/respond.min.js"></script>
149. <!-- HTML5 Support for IE -->
150. <script src="js/html5shiv.js"></script>
151. <!-- Custom JS -->
152. <script src="js/custom.js"></script>
153. </body>
154.<!-- InstanceEnd --></html>
สงสัยแค่ว่ามันเป็น Case sensitive ด้วยหรอครับ ชื่อตารางเนี่ย
