I create information system to repair pc center. My quetion is - how get values from multiple area and post this in mysql db. Exfmple: Client 1 pick 3 services. SQL view ->
id | idclient | idservice<br>
1 | 1 | 2
2 | 1 | 4
3 | 1 | 7
<form method='post'>
<?php
date_default_timezone_set('Asia/Chita');
$rnd = date("dmYGis");
$allservice = mysql_query("SELECT * FROM service");
if (isset($_POST['submit'])) {
$firstname = $_POST['firstname'];
$adress = $_POST['adress'];
$model = $_POST['model'];
$comment = $_POST['comment'];
$telephone = $_POST['telephone'];
$anycontacts = $_POST['anycontacts'];
$status = $_POST['status'];
$serialnumber = $_POST['serialnumber'];
$service = $_POST['service'];
if ($service) {
foreach ($_POST['service']);
}
if (empty($firstname) or empty($model) or empty($telephone)) {
echo "<p>Заполни основные поля!</p>";
} else {
mysql_query("INSERT INTO klients VALUES('', '$firstname', '$adress','$model', '$comment', '$telephone','','$rnd', '$status','$anycontacts','','$serialnumber')");
mysql_query("INSERT INTO klientwithservice VALUES('', '$rnd', '$values')");
echo "<p>Succesful</p>";
}
}
?>
ФИО* : <br>
<input type='text' name='firstname' />
<br><br>
Адрес : <br>
<input type='text' name='adress' />
<br><br>
Модель* : <br>
<input type='text' name='model' />
<br><br>
Серийный номер : <br>
<input type='text' name='serialnumber' />
<br><br>
Описание проблемы : <br>
<textarea name='comment' /></textarea>
<br><br>
Телефон* : <br>
<input type='text' name='telephone' />
<br><br>
Другие контакты : <br>
<input type='text' name='anycontacts' />
<br><br>
Услуга : <br>
<select name='service[]' size=<? echo "$serviceid;" ?> multiple>
<?
while ($stroka = mysql_fetch_array($allservice)){
$serviceid=$stroka[0];
$servicename=$stroka[1];
$serviceprice=$stroka[2];
echo "<option value='$serviceid' selected>$servicename - $serviceprice р.</option>";
}
?>
</select>
<br><br>
Статус : <br>
<select name="status">
<option value="0">Выберите статус</option>
<?
include 'status.php';
?>
</select>
<br><br>
<input type='submit' name='submit' value='add' />
</form>
TNX
Aucun commentaire:
Enregistrer un commentaire