This is PHP.
<?php
include 'connect.php';
if (isset($_POST['add'])) {
$id = 'NULL';
$Branch = $_POST['Branch'];
$check = mysqli_query($connect, "SELECT * FROM staff WHERE id='$id'");
if (0 == mysqli_num_rows($check)) {
if (1 == 1) {
$insert = mysqli_query($connect, "INSERT INTO staff(Branch) VALUES('$Branch')") or die(mysqli_error($connect));
if ($insert) {
echo '<div class="alert alert-success alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Data Successfully Saved.</div>';
} else {
echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>OOps, Data Failed to Save!</div>';
}
} else {
echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>Not the same password!</div>';
}
} else {
echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>ID already exists!</div>';
}
}
?>
This is my mysql column.
Branch text utf8_general_ci No None
This is select element from my form.
<form action="" method="post">
<select class="selectpicker form-control" multiple data-live-search="true" name="Branch" required="true">
<option selected>example 1</option>
<option value="example 2">example 2</option>
<option value="example 3">example 3</option>
<option value="example 4">example 4</option>
</select>
</form>
My problem is next, if i choose one option its indexing database without any problem. if i choose more then one option, last selected option is indexing. So what i want is if i select 2 option for example "example 1, example 2" this both should be index as text in my mysql.
P.S. I know that i am noob and non English speaker but please support me.