<?php include "connect.php"; 

					$res_clients = mysql_query("SELECT * FROM clients ");
					$res_remont = mysql_query("SELECT * FROM remont ");
					$res_masters = mysql_query("SELECT * FROM masters ");

					if(isset($_POST['add'])) {
						$marka = strip_tags(trim($_POST['marka']));
						$model = strip_tags(trim($_POST['model']));
						$probeg = strip_tags(trim($_POST['probeg']));
						$color = strip_tags(trim($_POST['color']));
						$client_id = strip_tags(trim($_POST['clientid']));
						$master_id = strip_tags(trim($_POST['id_master']));
						$repair_id = strip_tags(trim($_POST['remont_id']));	
						$date_in = strip_tags(trim($_POST['date_in']));	
						$date_out = strip_tags(trim($_POST['date_out']));	
						$my_res = mysql_query("INSERT INTO auto (marka, model, probeg, color, client_id, id_master, repair_id, date_in, date_out) VALUES ('$marka', '$model', '$probeg', '$color', '$client_id', '$master_id', '$repair_id', '$date_in', '$date_out')");
						mysql_close(); 
						if($my_res){
							echo "Успешно добавили новую запись!";
						}
						else {
							echo "Ошибка";
						}
					}
				?>
				<form action="cars-add.php" method="post" class="form">
					<div class="form-wrap">
						<div class="form-row">
							<div class="form-block">
							<label>Марка авто</label><input type="text" name="marka" placeholder="Марка авто">
							</div>
							<div class="form-block">
								<label>Модель авто</label><input type="text" name="model" placeholder="Модель авто">
							</div>
							<div class="form-block">
								<label>Пробег</label><input type="text" name="probeg" placeholder="Пробег">
							</div>
							<div class="form-block">
								<label>Цвет</label><input type="text" name="color" placeholder="Цвет">
							</div>
						</div>
						<div class="form-row">
							<select name="id_master">
							<option value="hide">Выбрать мастера</option>
							<?php while($res_id = mysql_fetch_array($res_masters)) { ?>
								<option value="<?php echo $res_id['id_master']; ?>"><?php echo $res_id['id']; ?> - <?php echo $res_id['master_name']; ?> <?php echo $res_id['master_surname']; ?> — <?php echo $res_id['master_position']; ?></option>
							<?php } ?>
							</select>
							<select name="remont_id">
								<option value="hide">Выбрать ремонт</option>
								<?php while($remont_id = mysql_fetch_array($res_remont)) { ?>
									<option value="<?php echo $remont_id['repair_id']; ?>"><?php echo $remont_id['remont_id']; ?> - <?php echo $remont_id['breaking']; ?> [<?php echo $remont_id['price']; ?> руб.]</option>
								<?php } ?>
							</select>
							<select name="clientid">
								<option value="hide">Выбрать клиента</option>
								<?php while($cl_id = mysql_fetch_array($res_clients)) { ?>
									<option value="<?php echo $cl_id['client_id']; ?>"><?php echo $cl_id['client_id']; ?> - <?php echo $cl_id['name']; ?> <?php echo $cl_id['fam']; ?> <?php echo $cl_id['otch']; ?></option>
								<?php } ?>
							</select>
							<div class="form-block">
								<label>Дата начала ремонта</label><input type="text" class="datepicker-here" autocomplete="off" name="date_in" placeholder="Дата начала ремонта">
							</div>
							<div class="form-block">
								<label>Дата окончания ремонта</label><input type="text" class="datepicker-here" autocomplete="off" name="date_out" placeholder="Дата окончания ремонта">
							</div>
						</div>
					</div>
					<input type="submit" name="add" value="Добавить">
				</form>

if($my_res){ echo "Успешно добавили новую запись!"; } else { echo "Ошибка"; }

else {
  echo mysql_error();
}

INSERT INTO auto (marka, model, probeg, color, client_id, id_master, repair_id, date_in, date_out) VALUES ('test', 'test', 'test', 'test', '2', '1', '5', '2019-04-07', '2019-04-07')