dimanche 19 juin 2016

multiple area values to mysql in diffrent rows php

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