Вывод данных из формы в mysgl

Question

Прошу прощения за банальный вопрос но я только начал и не могу понять в чем же ошибка.

<?php
$host = "localhost";

$db = "agpc";,
$username = "root";
$password = "";
$db_table = "forma";
$connect=mysqli_connect($host,$username, $password,$db) ;
if (!$connect) {
    die('Ошибка соединения: ' . mysqli_error($r));
}
    mysqli_select_db($connect, "agpc"); 
 /*require_once 'forma.php';*/
 $your_name = $_REQUEST['your_name'];
$name_1 = $_REQUEST['name_1'];
$otchestvo = $_REQUEST['otchestvo'];
$pol = $_REQUEST['pol'];
$date = $_REQUEST['date'];
$nation = $_REQUEST['nation'];
$grazhdan = $_REQUEST['grazhdan'];
$user_phone1 = $_REQUEST['user_phone1'];
$user_email = $_REQUEST['user_email'];
$mesto_rozhden = $_REQUEST['mesto-rozhden'];
$user_phone = $_REQUEST['user_phone'];
$user_email1 = $_REQUEST['user_email1'];
$mob_tel = $_REQUEST['mob_tel'];
$tel_dom = $_REQUEST['tel_dom'];
$name_father = $_REQUEST['name_father'];
$type_doc_f = $_REQUEST['type_doc_f'];
$text_serya_pas_f = $_REQUEST['text_serya_pas_f'];
$number_p_f = $_REQUEST['number_p_f'];
$vudan_f = $_REQUEST['vudan_f'];
$name_mother = $_REQUEST['name_mother'];
$doc_m = $_REQUEST['doc_m'];
$text_serya_pas_m = $_REQUEST['text_serya_pas_m'];
$number_p_m =$_REQUEST['number_p_m'];
$vudan_m = $_REQUEST['vudan_m'];
$name_opekyn = $_REQUEST['name_opekyn'];
$type_doc_o = $_REQUEST['type_doc_o'];
$text_serya_pas_o = $_REQUEST['text_serya_pas_o'];
$number_p_o = $_REQUEST['number_p_o'];
$vudan_o = $_REQUEST['vudan_o'];
$specialnost_include_blank = $_REQUEST['specialnost_include_blank'];
$skvalific_include_blank  = $_REQUEST['skvalific_include_blank '];
$specialnost_include_blank1 =$_REQUEST['specialnost_include_blank1'];
$yvlechenie = $_REQUEST['yvlechenie'];
$dop_sved  = $_REQUEST['dop_sved'];
 $path = 'uploads/' . time() . $_FILES['attestat_f']['name'];#time-имя уникальное 




 $path1 = 'uploads/' . time() . $_FILES['sert_ent']['name'];#time-имя уникальное 

 $path2 = 'uploads/' . time() . $_FILES['voen']['name'];#time-имя уникальное 

 $path3 = 'uploads/' . time() . $_FILES['med86']['name'];#time-имя уникальное 

 $path4 = 'uploads/' . time() . $_FILES['fliyra']['name'];#time-имя уникальное 

 $path5 = 'uploads/' . time() . $_FILES['spravka_inv']['name'];#time-имя уникальное 

 $path6 = 'uploads/' . time() . $_FILES['foto']['name'];#time-имя уникальное 

   $path7 = 'uploads/' . time() . $_FILES['opekyn']['name'];#time-имя уникальное 

  $path8 = 'uploads/' . time() . $_FILES['harakter_shcool']['name'];#time-имя уникальное 

 $path9 = 'uploads/' . time() . $_FILES['adres_spravka']['name'];#time-имя уникальное 


$result = $connect->query("INSERT INTO `forma` (`id`, `your_name`, `name_1`, `otchestvo`, `pol`, `date`, `nation`, `grazhdan`, `user_phone1`, `user_email`, `mesto-rozhden`, `user_phone`, `user_email1`, `mob_tel`, `tel_dom`, `name_father`, `type_doc_f`, `text_serya_pas_f`, `number_p_f`, `vudan_f`, `name_mother`, `doc_m`, `text_serya_pas_m`, `number_p_m`, `vudan_m`, `name_opekyn`, `type_doc_o`, `text_serya_pas_o`, `number_p_o`, `vudan_o`, `specialnost_include_blank`, `skvalific_include_blank`, `specialnost_include_blank1`, `yvlechenie`, `dop_sved`, `attestat_f`, `sert_ent`, `voen`, `med86`, `fliyra`, `spravka_inv`, `foto`, `opekyn`, `harakter_shcool`, `adres_spravka`) VALUES (NULL, '$your_name', '$name_1', '$otchestvo', '$pol', '$date', '$nation', '$grazhdan', '$user_phone1', '$user_email', '$mesto_rozhden', '$user_phone', '$user_email1', '$mob_tel', '$tel_dom', '$name_father', '$type_doc_f', '$text_serya_pas_f', '$number_p_f', '$vudan_f', '$name_mother', '$doc_m', '$text_serya_pas_m ', '$number_p_m', '$vudan_m', '$name_opekyn', '$type_doc_o', '$text_serya_pas_o', '$number_p_o', '$vudan_o', '$specialnost_include_blank', '$skvalific_include_blank', '$specialnost_include_blank1', '$yvlechenie', '$dop_sved', '$path ', '$path1', '$path2', '$path3', '$path4', '$path5', '$path6', '$path7', '$path8', '$path9')");
if ($result == true){
    echo "Информация занесена в базу данных";
}else{
    echo "Информация не занесена в базу данных";
}

вот бд

CREATE TABLE `forma` (
  `id` int(11) NOT NULL,
  `your_name` text NOT NULL,
  `name_1` text NOT NULL,
  `otchestvo` text NOT NULL,
  `pol` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `nation` text NOT NULL,
  `grazhdan` text NOT NULL,
  `user_phone1` int(11) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `mesto-rozhden` text NOT NULL,
  `user_phone` int(11) NOT NULL,
  `user_email1` varchar(255) NOT NULL,
  `mob_tel` int(11) NOT NULL,
  `tel_dom` int(11) NOT NULL,
  `name_father` text NOT NULL,
  `type_doc_f` varchar(255) NOT NULL,
  `text_serya_pas_f` varchar(255) NOT NULL,
  `number_p_f` int(11) NOT NULL,
  `vudan_f` varchar(255) NOT NULL,
  `name_mother` text NOT NULL,
  `doc_m` varchar(256) NOT NULL,
  `text_serya_pas_m` varchar(255) NOT NULL,
  `number_p_m` int(11) NOT NULL,
  `vudan_m` varchar(255) NOT NULL,
  `name_opekyn` text NOT NULL,
  `type_doc_o` varchar(255) NOT NULL,
  `text_serya_pas_o` varchar(255) NOT NULL,
  `number_p_o` int(11) NOT NULL,
  `vudan_o` varchar(255) NOT NULL,
  `specialnost_include_blank` varchar(500) NOT NULL,
  `skvalific_include_blank` varchar(500) NOT NULL,
  `specialnost_include_blank1` varchar(500) NOT NULL,
  `yvlechenie` text NOT NULL,
  `dop_sved` text NOT NULL,
  `attestat_f` varchar(500) NOT NULL,
  `sert_ent` varchar(500) NOT NULL,
  `voen` varchar(500) NOT NULL,
  `med86` varchar(500) NOT NULL,
  `fliyra` varchar(500) NOT NULL,
  `spravka_inv` varchar(500) NOT NULL,
  `foto` varchar(500) NOT NULL,
  `opekyn` varchar(500) NOT NULL,
  `harakter_shcool` varchar(500) NOT NULL,
  `adres_spravka` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

БЛОГ НА HUSL

Вывод данных из формы в mysgl

Ответы (0 шт):