Perekodan

Sistem Pendaftaran

Post Top Ad


---database.sql---
CREATE TABLE `customer` (
  `id` int(255) NOT NULL,
  `CustomerID` varchar(4) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `CountryCode` varchar(2) NOT NULL,
  `Budget` double NOT NULL,
  `Used` double NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `customer` (`id`, `CustomerID`, `Name`, `Email`, `CountryCode`, `Budget`, `Used`) VALUES
(1, 'C001', 'Win Weerachai', 'win.weerachai@thaicreate.com', 'TH', 1000000, 600000),
(2, 'C002', 'John  Smith', 'john.smith@thaicreate.com', 'UK', 2000000, 800000),
(3, 'C003', 'Jame Born', 'jame.born@thaicreate.com', 'US', 3000000, 600000),
(4, 'C004', 'Chalee Angel', 'chalee.angel@thaicreate.com', 'US', 4000000, 100000);


ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `CustomerID` (`CustomerID`);


################################


----search.php----




<html>
<head>
<title>ThaiCreate.Com PHP & MySQL (mysqli)</title>
</head>
<body>
<?php
 ini_set('display_errors', 1);
 error_reporting(~0);

 $strKeyword = null;

 if(isset($_POST["txtKeyword"]))
 {
  $strKeyword = $_POST["txtKeyword"];
 }
?>
<form name="frmSearch" method="post" action="<?php echo $_SERVER['SCRIPT_NAME'];?>">
  <table width="599" border="1">
    <tr>
      <th>Keyword
      <input name="txtKeyword" type="text" id="txtKeyword" value="<?php echo $strKeyword;?>">
      <input type="submit" value="Search"></th>
    </tr>
  </table>
</form>

<?php

   $serverName = "localhost";
   $userName = "root";
   $userPassword = "";
   $dbName = "test";

   $conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
 
   $sql = "SELECT * FROM customer WHERE Name LIKE '%".$strKeyword."%'  or CountryCode LIKE '%".$strKeyword."%' or Used LIKE '%".$strKeyword."%' ";

   $query = mysqli_query($conn,$sql);

?>
<table width="600" border="1">
  <tr>
    <th width="91"> <div align="center">CustomerID </div></th>
    <th width="98"> <div align="center">Name </div></th>
    <th width="198"> <div align="center">Email </div></th>
    <th width="97"> <div align="center">CountryCode </div></th>
    <th width="59"> <div align="center">Budget </div></th>
    <th width="71"> <div align="center">Used </div></th>
  </tr>
<?php
while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
{
?>
  <tr>
    <td><div align="center"><?php echo $result["CustomerID"];?></div></td>
    <td><?php echo $result["Name"];?></td>
    <td><?php echo $result["Email"];?></td>
    <td><div align="center"><?php echo $result["CountryCode"];?></div></td>
    <td align="right"><?php echo $result["Budget"];?></td>
    <td align="right"><?php echo $result["Used"];?></td>
  </tr>
<?php
}
?>
</table>
<?php
mysqli_close($conn);
?>
</body>
</html>













 Tags: 
, 



























































































         




            
          







Post Top Ad