Insertion des données dans la base du serveur 00webhost

session_start();
require'functions.php';
logged_only();
if(!empty($_POST)){
   $errors = array();
   require_once'config1.php';
   if (empty($_POST['reference'])){
   
   }
   if (empty($_POST['utilisateur'])){
   
   }
   if (empty($_POST['n_terrain'])){
   
	}
   if (empty($_POST['niveau'])){
   
   }
   if (empty($_POST['titre'])){

    echo 'المرجو وضع عنوان للموضوع.';
   }
   if (empty($_POST['Page_cat'])){
   
   }
   if (empty($_POST['editor'])){
   
   }
  
   if (empty($_POST['date_pub'])){
   
   }
   
   if (empty($_POST['heure_pub'])){
   
   }
  
   
   if(empty($errors)){
      
   $req = $bd->prepare("INSERT INTO articles SET reference = ?, utilisateur = ?, n_terrain = ?, niveau = ?, titre = ?, Page_cat = ?,
    editor = ?, date_pub = ?, heure_pub = ? ");
   
    $req->execute([ $_POST['reference'],  $_POST['utilisateur'], $_POST['n_terrain'], $_POST['niveau'],
	$_POST['titre'], $_POST['Page_cat'], $_POST['editor'], $_POST['date_pub'], $_POST['heure_pub'] ]);
	$_SESSION['flash']['success'] = 'تم نشر مقالكم';
    header('Location: index.php');
	
	exit();
   }
  
   


}

require'header0.php';


<h3>موضوع جديد</h3>
<div class="menu">
<form action="" method="post">
   <div class="menu_titre">معلومات المستخدم</div>
   <table width="100%">
      <tr>
	  <td> رقم المرجع :</td>
	  <td><input type="text" name="reference" value="A<?php echo date('ymd');?>T<?php echo time();?>"/>
	  </td>
	  </tr>
	  <tr> 
	  <td>المستخدم:</td>
	  <td><input type="text" name="utilisateur" value="<?= $_SESSION['auth']->nom;?> <?= $_SESSION['auth']->prenom;?>"/>
       </td>
	   </tr>
	  <tr>
	  <td></td>
	  <td> <input type="hidden" name="n_terrain" value="<?= $_SESSION['auth']->n_terrain;?>"/>
	 </td>
	 </tr> 
	 <tr> 
	 <td></td>
	 <td><input type="hidden" name="niveau" value="<?= $_SESSION['auth']->niveau;?>"/>
	</td>
	</tr>
	</table>  
	
	
	<!------------------------->
	   <div class="menu_titre">معلومات عن الموضوع</div>
	   
	   <table width="100%">
	  <tr>
	  <td> عنوان المقال:</td>
	  <td><input type="text" name="titre" required  /></td>
	  </tr>
	 
	  <tr>
	  <td>اختر المجموعة:</td>
	  <td> <select name="Page_cat">
	   <?php
	    require_once'config1.php';
	   $connect = $_SESSION['auth']->niveau;
	   $req = $bd->query("SELECT * FROM cat WHERE niveau <= $connect ORDER BY id_cat");
	   ?> 
	   <?php
       while ($res = $req->fetch())
	   {
	   ?>
	   
	   <option  value="<?php echo $res['Page_cat']; ?>"><?php echo $res['id_cat']; ?>.<?php echo  $res['cat'];  ?></option>
	    <?php 
           require_once'config1.php';
		   
		   $req2 = $bd->prepare("SELECT * FROM menu_cat WHERE id_cat = ?   ORDER BY Nom_m_cat");
		   $req2->execute(array($res['id_cat']));
		   while ($res2 = $req2->fetch())
                {
				?>

	    <option id="select_cat" value="<?php echo $res2['Page_cat'];?>">=><?php echo $res2['Nom_m_cat'];?></option>
			<?php
			}
			?>
	   <?php 
	   }
	   ?>
	   </select>
	   </td>
	  
	  </tr> 
	   
	   
        
	    <tr>
		<td>الاقتراح/ الرأي(المقال)</td>
		</tr> 
		 
		 </table>
		 
  <div align="center">
    <textarea name="editor" style="width: 90%;" cols="100" rows="8" dir="rtl"  ></textarea>
	
  </div>
		 <br>
		 <input type="hidden" name="date_pub" value="<?php echo date('Y-m-d');?>"/>
		  <input type="hidden" name="heure_pub" value="<?php echo date('H:i');?>"/><br>
		 <input type="submit" name="ok" value="ارسل"/>
		   <input type="reset" name="reset" value=" مسح المقال" />
	 </form>  
</div>
<?php require'footer1.php';?>