I want to use this form with multiple select box to put data to database. I can put all data, but I can't put selections. What I am missing?
HTML FORM:
PHP FORM:
HTML FORM:
Code:
<form action="insertcheckbox.php" method="POST">
<div class="modal-body">
<div class="form-group">
<label> Ime i Prezime </label>
<input type="text" name="ime" class="form-control" placeholder="Upišite Ime i Prezime">
</div>
<div class="form-group">
<label> Upišite Spol </label>
<input type="text" name="spol" class="form-control" placeholder="Upišite Spol (M/Ž)">
</div>
<div class="form-group">
<label>Grad</label>
<input style="font-style: #f89900" type="text" name="grad" class="form-control" placeholder="Upišite Grad iz kojeg dolazi Student">
</div>
<div class="form-group">
<label>Telefon</label>
<input style="font-style: #f89900" type="text" name="tel" class="form-control" placeholder="Upišite Telefon">
</div>
<div class="form-group">
<label>Email</label>
<input style="font-style: #f89900" type="email" name="email" class="form-control" placeholder="Upišite Email">
</div>
<div class="form-group">
<label>Uzrast</label>
<input style="font-style: #f89900" type="text" name="uzrast" class="form-control" placeholder="Upišite Uzrast">
</div>
<div class="form-group">
<label>Škola</label>
<input style="font-style: #f89900" type="text" name="skola" class="form-control" placeholder="Upišite Obrazovnu Ustanovu">
</div>
<div class="form-group">
<label>Izaberite Programe sa liste</label>
<select name="naziv[]" id="naziv" class="form-control action" multiple="">
<option disabled selected>-- Izaberi Program --</option>
<?php
include "config/database.php"; // Using database connection file here
$records = mysqli_query($conn, "SELECT naziv FROM program"); // Use select query here
while($data = mysqli_fetch_array($records))
{
echo "<option value='". $data['naziv'] ."'>" .$data['naziv'] ."</option>"; // displaying data in option menu
}
?>
</select>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Zatvori</button>
<button type="submit" value="submit" name="registerbtn" class="btn btn-primary">Pošalji</button>
</div>
</form>
Code:
<?php
include_once 'config/database.php';
if(isset($_POST['Register']))
{
$ime = $_POST['ime'];
$spol = $_POST['spol'];
$grad = $_POST['grad'];
$tel = $_POST['tel'];
$email = $_POST['email'];
$uzrast = $_POST['uzrast'];
$skola = $_POST['skola'];
$naziv = $_POST['naziv'];
$sql = "INSERT INTO students (ime, spol, grad, tel, email, uzrast, skola, naziv)
VALUES ('$ime','$spol','$grad','$tel', '$email', '$uzrast', '$skola', '$naziv')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully !";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
}
?>
Comment