#php #html #mysql #checkbox
#php #HTML #mysql #флажок
Вопрос:
Я извлекаю данные из базы данных MySQL и разнесу их, на основе результата я хочу выбрать несколько флажков, я вставляю свой PHP-код и весь код флажка, а также базу данных, чтобы вы могли видеть, какой флажок должен быть установлен на основе результата.
<?php
$query25 = "SELECT * FROM es_availability_options WHERE es_id='4'";
$result25 = @mysql_query($query25);
echo mysql_error();
$row25=@mysql_fetch_array($result25);
$availability_options = $row25['availability_options'];
$availability_options = explode(', ', $availability_options);
?>
<div class="row">
<div class="col-md-4">
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available by appointment"> Available by appointment</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Pre bookings preferred but can be available at short notice"> Pre bookings preferred, but can be available at short notice</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Flexible hours by appointment"> Flexible hours by appointment</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available for overseas travel"> Available for overseas travel</p>
</div>
<div class="col-md-4">
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available 7 days"> Available 7 days</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="12 hours notice required"> 12 hours notice required</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available outside my city only"> Available outside my city only</p>
</div>
<div class="col-md-4">
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available 24 hours"> Available 24 hours</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="24 hours notice required"> 24 hours notice required</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available on weekends only"> Available on weekends only</p>
</div>
</div><!-- end row -->
У меня есть «Доступно 7 дней, требуется уведомление за 12 часов, доступно только за пределами моего города» эти параметры в столбце базы данных «availability_options».
Комментарии:
1. @Machavity, спасибо!
2. Любая помощь / предложение по моему вопросу?
Ответ №1:
вы почти сделали это. Просто используйте in_array() с вашей формой следующим образом —
<div class="row">
<div class="col-md-4">
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available by appointment"> Available by appointment</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Pre bookings preferred but can be available at short notice"> Pre bookings preferred, but can be available at short notice</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Flexible hours by appointment"> Flexible hours by appointment</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available for overseas travel"> Available for overseas travel</p>
</div>
<div class="col-md-4">
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available 7 days" <?php if (in_array("Available 7 days", $availability_options)) {echo "checked"; }?>> Available 7 days</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="12 hours notice required" <?php if (in_array("12 hours notice required", $availability_options)) {echo "checked"; }?>> 12 hours notice required</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available outside my city only" <?php if (in_array("Available outside my city only", $availability_options)) {echo "checked"; }?>> Available outside my city only</p>
</div>
<div class="col-md-4">
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available 24 hours"> Available 24 hours</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="24 hours notice required"> 24 hours notice required</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available on weekends only"> Available on weekends only</p>
</div>
Ответ №2:
<div class="col-md-4">
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available 7 days" <?php if(in_array('Available 7 days', $availability_options)) echo 'checked="checked"'; ?>> Available 7 days</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="12 hours notice required" <?php if(in_array('12 hours notice required', $availability_options)) echo 'checked="checked"'; ?>> 12 hours notice required</p>
<p style="font-size:16px;"><input name="availability_options[]" type="checkbox" value="Available outside my city only" <?php if(in_array('Available outside my city only', $availability_options)) echo 'checked="checked"'; ?>> Available outside my city only</p>
</div>