Reputation: 25
I want add records into the base but not all. I have checkboxes and if some is checked then I add into the base if i click input button Save("Zapisz zmiany"). But input button save doesn't work. No reaction. POST array is empty. I don't know what i am doing wrong.
Input button:
<form action"" method="post" >
<input type="button" class="btn btn-primary" data-dismiss="modal" value="Zamknij/Close" />
<input type="button" class="btn btn-primary" name"zapros" id="zapros" value="Zapisz zmiany" />
</form>
and:
<?php
if (isset($_POST['zapros'])) {
$sqlc=mysqli_connect('127.0.0.1','root','');
if($sqlc) {
$sql_q="USE aplikacja";
mysqli_query($sqlc,$sql_q);
$data_zaproszenia = date("Y-m-d");
$sql_q=mysqli_query($sqlc, "SELECT * FROM goscie WHERE Email_goscia= '$mail'");
if(mysqli_num_rows($sql_q) != 0)
{
for ($i=1; $i < $lp ; $i++)
{
if (isset($_POST['zaznacz'.$i.'']))
{
$data_waznosci = $_POST['data_waznosci'.$i.''];
$sql_zaproszenie=mysqli_query($sqlc, "INSERT INTO zaproszenia (Email_goscia, ID_kwestionariusza, ID_wyniku, Data_zaproszenia, Data_waznosci, Wynik, Ocena, Status)
VALUES ('$mail', $id, NULL, '$data_zaproszenia', '$data_waznosci', NULL, NULL, 'Status')"); //dodawanie kolejnych odpowiedzi do bazy
echo "<script type='text/javascript'>alert('Zaproszenie wysłano!');</script>";
header('Refresh: 0;url=zaproszenia.php?id='.$id.'');
}
else
{
echo "<script type='text/javascript'>alert('Zaproszenie NIE wysłano!');</script>";
$i++;
}
}
}
mysqli_close($sqlc);
}
else
{
echo mysqli_connect_errno();
}
}?>
Upvotes: 0
Views: 681
Reputation: 33399
I haven't even examined your PHP, but you have some errors in your HTML:
<form action="" method="post" >
<input type="button" class="btn btn-primary" data-dismiss="modal" value="Zamknij/Close" />
<input type="submit" class="btn btn-primary" name="zapros" id="zapros" value="Zapisz zmiany" />
</form>
You were missing =
signs in two places (action=
and name=
), and were using a button instead of a submit button.
Upvotes: 1