<?php
$turno = $_POST['idctg_turno'];
$entrada = new DateTime($_POST['hr_entrada']);
$salida = new DateTime($_POST['hr_salida']);
$arraydia = $_POST['idctg_dia'];
$mysqli = new mysqli("localhost", "root", "", "admon");
if ($stmt = $mysqli->prepare("INSERT INTO ctg_horario (idctg_turno, hr_entrada, hr_salida, idctg_dia) VALUES (?,?,?,?)")) {
// Iteramos el array y como ya preparamos la sentencia
//solo bindeamos los parámetros
for ($i=0; $i < count($arraydia) ; $i++) {
//bindeamos los parámetros para la query
// Obteniendo el elemento del array idctg_dia
$stmt->bind_param("ssss", $turno,$entrada,$salida,$arraydia[$i]);
$stmt->execute();
}
}
?>
<html lang="es">
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-theme.css" rel="stylesheet">
<script src="js/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</head>
</html>Good morning I made a form that is a schedule for workers, in this form what I need is that you select the checkbox of the day and enter the data of the entrance and exit for any day that I want. Send my form to my BD only the shift and the day but do not insert my time of entry and exit.
Thanks / Regards.
<html lang="es">
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-theme.css" rel="stylesheet">
<script src="js/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<div class="row">
<h3 style="text-align:center">NUEVO REGISTRO</h3>
</div>
<form class="form-horizontal" method="POST" action="guardar.php" autocomplete="off">
<div class="form-group">
<label for="idctg_turno" class="col-sm-2 control-label">Turno</label>
<?php
require("connect_db.php");
$query = "SELECT DISTINCT idctg_turno, descripcion FROM ctg_turno";
$res = $mysqli->query($query);
$option = '';
while ($row = $res->fetch_assoc()){
$option.="<option value=\"$row[idctg_turno]\">$row[descripcion] </option>";
}
?>
<div class="col-sm-10">
<select type="text" class="form-control" id="idctg_turno" name="idctg_turno" placeholder="Turno" required >
<option value="-">Selecciona el Turno</option>
<?php echo $option; ?>
</select><br /><br /></div></div>
<div class="form-group">
<label for="idctg_dia" class="col-sm-2 control-label">Día</label>
<div class="col-sm-10">
<label class="checkbox-inline">
<input type="checkbox" id="idctg_dia[]" name="idctg_dia[]" value="1"> Lunes
</label>
</div>
</div>
<div class="form-group">
<label for="hr_entrada" class="col-sm-2 control-label">Hora Entrada</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_entrada" name="hr_entrada" placeholder="hr_entrada" >
</div>
</div>
<div class="form-group">
<label for="hr_salida" class="col-sm-2 control-label">Hora Salida</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_salida" name="hr_salida" placeholder="hr_salida">
</div>
</div>
<div class="form-group">
<label for="idctg_dia" class="col-sm-2 control-label">Día</label>
<div class="col-sm-10">
<label class="checkbox-inline">
<input type="checkbox" id="idctg_dia[]" name="idctg_dia[]" value="2"> Martes
</label>
</div>
</div>
<div class="form-group">
<label for="hr_entrada" class="col-sm-2 control-label">Hora Entrada</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_entrada" name="hr_entrada" placeholder="hr_entrada" >
</div>
</div>
<div class="form-group">
<label for="hr_salida" class="col-sm-2 control-label">Hora Salida</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_salida" name="hr_salida" placeholder="hr_salida">
</div>
</div>
<div class="form-group">
<label for="idctg_dia" class="col-sm-2 control-label">Día</label>
<div class="col-sm-10">
<label class="checkbox-inline">
<input type="checkbox" id="idctg_dia[]" name="idctg_dia[]" value="3">Miercoles
</label>
</div>
</div>
<div class="form-group">
<label for="hr_entrada" class="col-sm-2 control-label">Hora Entrada</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_entrada" name="hr_entrada" placeholder="hr_entrada" >
</div>
</div>
<div class="form-group">
<label for="hr_salida" class="col-sm-2 control-label">Hora Salida</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_salida" name="hr_salida" placeholder="hr_salida">
</div>
</div>
<div class="form-group">
<label for="idctg_dia" class="col-sm-2 control-label">Día</label>
<div class="col-sm-10">
<label class="checkbox-inline">
<input type="checkbox" id="idctg_dia[]" name="idctg_dia[]" value="4"> Jueves
</label>
</div>
</div>
<div class="form-group">
<label for="hr_entrada" class="col-sm-2 control-label">Hora Entrada</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_entrada" name="hr_entrada" placeholder="hr_entrada" >
</div>
</div>
<div class="form-group">
<label for="hr_salida" class="col-sm-2 control-label">Hora Salida</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_salida" name="hr_salida" placeholder="hr_salida">
</div>
</div>
<div class="form-group">
<label for="idctg_dia" class="col-sm-2 control-label">Día</label>
<div class="col-sm-10">
<label class="checkbox-inline">
<input type="checkbox" id="idctg_dia[]" name="idctg_dia[]" value="5"> Viernes
</label>
</div>
</div>
<div class="form-group">
<label for="hr_entrada" class="col-sm-2 control-label">Hora Entrada</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_entrada" name="hr_entrada" placeholder="hr_entrada" >
</div>
</div>
<div class="form-group">
<label for="hr_salida" class="col-sm-2 control-label">Hora Salida</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_salida" name="hr_salida" placeholder="hr_salida">
</div>
</div>
<div class="form-group">
<label for="idctg_dia" class="col-sm-2 control-label">Día</label>
<div class="col-sm-10">
<label class="checkbox-inline">
<input type="checkbox" id="idctg_dia[]" name="idctg_dia[]" value="6"> Sabado
</label>
</div>
</div>
<div class="form-group">
<label for="hr_entrada" class="col-sm-2 control-label">Hora Entrada</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_entrada" name="hr_entrada" placeholder="hr_entrada" >
</div>
</div>
<div class="form-group">
<label for="hr_salida" class="col-sm-2 control-label">Hora Salida</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_salida" name="hr_salida" placeholder="hr_salida">
</div>
</div>
<div class="form-group">
<label for="idctg_dia" class="col-sm-2 control-label">Día</label>
<div class="col-sm-10">
<label class="checkbox-inline">
<input type="checkbox" id="idctg_dia[]" name="idctg_dia[]" value="8"> Domingo
</label>
</div>
</div>
<div class="form-group">
<label for="hr_entrada" class="col-sm-2 control-label">Hora Entrada</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_entrada" name="hr_entrada" placeholder="hr_entrada" >
</div>
</div>
<div class="form-group">
<label for="hr_salida" class="col-sm-2 control-label">Hora Salida</label>
<div class="col-sm-10">
<input type="time" class="form-control" id="hr_salida" name="hr_salida" placeholder="hr_salida">
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<a href="index.php" class="btn btn-default">Regresar</a>
<button type="submit" class="btn btn-primary">Guardar</button>
</div>
</div>
</form>
</div>
</body>
</html>
<?php
$turno = $_POST['idctg_turno'];
$entrada = $_POST['hr_entrada'];
$salida =$_POST['hr_salida'];
$arraydia = $_POST['idctg_dia'];
$mysqli = new mysqli("localhost", "root", "", "admon");
if ($stmt = $mysqli->prepare("INSERT INTO ctg_horario (idctg_turno, hr_entrada, hr_salida, idctg_dia) VALUES (?,?,?,?)")) {
// Iteramos el array y como ya preparamos la sentencia
//solo bindeamos los parámetros
for ($i=0; $i < count($arraydia) ; $i++) {
//bindeamos los parámetros para la query
// Obteniendo el elemento del array idctg_dia
$stmt->bind_param("ssss", $turno,$entrada,$salida,$arraydia[$i]);
$stmt->execute();
}
}
?>
<html lang="es">
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-theme.css" rel="stylesheet">
<script src="js/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</head>
</html>