Jeg kan ikke rigtigt finde en løsning ud fra det du skriver?
Vil nedenstående fil-indhold hjælpe med en forståelse? Det er heller ikke hver gang at det er muligt at gemme data i databasen - ofte problematisk når man tilgår siden via en mobil eller tablet.
JSON:
<?php
require('connection.php');
$json = array();
$action = isset($_GET['action']) ? $_GET['action'] : false;
switch($action){
case 'members':
$hold = isset($_GET['hold']) ? intval($_GET['hold']) : 0;
# Aldersgrupper
$ages = array();
if ($result = $conn->query("SELECT * FROM tbl_age ORDER BY id")){
while ($row = $result->fetch_object()){
$age = array(
'name' => $row->name,
'from' => $row->age_from,
'to' => $row->age_to
);
$ages[] = $age;
}
$result->close();
}
$dates_id = array();
$members_id = array();
# Næste træninger
$dates = array();
if ($stmt = $conn->prepare("SELECT `id`, `date`
FROM `tbl_traeninger`
WHERE `date` >= CURDATE() AND hold_id = ?
ORDER BY date LIMIT 1")) {
$stmt->bind_param("i", $hold);
$stmt->execute();
$stmt->bind_result($id, $date);
while ($stmt->fetch()){
$my_date = array(
'id' => $id,
'date' => date('d-m-Y', strtotime($date)),
);
$dates_id[] = $id;
$dates[] = $my_date;
}
$result->close();
}
$useragent=$_SERVER['HTTP_USER_AGENT'];
if(!preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows ce|xda|xiino/i',$useragent)||preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i',substr($useragent,0,4)))
{
if ($stmt = $conn->prepare("SELECT `id`, `date`
FROM `tbl_traeninger`
WHERE `date` < CURDATE() AND hold_id = ?
ORDER BY date DESC LIMIT 4")) {
$stmt->bind_param("i", $hold);
$stmt->execute();
$stmt->bind_result($id, $date);
while ($stmt->fetch()){
$my_date = array(
'id' => $id,
'date' => date('d-m-Y', strtotime($date)),
);
$dates_id[] = $id;
$dates[] = $my_date;
}
$result->close();
}
}
$today = new DateTime('today');
$members = array();
# Members
if ($stmt = $conn->prepare("SELECT
tm.id,
tm.fornavn,
tm.efternavn,
tm.dob
FROM tbl_medlem tm
INNER JOIN tbl_map_medlem_hold tmmh
ON tm.id = tmmh.medlem_id
WHERE tmmh.hold_id = ? ORDER BY tm.fornavn, tm.efternavn")) {
$stmt->bind_param("i", $hold);
$stmt->execute();
$stmt->bind_result($id, $fornavn, $efternavn, $dob);
while ($stmt->fetch()){
$member = array();
$member['id'] = $id;
$members_id[] = $id;
$member['fornavn'] = $fornavn;
$member['efternavn'] = $efternavn;
# Calculate age
$dob = new DateTime($dob);
$age1 = $dob->diff($today)->y;
$member['age'] = $age1;
foreach($ages as $a){
if($age >= $a['from'] && $age <= $a['to']){
$member['age_group'] = $a['name'];
}
}
$members[] = $member;
}
$stmt->close();
}
$workouts_status = array();
# Workout status
if($result = $conn->query("SELECT medlem_id, training_id FROM `tbl_map_medlem_traeninger` WHERE `medlem_id` IN (".implode(',', $members_id).") AND `training_id` IN (".implode(',', $dates_id).")")){
while ($row = $result->fetch_object()){
$medlem_id = $row->medlem_id;
$training_id = $row->training_id;
if(array_key_exists($medlem_id, $workouts_status)){
$workouts_status[$medlem_id][] = $training_id;
}else{
$workouts_status[$medlem_id] = array($training_id);
}
}
}
# DEBUG
#$json['workouts_status'] = $workouts_status;
$new_members = array();
# Number of workouts
foreach($members as $member){
$member_id = $member['id'];
$antal = 0;
if ($stmt = $conn->prepare("SELECT
count(*) AS antal
FROM `tbl_traeninger` tt
INNER JOIN `tbl_map_medlem_traeninger` tmmt
ON tmmt.training_id = tt.id
WHERE tt.hold_id = ? AND tmmt.medlem_id = ?")) {
$stmt->bind_param("ii", $member_id, $hold);
$stmt->execute();
$stmt->bind_result($antal);
$stmt->fetch();
}
$member['antal'] = $antal;
$workout_status = array();
foreach($dates as $date){
$date_id = $date['id'];
$date_status = FALSE;
if(array_key_exists($member_id, $workouts_status)){
if(in_array($date_id, $workouts_status[$member_id])){
$date_status = TRUE;
}
}
$workout_status[] = array('date_id' => $date_id, 'status' => $date_status);
}
$member['workouts'] = $workout_status;
$new_members[] = $member;
}
$json['members'] = $new_members;
$json['dates'] = $dates;
break;
}
$conn->close();
header("Content-type:application/json");
echo json_encode($json);
?>
INDEX:
<script type="text/javascript">
$(document).ready(function () {
$("#createMember").click(function(){
var data = $("#memberForm").serialize();
$.post("savemember.php", {'data': data}, function(json){
});
});
$("#save_workouts").click(function(){
var data = $("#myForm").serialize();
$.post("savedata.php", {'data': data}, function(json){
});
});
$("#team").change(function () {
var team = $("#team").val();
$.get( "json.php", {action: "members", hold: team}, function( data ) {
var dates = '';
$.each(data.dates, function (index, item) {
dates += '<th class="dynamic_date">' + item.date + '</th>';
});
var tbody = '';
var myVar = 1;
$.each(data.members, function (index, item) {
tbody += '<tr>';
tbody += '<td align="left">' + myVar++ + '</td>';
tbody += '<td align="left">' + '<a href="#myModal" data-toggle="modal" data-target="#edit-modal" id="' + item.id + '">' + item.fornavn + ' ' + item.efternavn +'</a></td>';
tbody += '<td align="left">' + item.age + '</td>';
$.each(item.workouts, function (index, date) {
$.each(data.dates, function (index, item) {
var today = new Date();
var dd = today.getDate();
var mm = today.getMonth()+1;
var yyyy = today.getFullYear();
if(dd<10) {
dd = '0'+dd;
}
if(mm<10) {
mm = '0'+mm;
}
today = dd + '-' + mm + '-' + yyyy;
var disableText = item.date >= today ? '' : ' disabled="disabled"';
var checkedText = date.status ? ' checked="checked"' : '';
var tdText = [
'<td align="left" style="width:10%;">',
'<input type="checkbox" class="custom-control-input" name="member_', item.id, '[]"',
' value="', date.date_id, '"',
checkedText,
disableText,
'></td>'
].join('');
tbody += tdText;
});
});
tbody += '<td></td>';
tbody += '</tr>';
});
$(".dynamic_date").remove();
$(dates).insertBefore("#numbers_of");
$('#myTable tbody').html(tbody);
}, 'json');
});
});
</script>
SAVEDATA:
<?php
require('connection.php');
$json = array();
$params = array();
parse_str($_POST['data'], $params);
$json['params'] = $params;
foreach($params as $key => $value){
$member = str_replace("member_", "", $key);
foreach($value as $workout){
if ($stmt = $conn->prepare("INSERT INTO `tbl_map_medlem_traeninger`
VALUES(null,?,?)")) {
$stmt->bind_param("ii", $member, $workout);
$stmt->execute();
$stmt->close();
}
}
$json['status'] = "Members updated";
}
$conn->close();
header("Content-type:application/json");
?>
