โค้ด: เลือกทั้งหมด
<?php
date_default_timezone_set("Asia/Bangkok");
$date = time();
$time = (date("Y-m-d H:i:s", $date)) . "<br>";
$ip = $_SERVER["REMOTE_ADDR"];
date_default_timezone_set("Asia/Bangkok");
require_once'conn.php';
include '../config.php';
?>
<link rel="stylesheet" href="../css/color.css">
<!-- <link rel="stylesheet" href="../tools_keyword_youtube/cssyou.css"> -->
<meta property="og:url" content="<?php echo ((array_key_exists('HTTPS', $_SERVER) && $_SERVER["HTTPS"] == "on") ? 'https://' : 'http://') . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI']; ?>"/>
<meta property="og:type" content="website" />
<meta property="og:title" content="<?php echo $lang_unitcomdate; ?>"/>
<meta property="og:description" content="<?php echo $lang_unitcomdate; ?>"/>
<meta property="og:image" content="https://www.mindphp.com/images/content/Tool/tools_search_keyword_youtube.png"/>
<meta property="og:image:alt" content="<?php echo $lang_programconver; ?>"/>
<meta name="keywords" content="<?php echo $lang_progrcalculatetaxkk; ?>"/>
<title><?php echo $lang_programconvertunit; ?></title>
<script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "SoftwareApplication",
"name": "keyword youtube",
"image": "https://www.mindphp.com/images/info/mindphp-logo-v40.png",
"description": "โปรแกรมสำหรับค้นหา keyword ของ youtube",
"operatingSystem": "Windows 7",
"applicationCategory": "http://schema.org/GameApplication",
"aggregateRating": {
"@type": "AggregateRating",
"ratingValue": "4.7",
"ratingCount": "23214"
}
}
</script>
<script src="https://www.google.com/recaptcha/api.js" asyncdefer></script>
<?php
include '../header.php';
include '../PHP-Pagination-master/Pagination.class.php';
ini_set('display_errors', 1);
error_reporting(~0);
$POSTCODE = null;
if (isset($_POST["POSTCODE"])) {
$POSTCODE = $_POST["POSTCODE"];
}
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
$row = 10;
$total_data = "SELECT COUNT(id) FROM $table_con";
$result_1 = mysqli_query($conn, $total_data);
$total = mysqli_fetch_row($result_1);
$total_data = $total[0];
$start = ($page - 1) * $row;
$Pagination = new Pagination($page, $total_data);
$Pagination->parse();
$sql = "SELECT * FROM $table_con WHERE name LIKE '%" . $POSTCODE . "%' ORDER BY id DESC Limit $start,$row";
$result = mysqli_query($conn, $sql);
?>
<div class="container">
<div class="col-md-12">
<div class="row">
<div class="btn-group btn-breadcrumb">
<a class="btn btn-default"><?php echo $lang_youarehere; ?> :</a>
<a href="https://www.mindphp.com/online-tools/mindphp-tools.html" class="btn btn-default"><?php echo $lang_tools; ?></a>
<a href="index.php?lang=<?php echo $lang; ?>" class="btn btn-primary"><?php echo $lang_programconvertunit; ?></a>
</div>
</div><br>
</div>
<div class="col-md-4">
<?php //include 'menu_sidebar.php'; ?>
</div>
<div class=" col-md-8">
<div class="col-md-12">
<div class="panel panel-primary">
<div class="panel-heading"><?php echo $lang_programconvertunit; ?></div>
<div class="panel-body">
<form class="form-horizontal" name="frm" method="post" action="">
<br>
<div class="col-md-12">
<div class="form-group">
<label for="inputname" class="col-sm-3 control-label"><?php echo $lang_name; ?> : </label>
<div class="col-sm-9">
<input required type="text" class="form-control" id="inputEmail3" placeholder="<?php echo $lang_pleaseyourname ?>" name="user_name">
</div>
</div>
<div class="form-group">
<label for="inputarea-value" class="col-sm-3 control-label"><?php echo $lang_unit; ?> :</label>
<div class="col-sm-9">
<input required type="" class="form-control" id="inputPassword3" placeholder="<?php echo $lang_enternumunit; ?>" name="valuenum"> </div>
</div>
<div class="col-md-12">
<div align="center" class="g-recaptcha" required data-sitekey="<?php echo $keyrecaptcha; ?>"></div><br>
</div>
<br>
<div class="col-md-12">
<center>
<input class=" btn btn-success" type="submit" name="submit" value="<?php echo $lang_calculate; ?>" />
<input class="btn btn-danger" type="reset" name="reset" value="<?php echo $lang_cleaar; ?>"/>
</center>
</div>
</div>
<div class="col-md-12">
<?php
if (isset($_POST['g-recaptcha-response'])) {
$keyrecaptcha = $_POST['g-recaptcha-response'];
$response = json_decode(file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=" . $secretkeyrecaptcha . "&response=" . $keyrecaptcha . "&remoteip=" . $_SERVER['REMOTE_ADDR']), true);
if (!$keyrecaptcha) {
$missinginputsecret = "คลิกทำเครื่องหมายถูกตรวจสอบว่าคุณไม่ใช้โปรแกรมอัตโนมัติ";
?>
<br><div align="center" class="unnit-color"><b><?php print_r($missinginputsecret) ?></b></div>
<?php
}
}
if (isset($_POST['submit'])) {
$submit1 = @$_POST['submit1'];
$name = $_POST['user_name'];
$value = $_POST['valuenum'];//รหัสไปรษณีย์
// $key = '';
$sql = "SELECT a.*, p.PROVINCE_NAME FROM mzc_mamphur AS a
LEFT JOIN mzc_mprovince AS p ON p.PROVINCE_ID = a.PROVINCE_ID
WHERE a.POSTCODE =$value";
$result2 = mysqli_query($conn, $sql);
$amphor_data = mysqli_fetch_assoc($result2);
$provice_name = $amphor_data['PROVINCE_NAME'];
$province_id =$amphor_data['PROVINCE_ID'];
$amphor_name =$amphor_data['AMPHUR_NAME'];
$amphor_id =$amphor_data['AMPHUR_ID'];
$sql = "SELECT DISTRICT_ID ,DISTRICT_NAME FROM mzc_mdistrict WHERE AMPHUR_ID = ".$amphor_id;
$result = mysqli_query($conn, $sql);
$district_items = array();
while($district_data = mysqli_fetch_assoc($result))
{
$district_items[] = $district_data;
}
//print_r($district_items);exit();
// นำไปใช้
foreach ($district_items as $district_items => $values)
{
//echo $district_items;
foreach ($values as $valu)
{
echo $valu;
}
}
//ต้องการ insert ตารางประวัติ
$sql3 = "INSERT INTO tool_province ( `user_name`, `PROVINCE_ID`,`AMPHUR_ID`, `create_date`, `ip`)
VALUES ('$name','$province_id','$amphor_id','$time','$ip')";
$result2 = mysqli_query($conn, $sql3);
$sql5 = "INSERT INTO tools_province_place ('tools_province_id','district_id')
VALUES ('','$district_items') ";
$result5 = mysqli_query($conn, $sql5);
// $sql5 = "INSERT INTO 'toos_province_place' ('tools_province_id','district_id)values' ('$table_con','$district_items') ";
// $result5 = mysqli_query($conn, $sql5) or die ("Error in query: $sql5 " . mysqli_error());
// $sql = "SELECT * FROM `mzc_mdistrict`WHERE `DISTRICT_CODE` = $value ";
// $result2 = mysqli_query($conn, $sql);
// while (@$fetch1 = mysqli_fetch_assoc($result2)) {
// $district = $fetch1['DISTRICT_NAME'];
// $provinceId = $fetch1['PROVINCE_ID'];
// $amphorid = $fetch1['AMPHUR_ID'];
// }
// $sql1 = "SELECT * FROM `mzc_mprovince` WHERE PROVINCE_ID = $provinceId";
// $result3 = mysqli_query($conn, $sql1);
// while (@$fetch2 = mysqli_fetch_assoc($result3)) {
// $provice_name = $fetch2['PROVINCE_NAME'];
// }
?>
<table class="table">
<tbody>
<tr class="active">
<td align="right" width="50%">
<?php echo $lang_name . " : "; ?>
</td>
<td>
<?php echo $name; ?>
</td>
</tr>
<tr class="warning">
<td align="right" width="50%">
<?php echo $lang_showunitsthat . " :"; ?>
</td>
<td>
<?php echo $value . " "; ?>
</td>
</tr>
<tr class="active">
<td align="right" width="50%">
<?php echo $lang_place . " :"; ?>
</td>
<td>
<?php echo $valu; ?>
</td>
</tr>
<tr class="warning">
<td align="right" width="50%">
<?php echo $lang_province . " :"; ?>
</td>
<td>
<?php echo $provice_name; ?>
</td>
</tr>
<tr class="active">
<td align="right" width="50%">
<?php echo $lang_district. " :"; ?>
</td>
<td>
<?php echo $amphor_name ?>
</td>
</tr>
<tr class="active">
<td align="right" width="50%">
<?php echo $lang_recordtime . " :" ?>
</td>
<td>
<?php echo date("Y-m-d H:i:s", time()); ?>
</td>
</tr>
<tr class="warning">
<td align="right" width="50%">
<?php echo $lang_ipaddress . " : "; ?>
</td>
<td>
<?php echo $ip. " "; ?>
</td>
</tr>
</tbody>
</table>
<center><a href="index.php?lang=<?php echo $lang; ?>" class="btn btn-info"><?php echo $lang_resets;?></a></center>
<?php
}
?>
</div>
</form>
<div align="right"> <?php echo $lang_vercheckunit; ?> <?php echo $verconvertunit; ?></div>
</div>
</div>
</div>
<div class="well2">
<br>
<ul>
<b><?php echo $lang_unitconversion;?></b>
<li><?php echo $lang_enteryourname;?> <b><?php echo $lang_name;?></b></li>
<li><?php echo $lang_selecttypeofunit;?> <b><?php echo $lang_selectunit;?> </b></li>
<li><?php echo $lang_pressbutton;?> <b><?php echo $lang_calculate;?></b> <?php echo $lang_seeresults;?></li>
</ul>
</div>
</div>
<div class="row">
<div class="col-md-12 table-responsive" align="center">
<h3 align="center"><?php echo $lang_recentinformation;?></h3>
<table class="table table-striped">
<thead class="bg-primary" align="bottom">
<tr>
<th class="text-center" width="2%"><b><?php echo $lang_no; ?></b></th>
<th class="text-center" width="5%"> <?php echo $lang_name?> </th>
<th class="text-center" width="15%"> <?php echo $lang_unit //แสดงรหัสไปรษณีย์ ?> </th>
<th class="text-center" width="20%"> <?php echo $lang_province//ตัว keyword ของยูทูปเปลี่ยนเป็นจังหวัด?> </th>
<th class="text-center" width="5%"> <?php echo $lang_place //ส่วนนี้แสดงตำบล?> </th>
<th class="text-center" width="5%"> <?php echo $lang_district //ส่วนนี้จะให้แสดงเป็นอำเภอ?> </th>
<th class="text-center" width="5%"> <?php echo $lang_savewhen?> </th>
<th class="text-center" width="5%"> <?php echo $lang_ipaddress;?> </th>
<th class="text-center" width="5%"> <?php echo $lang_showinformation?> </th>
<th class="text-center" width="5%"> <?php ?> </th>
</tr>
</thead>
<?php
// $sql = "SELECT * FROM place_name
// INNER JOIN mzc_mdistrict ON mzc_mdistrict .PROVINCE_ID = mzc_mdistrict.PROVINCE_ID
// INNER JOIN mzc_mprovince ON mzc_mprovince.PROVINCE_ID = mzc_mdistrict.PROVINCE_ID
// INNER JOIN mzc_mamphur on mzc_mamphur.AMPHUR_ID = mzc_mdistrict.AMPHUR_ID
// WHERE mzc_mamphur.POSTCODE ";
$sql = "SELECT * FROM $table_con
INNER JOIN $province_con ON $province_con.PROVINCE_ID = $table_con.PROVINCE_ID
INNER JOIN $mdistrict_con on $mdistrict_con.DISTRICT_ID = $table_con.DISTRICT_ID
INNER JOIN $mamphur_con on $mamphur_con.AMPHUR_ID = $table_con.AMPHUR_ID
WHERE $table_con.id ORDER BY id desc Limit $start,$row";
$result2 = mysqli_query($conn, $sql);
while ($fetch = mysqli_fetch_assoc($result2)) {
// $sql = "SELECT * FROM $table_con ORDER BY id desc Limit $start,$row";
// $result2 = mysqli_query($conn, $sql);
// while ($fetch = mysqli_fetch_assoc($result2)) {
?>
<tr>
<td class="text-center"> <?php echo $fetch['id']; ?></td> <!-- ลำดับ-->
<td class="text-center"> <?php echo $fetch['user_name']; ?></td> <!-- ชื่อ-->
<td class="text-center"> <?php echo $fetch['POSTCODE']; ?></td> <!-- url-->
<td class="text-center"> <?php echo $fetch['PROVINCE_NAME']; ?></td> <!-- url-->
<td class="text-center"> <?php echo $fetch['DISTRICT_NAME']; ?></td> <!-- keyword-->
<td class="text-center"> <?php echo $fetch['AMPHUR_NAME']; ?></td> <!-- url-->
<td class="textcenter"> <?php
if ($fetch['create_date']) {
echo $fetch['create_date'];
}
?></td>
<td class="text-center"> <?php include 'ip.php'; ?></td>
<td>
<a href="show.php?id=<?php echo $fetch['id']; ?>&lang=<?php echo $lang; ?>">
<i class="glyphicon glyphicon-new-window"></i>
</a>
</td>
<td>
<a class="btn btn-warning" href="edit.php?id=<?php echo $fetch['id']; ?>">แก้ไข
</a>
</td>
</tr>
<?php
}
?>
</table>
<div class="row">
<div class="col-md-12">
<div class="text-center">
<nav aria-label="Page navigation">
<?php
echo $Pagination->parse();
?>
</nav>
</div>
</div>
</div>
<a href="list.php?lang=<?php echo $lang; ?>" class="btn btn-primary"><?php echo $lang_moreinformation; ?></a>
</div>
</div>
</div>
<?php include '../footer.php'; ?>