Cześć,
potrzebuję pomocy w insertowaniu danych do bazy w momencie, gdy dane są puste.
Mam coś takiego:
$person = sqlsrv_query($conn, "SELECT * FROM person ORDER BY Nazwa", array(), array( "Scrollable" => 'keyset' ));
<div class="col-lg-6 col-sm-4 form-group">
<label class="protocol">Osoba</label><br>
<select name="person" class="custom-select" style="width:100%;">
<option selected disabled value="">Wybierz</option>
<?php
while($row = sqlsrv_fetch_array($person, SQLSRV_FETCH_ASSOC)){
echo '<option value='.$row['id'].'>'.$row['Nazwa'].'</option>';
}
?>
</select>
</div>
<!-- III -->
<div class="col-lg-6 col-sm-4 form-group">
<label class="protocol">Data akceptacji</label><br>
<input type="date" name="acceptDate" class="form-control" autocomplete="off">
</div>
<!-- IV -->
<div class="col-lg-6 col-sm-4 form-group">
<label class="protocol">Motyw</label><br>
<input type="text" name="theme" class="form-control" autocomplete="off">
</div>
<div class="col-lg-3 col-sm-4 form-group">
<label class="protocol">Logo</label><br>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="logo" value="2">
<label class="form-check-label">Tak</label>
</div>
<div class="form-check form-check-inline">
<input class="form-check-input" type="radio" name="logo" value="1">
<label class="form-check-label">Nie</label>
</div>
</div>
<?php
$alert = null;
if (isset($_POST['insert'])) {
$p_id = $_POST['person'];
$acceptDate = $_POST['acceptDate'];
$theme = $_POST['theme'];
$logo = $_POST['logo'];
$errors = 0;
foreach($oU_ids as $Index => $p_id){
$query_run = sqlsrv_query(
$conn,
sprintf(
"INSERT INTO role (c_id, acceptDate, theme, logo,)
VALUES ('%s', '%s', '%s', '%s')",
$p_id[$Index],
$acceptDate[$Index] ?? 0,
$theme[$Index] ?? 0,
$logo[$Index] ?? 0
),
[],
["Scrollable" => 'keyset']
);
if ($query_run === false) {
$errors++;
}
}
$alert = !$errors ? 'Zapisano' : 'Błąd: brak zapisu!';
}
?>
<?php if ($alert): ?>
<script type="text/javascript">alert("<?php echo $alert ?>")</script>
<?php endif ?>
Mógłby mi ktoś pomóc z tablicą, jak to prawidłowo wykonać?