แล้วผมได้นำโค้ดจากการศึกษาไปใช้กับงานครับเป็นโค้ดประมานนี้ครับ แล้วนำตัวแปรปุ่มบันทึกรูปภาพ กับตัวแปรที่ต้องการ Shortcut หรือส่วนที่ต้องการทำให้เป็นรูป
แล้วได้เพิ่มตัวแปร newimg สำหรับแปลหน้าเว็บไซต์เป็นรูป และตัวแปร img สำหรับใช้แสดงรูปภาพ
โค้ด: เลือกทั้งหมด
<script>
$(function() {
$("#savepicture").click(function() {
html2canvas($("#drag-container"), {
onrendered: function(canvas) {
var imgsrc = canvas.toDataURL("image/png");
console.log(imgsrc);
$("#newimg").attr('src', imgsrc);
$("#img").show();
var dataURL = canvas.toDataURL();
$.ajax({
type: "POST",
url: "script.php",
data: {
imgBase64: dataURL
}
}).done(function(o) {
console.log('saved');
});
}
});
});
});
</script>
โค้ด: เลือกทั้งหมด
<?php
define('UPLOAD_DIR', 'images/');
$img = $_POST['imgBase64'];
$img = str_replace('data:image/png;base64,', '', $img);
$img = str_replace(' ', '+', $img);
$data = base64_decode($img);
$file = UPLOAD_DIR . uniqid() . '.png';
$success = file_put_contents($file, $data);
print $success ? $file : 'Unable to save the file.';
?>
โค้ด: เลือกทั้งหมด
<?php
require_once 'conn.php';
include '../head_html.php';
include '../config.php'
?>
<meta property="og:url" content="<?php echo $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; ?>" />
<meta property="og:type" content="website" />
<meta property="og:title" content="<?php echo $lang_program_lineup; ?>" />
<meta property="og:description" content=" <?php echo $lang_lineup_aunit; ?>" />
<meta property="og:image" content="<?php echo $lang_lineup_linkog; ?>" />
<title><?php echo $lang_program_lineup; ?></title>
<script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "SoftwareApplication",
"name": "Sport Lineup Program",
"image": "https://www.mindphp.com/images/info/mindphp-logo-v40.png",
"description": "โปรแกรมจัดรูปแบบแผนการเล่นฟุตบอล",
"operatingSystem": "Windows 7",
"applicationCategory": "http://schema.org/GameApplication",
"aggregateRating": {
"@type": "AggregateRating",
"ratingValue": "5.0",
"ratingCount": "1"
},
"offers": {
"@type": "Offer",
"price": "1.00",
"priceCurrency": "USD"
}
}
</script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/0.4.1/html2canvas.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://www.google.com/recaptcha/api.js" asyncdefer></script>
<link rel="stylesheet" href="cssblock/block.css" />
<link rel="stylesheet" href="cssblock/bootstrap-select.css" />
<script src="lineup_js/interact.min.js"></script>
<script src="lineup_js/jquery.min.js"></script>
<script src="lineup_js/bootstrap-select.js"></script>
<script src="./html2canvas.min.js" asyncdefer></script>
<?php
include '../header.php';
include '../PHP-Pagination-master/Pagination.class.php';
date_default_timezone_set("Asia/Bangkok");
$row = 10;
$page = 1;
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
//
$total_data = "SELECT count(id) FROM $datalineup";
$result_1 = mysqli_query($con, $total_data);
$total = mysqli_fetch_row($result_1);
$total_data = $total[0];
$Pagination = new
Pagination($page, $total_data);
$Pagination->parse();
$start = ($page - 1) * $row;
?>
<div class="container">
<div class="col-md-12">
<!--pathway-->
<div class="row">
<div class="btn-group btn-breadcrumb">
<a href="#" 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_sport_lineup; ?></a>
</div>
</div><br>
</div>
<div class="row">
<div class="col-md-4">
<!--menu-->
<?php include 'menu_sidebar.php'; ?>
</div>
<div class="col-md-8">
<div class="col-md-12">
<?php include 'script_facebook.php'; ?>
</div>
</div><br>
<div class="col-md-8">
<form method="post" action="" class="formsubmit" name="form">
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-heading"><b><?php echo $lang_sport_lineup; ?></b></div>
<div class="panel-body">
<div class="input-group">
<label class="input-group-addon alert-info"><?php echo $lang_username; ?> :</label>
<input type="text" required name="name_user" placeholder="<?php echo $lang_please_nameuser; ?>" class="form-control">
</div><br>
<div class="input-group">
<label class="input-group-addon alert-info"><?php echo $lang_sport_category; ?> :</label>
<select class="form selcate" name="selcate">
<option value=""><?php echo $lang_choose; ?></option>
<?php $sql_opcate = "SELECT * FROM $datalineup_sptcategory";
$result_opcate = mysqli_query($con, $sql_opcate);
while ($rowcate = mysqli_fetch_assoc($result_opcate)) {
$select_cate = ($lang == 'th') ? $rowcate['cate_name_th'] : $rowcate['cate_name_en']; ?>
<?php if ($rowcate['cate_id'] == 1) { ?>
<option value="<?php echo $rowcate['cate_id']; ?>" selected><?php echo $select_cate; ?></option>
<?php } else { ?>
<option value="<?php echo $rowcate['cate_id']; ?>"><?php echo $select_cate; ?></option>
<?php }
} ?>
</select>
</div> <br>
<div class="input-group">
<label class="input-group-addon alert-info"><?php echo $lang_your_ch_team; ?> :</label>
<select class="form selteam" name="selteam">
<option value=""><?php echo $lang_choose; ?></option>
<?php $sql_opteam = "SELECT * FROM $datalineup_team";
$result_opteam = mysqli_query($con, $sql_opteam);
while ($rowteam = mysqli_fetch_assoc($result_opteam)) {
$select_team = ($lang == 'th') ? $rowteam['team_name_th'] : $rowteam['team_name_en']; ?>
<option value="<?php echo $rowteam['team_id']; ?>"><?php echo $select_team; ?></option>
<?php } ?>
</select>
<label class="input-group-addon alert-info"><?php echo $lang_to; ?> :</label>
<select class="form selplan" name="selplan">
<?php $sql_opt_plan = "SELECT * FROM $datalineup_plan";
$result_opt_plan = mysqli_query($con, $sql_opt_plan);
while ($rowplan = mysqli_fetch_assoc($result_opt_plan)) { ?>
<option value="<?php echo $rowplan['plan_id']; ?>"> <?php echo $rowplan['plan_name']; ?></option>
<?php } ?>
</select>
<label class="input-group-addon alert-info"><?php echo $lang_ch_bg; ?> :</label>
<select class="form selbg" name="selbg">
<?php $sql_opbg = "SELECT * FROM $datalineup_bg";
$result_opbg = mysqli_query($con, $sql_opbg);
while ($rowbg = mysqli_fetch_assoc($result_opbg)) {
$select_bg = ($lang == 'th') ? $rowbg['bg_name_th'] : $rowbg['bg_name_en']; ?>
<option value="<?php echo $rowbg['bg_id']; ?>"><?php echo $select_bg; ?> </option>
<?php } ?>
</select>
</div><br>
<div class="text-center">
<button id="savepicture" name="savepicture" class="btn btn-info"> <?php echo $lang_savepicture; ?></button>
<input type="submit" name="saveandshare" class="btn btn-primary" value="<?php echo $lang_saveandshare; ?>" onclick="window.location = 'index.php?lang=<?php echo $lang; ?>';">
<input type="button" class="btn btn-primary" onclick="window.location = 'player.php?lang=<?php echo $lang; ?>';" value="<?php echo $lang_data_player; ?>">
</div><br>
<div class="inputposition" style="display:none;"></div>
<div class="lpposit"></div>
<div class="drag-container" align="center">
<div id="drag-container">
<div class="logo_team" style="display:none;">
<img class="logoteam" src="">
</div>
<div class="namecoach" style="display:none;">
<img class="coachimage" src="">
<p></p>
</div>
<?php
$sql_opt_position = "SELECT * FROM $datalineup_position WHERE plan_id = 1 ";
$result_opt_position = mysqli_query($con, $sql_opt_position);
while ($rowposition = mysqli_fetch_assoc($result_opt_position)) { ?>
<div class="draggable" id="po_<?php echo $rowposition['pst_posit']; ?>" style="transform: translate(<?php echo $rowposition['pst_x'] . 'px'; ?> ,
<?php echo $rowposition['pst_y'] . 'px'; ?>);" data-x="<?php echo $rowposition['pst_x']; ?>" data-y="<?php echo $rowposition['pst_y']; ?>">
<p id="shw_nameply"> <?php echo $rowposition["pst_name"]; ?></p>
<div class="showplayer"></div>
<input type="hidden" class="setplayer" name="setplayer[]">
<input type="hidden" class="setposit" name="setposit[]" value="<?php echo $rowposition["pst_posit"]; ?>">
</div>
<?php } ?>
<p class="powerby">Power by Mindphp</p>
</div>
</div>
<div id="img" style="display:none;">
<img src="/" id="newimg" class="logo_team" />
</div>
<script>
$(function() {
$("#savepicture").click(function() {
html2canvas($("#drag-container"), {
onrendered: function(canvas) {
var imgsrc = canvas.toDataURL("image/png");
console.log(imgsrc);
$("#newimg").attr('src', imgsrc);
$("#img").show();
var dataURL = canvas.toDataURL();
$.ajax({
type: "POST",
url: "script.php",
data: {
imgBase64: dataURL
}
}).done(function(o) {
console.log('saved');
});
}
});
});
});
</script>
<div class="modal fade" id="myModal" role="dialog">
<div class="modal-dialog modal-sm">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"><?php echo $rowposition["pst_name"]; ?></h4>
</div>
<?php
$sql_play = "SELECT * FROM $datalineup_player WHERE team_id = 1 ";
$rstplay = mysqli_query($con, $sql_play);
?>
<div class="modal-body">
<select class="selectpicker" id="name_player" name="">
<?php while ($r_play = mysqli_fetch_assoc($rstplay)) {
$langplayname = ($lang == 'th') ? $r_play['play_name_th'] : $r_play['play_name_en']; ?>
<option value="<?php echo $r_play['play_id']; ?>" data-thumbnail="player_image/<?php echo $r_play['play_img']; ?>">
<span> <?php echo $langplayname; ?></span>
<span><?php echo $r_play["play_num"]; ?></span>
</option>
<?php } ?>
</select>
<input type="hidden" id="blockid">
</div>
<div class="modal-footer">
<a class="btn btn-primary popup_submit"><?php echo $lang_popup_submit; ?></a>
<button type="button" class="btn btn-default" data-dismiss="modal"><?php echo $lang_popup_close; ?></button>
</div>
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function() {
html2canvas(document.querySelector(".drag-container")).then(canvas => {
document.getElementById("mycanvas").appendChild(canvas);
var canvas = $("#mycanvas canvas");
var img = canvas[0].toDataURL("image/png");
$.ajax({
type: "POST",
url: "creaimg.php",
data: {
img: img
},
success: function(data) {}
});
});
$('.draggable').click(function() {
$('#myModal').modal('show');
$('#blockid').val($(this).attr('id'));
});
$('.popup_submit').click(function() {
var selvalue = $('.selectpicker').val();
var check = true;
$.each($('.drag-container .setplayer'), function() {
// console.log ($(this).val());
var set = $(this).val();
if (selvalue == set) {
alert("<?php echo $lang_selected_player; ?>");
check = false;
}
});
if (check == true) {
var blockid = $('#blockid').val();
var img = $('.selectpicker option:selected').attr('data-thumbnail');
var img_show = '<img src="./' + img + '" alt="Smiley face" height="42" width="42"><br>'
$('#' + blockid + ' .setplayer').val(selvalue);
$('#' + blockid + ' .showplayer').html(img_show);
$('#' + blockid + ' .showplayer').append($('.selectpicker option:selected').text());
// $('#'+blockid).css("background", "none");
// $('#'+blockid+' #shw_nameply').css("display", "none");
$('#myModal').modal('hide');
// $('.selectpicker').selectpicker('refresh');
}
});
setposition();
function setposition() {
$.each($('.drag-container .draggable'), function() {
$('.inputposition').append('<input type"hidden" name="intarr[]" value="' + $(this).attr('data-y') + ',' + $(this).attr('data-x') + '" >');
});
}
$(".selplan").change(function() {
var plan_id = $(".selplan").val();
$.ajax({
type: "POST",
url: "post.php",
data: {
plan: plan_id
},
success: function(data) {
$('.showplayer').html('');
$('.inputposition').html('<input type"hidden" name="intarr[]" value="" >');
$.each(data, function() {
// console.log(this);
var pname = (this.pst_name);
var py = (this.pst_y);
var px = (this.pst_x);
var pp = (this.pst_posit);
$('#po_' + pp).attr('data-x', px);
$('#po_' + pp).attr('data-y', py);
$('#po_' + pp).attr('style', 'transform: translate(' + px + 'px, ' + py + 'px)');
$('#po_' + pp + ' #shw_nameply').html(pname);
$('.inputposition').append('<input type"hidden" name="intarr[]" value="' + px + ',' + py + '" >');
// console.log(pp+' = '+pname+' '+px+' '+py);
});
}
});
});
$(".selbg").change(function() {
var bg_id = $(".selbg").val();
$.ajax({
type: "POST",
url: "post2.php",
data: {
bg: bg_id
},
success: function(data) {
// console.log(data);
$(".drag-container").css("background-image", "url('background_image/" + data + "')");
}
});
});
$(".selteam").change(function() {
var team_id = $(".selteam").val();
var lang = '<?php echo $lang; ?>';
$.ajax({
type: "POST",
url: "selectteam.php",
data: {
team: team_id
},
success: function(data) {
$.each(data, function() {
// console.log(lang);
var team_id = (this.team_id);
var team_logo = (this.team_logo);
var coach_name_en = (this.coach_name_en);
var coach_name_th = (this.coach_name_th);
var coach_image = (this.coach_image);
$('.logo_team img').attr("src", "teamlogo_image/" + team_logo + "");
$('.logo_team').css("display", "unset");
$('.namecoach img').attr("src", "coach_image/" + coach_image + "");
$('.namecoach').css("display", "unset");
if (lang == 'th') {
$('.namecoach p').text(coach_name_th);
} else {
$('.namecoach p').text(coach_name_en);
}
});
}
});
});
interact('.draggable').draggable({
autoScroll: true,
inertia: true,
onmove: window.dragMoveListener,
restrict: {
restriction: 'parent',
elementRect: {
top: 0,
left: 0,
bottom: 1,
right: 1
}
},
onmove: function(event) {
var target = event.target;
var x = (parseFloat(target.getAttribute('data-x')) || 0) + event.dx;
var y = (parseFloat(target.getAttribute('data-y')) || 0) + event.dy;
target.style.webkitTransform =
target.style.transform =
'translate(' + x + 'px, ' + y + 'px)';
target.setAttribute('data-x', x);
target.setAttribute('data-y', y);
}
});
}); //ready
</script>
<div class="table-responsive" align="center">
<br>
<textarea name="tactics_comments" required rows="4" cols="85" placeholder="<?php echo $lang_comments; ?>"></textarea>
</div>
<div class="table-responsive" align="center">
<br>
<div align="center" class="g-recaptcha" required data-sitekey="<?php echo $keyrecaptcha; ?>"></div><br>
</div>
<div class="text-center">
<input type="submit" name="submit" id="submit" class="btn btn-success" value="<?php echo $lang_save_history; ?>">
<input type="reset" name="reset" class="btn btn-warning" value="<?php echo $lang_reset; ?>" onclick="window.location = 'index.php?lang=<?php echo $lang; ?>';">
</div>
<?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) { ?>
<br>
<div align="center" class="unnit-color"><b><?php print_r($lang_automatedprogram) ?></b></div>
<?php }
} ?>
<?php
if (isset($_POST['submit']) && $response['success'] == true) {
$name_user = $_POST['name_user'];
$name = htmlspecialchars($name_user);
$selteam = $_POST['selteam'];
$selplan = $_POST['selplan'];
$selcate = $_POST['selcate'];
$selbg = $_POST['selbg'];
date_default_timezone_set("Asia/Bangkok");
$date = time();
$time = date("Y-m-d H:i:s", time());
$ip = $_SERVER["REMOTE_ADDR"];
$setplayer = $_POST['setplayer'];
$intarr = $_POST['intarr'];
$comments = htmlspecialchars($_POST['tactics_comments']);
$setposit = $_POST['setposit'];
$name2 = str_replace("'", '', $name);
$comments2 = str_replace("'", '', $comments);
$sql = "INSERT INTO $datalineup (name_user,team_user_id,plan_user_id,bg_user_id,cate_user_id,create_time,ip)
VALUES ('$name2','$selteam','$selplan','$selbg','$selcate','$time','$ip')";
//echo $sql; exit();
mysqli_query($con, $sql) or die(mysqli_error($con)); //mysqli_error($con)
$getid = mysqli_insert_id($con);
$sql_logs = "INSERT INTO $datalineup_logs (lineup_id,logs_team_id,logs_plan_id,logs_cate_id,logs_bg_id,logs_comments)
VALUES ('$getid','$selteam','$selplan','$selcate','$selbg','$comments2')";
mysqli_query($con, $sql_logs) or die(mysqli_error($con)); //$lang_datecannot
$logid = mysqli_insert_id($con);
$i;
$j;
if ($intarr[0] == '') {
$i = 1;
$j = 1;
for ($i; $i < count($intarr); $i++) {
$ex[$i] = explode(",", $intarr[$i]);
$valex = $ex[$i][0];
$valey = $ex[$i][1];
$play_id = $setplayer[$i - $j];
$posit_id = $setposit[$i - $j];
$sql_logs_position = "INSERT INTO $datalineup_positionlogs (logs_id,logs_play_id,logs_posit_id,logs_position_x,logs_position_y)
VALUES ('$logid','$play_id','$posit_id','$valex','$valey')";
mysqli_query($con, $sql_logs_position) or die(mysqli_error($con));
}
} else {
$i = 0;
$j = 0;
for ($i; $i < count($intarr); $i++) {
$ex[$i] = explode(",", $intarr[$i]);
$valey = $ex[$i][0];
$valex = $ex[$i][1];
$play_id = $setplayer[$i - $j];
$posit_id = $setposit[$i - $j];
$sql_logs_position = "INSERT INTO $datalineup_positionlogs (logs_id,logs_play_id,logs_posit_id,logs_position_x,logs_position_y)
VALUES ('$logid','$play_id','$posit_id','$valex','$valey')";
mysqli_query($con, $sql_logs_position) or die(mysqli_error($con));
}
}
?>
<!-- show background -->
<?php $sql_show_bg = "SELECT * FROM $datalineup_logs AS logsbg INNER JOIN $datalineup_bg AS bgshow ON logsbg.logs_bg_id = bgshow.bg_id WHERE logsbg.lineup_id = $getid";
$re_bg = mysqli_query($con, $sql_show_bg);
$get_bg = mysqli_fetch_assoc($re_bg);
?>
<style media="screen">
.drag-container-show {
background-image: url('background_image/<?php echo $get_bg['bg_file']; ?>');
}
</style>
<!-- show background -->
<br>
<?php $sql_logs_result = "SELECT * FROM $datalineup_logs AS getlogs
LEFT JOIN $datalineup_positionlogs AS getpologs ON getlogs.logs_id = getpologs.logs_id
LEFT JOIN $datalineup_player AS play ON getpologs.logs_play_id = play.play_id
LEFT JOIN $datalineup_position AS posit ON getpologs.logs_posit_id = posit.pst_id
WHERE getlogs.lineup_id = $getid ";
$result_logs = mysqli_query($con, $sql_logs_result);
$sql_select_team = "SELECT * FROM $datalineup_team AS team
INNER JOIN $datalineup AS lineup ON team.team_id = lineup.team_user_id
INNER JOIN $datalineup_coach AS coach ON team.team_id = coach.team_id
WHERE lineup.id = $getid";
$result_select_team = mysqli_query($con, $sql_select_team);
$teaminfo = mysqli_fetch_assoc($result_select_team);
$coachName = ($lang == 'th') ? $teaminfo['coach_name_th'] : $teaminfo['coach_name_en'];
$teamName = ($lang == 'th') ? $teaminfo['team_name_th'] : $teaminfo['team_name_en'];
?>
<div class="drag-container-show" align="center">
<div class="logo_team">
<img id="logoteam" src="teamlogo_image/<?php echo $teaminfo['team_logo']; ?>" alt="">
</div>
<div class="namecoach">
<img id="" src="coach_image/<?php echo $teaminfo['coach_image']; ?>" alt="">
<p><?php echo $coachName; ?></p>
</div>
<div class="nameteam">
<p><?php echo $teamName; ?></p>
</div>
<?php while ($rowlogs = mysqli_fetch_assoc($result_logs)) {
$playerName = ($lang == 'th') ? $rowlogs['play_name_th'] : $rowlogs['play_name_en'];
$playerimg = ($rowlogs['play_img'] == '') ? 'human.jpg' : $rowlogs['play_img']; ?>
<div class="draggable-show" style="transform: translate(<?php echo $rowlogs['logs_position_x'] . 'px'; ?> ,
<?php echo $rowlogs['logs_position_y'] . 'px'; ?>);" data-x="<?php echo $rowlogs['logs_position_x']; ?>" data-y="<?php echo $rowlogs['logs_position_y']; ?>">
<p><?php echo $rowlogs["pst_name"]; ?></p>
<div class="">
<img src="player_image/<?php echo $playerimg ?>"><br>
<span><?php echo $playerName; ?> <?php echo $rowlogs['play_num']; ?></span>
</div>
</div>
<?php } ?>
<div class="divpowerby">
<p class="powerby-show">Power by Mindphp</p>
</div>
</div>
<div class="text-center">
<h3><?php echo $lang_userinformation; ?></h3>
<table class="table">
<tbody>
<tr class="active">
<td align="right" width="50%">
<b> <?php echo $lang_username; ?> :</b>
</td>
<td>
<?php echo $name; ?>
</td>
</tr>
<tr class="warning">
<td align="right" width="50%">
<b><?php echo $lang_yourcate; ?></b>
</td>
<?php $selcate_sql = "SELECT cate_name_th ,cate_name_en FROM $datalineup_sptcategory WHERE cate_id = $selcate ";
$rst_selcate = mysqli_query($con, $selcate_sql);
$rw_selcate = mysqli_fetch_assoc($rst_selcate);
$cate = ($lang == 'th') ? $rw_selcate['cate_name_th'] : $rw_selcate['cate_name_en'];
?>
<td>
<?php echo $cate; ?>
</td>
</tr>
<tr class="active">
<td align="right" width="50%">
<b> <?php echo $lang_yourcoach; ?> :</b>
</td>
<td><?php echo $coachName; ?></td>
</tr>
<tr class="warning">
<td align="right" width="50%">
<b> <?php echo $lang_yourteam; ?> :</b>
</td>
<?php $selteam_sql = "SELECT team_name_th ,team_name_en FROM $datalineup_team WHERE team_id = $selteam ";
$rst_selteam = mysqli_query($con, $selteam_sql);
$rw_selteam = mysqli_fetch_assoc($rst_selteam);
$team = ($lang == 'th') ? $rw_selteam['team_name_th'] : $rw_selteam['team_name_en'];
?>
<td>
<?php echo $team; ?>
</td>
</tr>
<tr class="active">
<td align="right" width="50%">
<b> <?php echo $lang_formation; ?> :</b>
</td>
<?php $selplan_sql = "SELECT plan_name FROM $datalineup_plan WHERE plan_id = '$selplan' ";
$rst_selplan = mysqli_query($con, $selplan_sql);
$rw_selplan = mysqli_fetch_assoc($rst_selplan);
$plan = $rw_selplan['plan_name'];
?>
<td>
<?php echo $rw_selplan['plan_name']; ?>
</td>
</tr>
<tr class="warning">
<td align="right" width="50%">
<b> <?php echo $lang_your_bg; ?> :</b>
</td>
<?php $selbg_sql = "SELECT bg_name_th,bg_name_en FROM $datalineup_bg WHERE bg_id = '$selbg' ";
$rst_selbg = mysqli_query($con, $selbg_sql);
$rw_selbg = mysqli_fetch_assoc($rst_selbg);
$bg = ($lang == 'th') ? $rw_selbg['bg_name_th'] : $rw_selbg['bg_name_en'];
?>
<td>
<?php echo $bg; ?>
</td>
</tr>
<tr class="active">
<td align="right" width="50%">
<b><?php echo $lang_tactic_comments; ?> :</b>
</td>
<td>
<p style="width: 20em; word-wrap: break-word;"><?php echo $comments; ?></p>
</td>
</tr>
<tr class="warning">
<td align="right" width="50%">
<b> <?php echo $lang_accesstime; ?> :</b>
</td>
<td>
<?php echo date("Y-m-d H:i:s", time()); ?>
</td>
</tr>
<tr class="active">
<td align="right" width="50%">
<b> <?php echo $lang_yourip; ?> :</b>
</td>
<td>
<?php echo $ip; ?>
</td>
</tr>
</tbody>
</table>
</div>
<?php } ?>
<br>
<br>
<div align="right"><?php echo $lang_vercheckpace . " " . $version; ?> <br><br></div>
</div>
</div>
</div>
</form>
<?php include 'tags.php'; ?>
<div class="well2">
<br>
<ul>
<b><?php echo $lang_step_how ?></b>
<li><?php echo $lang_inputname_usere ?> <b><?php echo $lang_username ?></b></li>
<li><?php echo $lang_choose_root ?> <b> <?php echo $lang_your_ch_team ?> </b></li>
<li><?php echo $lang_arr_inter ?> <b> <?php echo $lang_formation ?> </b></li>
<li><?php echo $lang_lang_putbtt ?></li>
</ul>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 well well-lg">
<?php include 'content.php'; ?>
</div>
</div>
<div class="row">
<div class="col-md-12" align="center">
<h3 align="center"><?php echo $lang_recentinforma; ?></h3>
<table class="table table-striped">
<thead>
<tr class="bg-primary">
<th>
<p align="center"><?php echo $lang_idnumber; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_username; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_yourcate; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_yourteam; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_formation; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_your_bg; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_accesstime; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_yourip; ?></p>
</th>
<th>
<p align="center"><?php echo $lang_displayinforma; ?></p>
</th>
</tr>
</thead>
<?php
$sql = "SELECT * FROM $datalineup AS users
LEFT JOIN $datalineup_team AS team ON users.team_user_id = team.team_id
LEFT JOIN $datalineup_plan AS plan ON users.plan_user_id = plan.plan_id
LEFT JOIN $datalineup_bg AS bg ON users.bg_user_id = bg.bg_id
LEFT JOIN $datalineup_sptcategory AS cate ON users.cate_user_id = cate.cate_id
ORDER BY users.id DESC LIMIT $start,$row";
$result = mysqli_query($con, $sql);
while ($fetch = mysqli_fetch_assoc($result)) {
?>
<tr align="center">
<td>
<?php echo $fetch['id']; ?>
</td>
<td>
<?php echo $fetch['name_user']; ?>
</td>
<td>
<?php if ($lang == 'th') {
echo $fetch['cate_name_th'];
} else {
echo $fetch['cate_name_en'];
}
?>
</td>
<td>
<?php if ($lang == 'th') {
echo $fetch['team_name_th'];
} else {
echo $fetch['team_name_en'];
}
?>
</td>
<td>
<?php echo $fetch['plan_name']; ?>
</td>
<td>
<?php if ($lang == 'th') {
echo $fetch['bg_name_th'];
} else {
echo $fetch['bg_name_en'];
} ?>
</td>
<td>
<?php echo $fetch['create_time']; ?>
</td>
<td><?php include 'ip.php'; ?></td>
<td>
<a href="showlineup.php?id=<?php echo $fetch['id']; ?>&lang=<?php echo $lang; ?>">
<i class="glyphicon glyphicon-new-window"></i>
</a>
</td>
</tr>
<?php
}
mysqli_close($con);
?>
</table>
<div class="text-center">
<nav aria-label="page navigation">
<?php echo $Pagination->parse(); ?>
</nav>
</div>
<input type="button" class="btn btn-primary" onclick="window.location = 'listlineup.php?lang=<?php echo $lang; ?>';" value="<?php echo $lang_seemore; ?>">
</div>
</div>
</div>
<?php include '../footer.php'; ?>