การค้นหาคำภาษาไทยใน record ของ mysql ผ่านตัวแปล PHP

<?php
include("database_connect.php");

?>

<style>

h1.intro {
	margin-top: 25px;
	border-radius: 10px;
	background-color: #a6a6a6;
	color:white;
	padding-left: 30px;
}
body {
	padding-top: 0px;
	padding-right:  100px;
	padding-left: 100px;
	zoom: 80%;
	background-color: #f2f2f2;
}
input[type=text], select {
		width: 300;
		padding: 5px 23px;
		margin: 3px ;
		display: inline-block;
		border: 1px solid #ccc;
		border-radius: 4px;
		box-sizing: border-box;
	}
input[type=submit] {
	width: 120;
	background-color: #76a0ef;
	color: white;
	padding: 14px 20px;
	margin: 8px 0;
	border: none;
	border-radius: 10px;
	cursor: pointer;
	font-size:13;
}

input[type=submit]:hover {
	background-color: #8db0f2;
}

</style>

<header>
	<h1 class = "intro">Receipt</h1>
	<meta charset="utf-8">


</header><title>All receipts</title>

<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">

<form method="post" action = "listreceipt.php">
	<b>Search:<input type="text"  name="searchtext" value= "<?php if (isset($_POST['searchtext'])) echo $_POST['searchtext']; ?>"  placeholder="Type here to search" > 
		<input type="submit" name="searchbutton" src="searchicon.png" value = 'Search' width="30" height="30"  alt="addbutton" formaction = "listreceipt.php" />
		<!--<a href="listreceipt.php" name ="searchbutton"><img src="searchicon.png" width = "30" height ="30" ></a>-->
		<input type = 'submit'  value = 'Add receipt' formaction = "fillreceipt.php"  style="float: right;">
	</form>

	<?php
	if(isset($_POST['searchbutton'])) {
		$result = mysqli_query($dbc, "SELECT * FROM receipt WHERE Date LIKE '%".$_REQUEST['searchtext']."%' OR CustomerName LIKE '%".$_REQUEST['searchtext']."%' OR PaymentType LIKE '%".$_REQUEST['searchtext']."%' OR SaleName LIKE '%".$_REQUEST['searchtext']."%' ORDER BY STR_TO_DATE(Date, '%d-%M-%Y') DESC");
	echo "<table class='w3-table-all'> <thead> <tr class='w3-blue'>";
	echo "<td><bgcolor ='#A2D75C'><center>"."Date"."</td>"."<td><center>"."Customer Name"."</td>"."<td><center>"."Description"."</td>"."<td><center>"."Amount"."</td>"."<td><center>"."Total"."</td>"."<td><center>"."VAT"."</td>"."<td><center>"."Grand Total"."</td>"."<td><center>"."Payment Type"."</td>"."<td><center>"."Sale Name"."</td>"."<td><center>View PDF</td>";


	while ($row=mysqli_fetch_array($result)){
		$id = $row['ReceiptID'];
		echo "<tr>";
		echo "<td><center>".$row['Date']."</td>"."<td><center>".$row['CustomerName']."</td>"."<td><center><pre>".$row['Description']."</pre></td>"."<td><center>".$row['Amount']."</td>"."<td><center>".$row['Total']."</td>"."<td><center>".$row['VAT']."</td>"."<td><center>".$row['GrandTotal']."</td>"."<td><center>".$row['PaymentType']."</td>"."<td><center>".$row['SaleName']."</td>";
		echo "<td><center>"."<a href='testpdf.php?id=$id'><img border='0' src='pdficon.png' width='30' height='30'>"."</center></td>";
	}
		?>
		<a href = "listreceipt.php"> << Back</a>
		<?php
		exit();
	}

	$result = mysqli_query($dbc, "SELECT * FROM receipt ORDER BY STR_TO_DATE(Date, '%d-%M-%Y') DESC");
	echo "<table class='w3-table-all'> <thead> <tr class='w3-blue'>";
	echo "<td><bgcolor ='#A2D75C'><center>"."Date"."</td>"."<td><center>"."Customer Name"."</td>"."<td><center>"."Description"."</td>"."<td><center>"."Amount"."</td>"."<td><center>"."Total"."</td>"."<td><center>"."VAT"."</td>"."<td><center>"."Grand Total"."</td>"."<td><center>"."Payment Type"."</td>"."<td><center>"."Sale Name"."</td>"."<td><center>View PDF</td>";


	while ($row=mysqli_fetch_array($result)){
		$id = $row['ReceiptID'];
		echo "<tr>";
		echo "<td><center>".$row['Date']."</td>"."<td><center>".$row['CustomerName']."</td>"."<td><center><pre>".$row['Description']."</pre></td>"."<td><center>".$row['Amount']."</td>"."<td><center>".$row['Total']."</td>"."<td><center>".$row['VAT']."</td>"."<td><center>".$row['GrandTotal']."</td>"."<td><center>".$row['PaymentType']."</td>"."<td><center>".$row['SaleName']."</td>";
		echo "<td><center>"."<a href='testpdf.php?id=$id'><img border='0' src='pdficon.png' width='30' height='30'>"."</center></td>";
	}

	?>

<?php

$host= "localhost";
$user="root";
//$password = "";
$dbc=mysqli_connect($host,$user);

mysqli_select_db($dbc, 'xfitness');
mysqli_query($dbc, "SET NAMES UTF8");

if (mysqli_connect($host, $user)) {
	//echo "Connected Database!!!!";

} else {
	echo "Error!!";
}

?>

<?php
  $variable_php = "...... code php ......";
?><!doctype html>
<html>
<head>
<link .... global css ..../>
<style>
   /* .... only this page css .... */
</style>
<script src="global javascript" ></script>
<script>
   /* .... only this page javascript */
</script>
</head>
<body>
   <div>content  <?=$variable_php?></div>
</body>
</html>

<?php
$host= "localhost";
$user='[email protected]'; // เปลี่ยนอย่าใช้ root privilage ใช้ user เฉพาะ domain
$password = '??????';
$dbname = 'xfitness';
$dbc=new mysqli($host,$user, $password, $dbname);
if($dbc->connect_errno){ die('Error<br>' . $dbc->connect_error); }
$dbc->set_charset("UTF-8");

  $searchtext = filter_input(INPUT_POST, 'searchtext', FILTER_SANITIZE_STRING, array("options" => array("default" => '')));
  $result = $dbc->query("SELECT * FROM receipt 
    WHERE concat( Date,'_', CustomerName , '_' , PaymentType , '_' , SaleName) LIKE '%$searchtext%'
    ORDER BY STR_TO_DATE(Date, '%d-%M-%Y') DESC" );
  while( $ro=$result->fetch_object()){
     echo $ro->Date, '-', $ro->CustomerName;
  }