php passare variabile bootstrap modal
eccomi di nuovo qui a chiedere il vostro aiuto a capire ancora una volta un mio errore (?)
stò cercando di aprire in modal un insert ed ho fatto in questo modo
Codice PHP:
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#exampleModal-<?php echo $result[0]['id_cliente']; ?>">
Launch demo modal
</button>
<?php
require_once ("../config/db.php");
$db_handle = new DBController();
if(!empty($_POST["submitscalo"])) {
$query = "INSERT INTO scalo_punti (punti_scalo, data_scalo, premio, id_cliente)
VALUES('".$_POST["punti_scalo"]."','".$_POST["data_scalo"]."', '".$_POST["premio"]."', '".$_GET["id_cliente"]."')";
$result = $db_handle->executeQuery($query);
if(!$result){
$message="Problem in Adding to database. Please Retry.";
} else {
header("Location:clienteprofilo.php");
}
}
?>
<div class="modal fade" id="exampleModal-<?php echo $result[0]['id_cliente']; ?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel-<?php echo $result[0]['id_cliente']; ?>" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title"></h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<!-- Modal body -->
<div class="modal-body">
<?php
require_once("../config/db.php");
$db_handle = new DBController();
$result = $db_handle->runQuery("SELECT * FROM cliente WHERE id_cliente='" . $_GET["id_cliente"] . "'");
?>
<form method="post" action="">
<div class="form-group">
<label for="cliente">Nome:</label>
<input class="form-control" type="nome" name="nome" id="nome" disabled="disabled" placeholder="<?php echo $result[0]["nome"]; ?>" />
</div>
<div class="form-group">
<label for="cognome">Cognome:</label>
<input class="form-control" type="text" name="cognome" id="cognome" disabled="disabled" placeholder="<?php echo $result[0]["cognome"]; ?>"/>
</div>
<div class="form-group">
<label for="tessera">Numero Tessera:</label>
<input class="form-control" type="text" name="tessera" id="tessera" disabled="disabled" placeholder="<?php echo $result[0]["tessera"]; ?>"/>
</div>
<?php
include_once('../config/pdo.php');
$pdo->query('SET CHARACTER SET utf8');
$sql = "SELECT premio FROM premi";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$users = $stmt->fetchAll();
?>
<div class="form-group row">
<label class="col-form-label col-md-3 col-sm-3 label-align">Premio</label>
<div class="col-md-6 col-sm-6">
<select class="form-control" name="premio" required>
<option>Seleziona Premio</option>
<?php foreach($users as $user): ?>
<option value="<?= $user['premio']; ?>"> <?= $user['premio']; ?></option>
<?php endforeach; ?>
</select>
</div>
</div>
<?php
require_once("../config/db.php");
$db_handle = new DBController();
$result = $db_handle->runQuery("SELECT SUM(r.punti_scalo)-( SELECT SUM(s.punti) FROM punti AS s
WHERE r.id_cliente=s.id_cliente) as restanti, r.id_cliente FROM scalo_punti AS r
WHERE r.id_cliente='" . $_GET["id_cliente"] . "' GROUP BY r.id_cliente");
$row = $result[0];
$restanti = $row['restanti'];
?>
<?php if ($restanti >= 10) {
echo "seleziona il Buono Acquisto";
?>
<div class="form-group">
<label for="punti">Punti:</label>
<input class="form-control" type="text" id='punti_scalo' name="punti_scalo" required/>
</div>
<div class="form-group">
<label for="giorno">Data:</label>
<input class="form-control" type="date" id='data_scalo' value="<?php echo date('Y-m-d'); ?>" name="data_scalo" required/>
</div>
<input type="submit" name="submitscalo" id="btnAddAction" value="Salva" class="btn btn-dark"/>
</form>
<?php }
else {
echo "<div style='font-size:16px;text-align:center;'>
non ci sono abbastanza punti per poter ottenere un Buono Acquisto.</div>";
} ?>
</div>
<!-- Modal footer -->
<div class="modal-footer">
<button type="button" class="btn btn-danger" data-dismiss="modal">Annulla</button>
</div>
</div>
</div>
</div>
si apre senza alcun problema ma i campi sono vuoti
