am
/
PHP-RechercheEmploi


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
							<html>
<head>
    <title>Ajouter une entreprise</title>
    <link href="custom.css" rel="stylesheet">
    <meta name="viewport" content="width=device-width">
</head>
<?php
session_start();

if (!isset($_SESSION['loggedin'])) {
header("Location: login.php");
exit;
}
if (isset($_SESSION['username'])) {
$prenom = $_SESSION['first_name'];
$nom = $_SESSION['last_name'];
$profession = $_SESSION['profession'];
$idsession = $_SESSION['ID'];
include_once 'class/sqlconnect.php';
try {
    $conn = new PDO("mysql:host=$host;dbname=$dbname", $dbusername, $dbpassword);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT ID FROM users WHERE username = :username");
    $stmt->bindParam(':username', $_SESSION['username']);
    $stmt->execute();

    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    $idsession = $result['ID'];

} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;
}
include("class/sqlconnect.php");
?>
<body>
    <a href="index.php">Revenir à l'accueil</a><br><br>
    <h1>Ajouter une entreprise</h1>
    <form action="ajoutentreprise.php" method="post">
      <table>
        <tr>
          <td>
            <label for="NomSociete">Nom de la société :</label>
          </td>
          <td>
            <input type="text" id="NomSociete" name="NomSociete" required>
          </td>
        </tr>
        <tr>
          <td>
            <label for="Adresse">Adresse postale de la société : (facultatif)</label>
          </td>
          <td>
            <input type="text" id="Adresse" name="Adresse">
          </td>
        </tr>
        <tr>
          <td>
            <label for="NumeroTel">Numéro de téléphone de la société : (format 0102030405)</label>
          </td>
          <td>
            <input type="text" id="NumeroTel" name="NumeroTel" pattern="0[0-9]{9}">
          </td>
        </tr>
      </table>
      <br>
        <input type="submit" name="submit" value="Ajouter">
    </form>
    <?php
      if(isset($_POST["submit"])) {
          $NomSociete = $_POST["NomSociete"];
          $Adresse = $_POST["Adresse"];
          $Adresse = htmlentities($Adresse);
          $Adresse = str_replace("'", "\'", $Adresse);
          $NumeroTel = $_POST["NumeroTel"];
          $StatutEntretien = "2";

          $sql = "INSERT INTO Entreprise (NomSociete, Adresse, NumeroTel, StatutEntretien, UserID)
          VALUES ('$NomSociete', '$Adresse', '$NumeroTel', '$StatutEntretien', '$idsession')";
          $result = mysqli_query($conn, $sql);

          if($result) {
              echo "La nouvelle entreprise a été ajoutée avec succès.";
          } else {
              echo "Erreur : " . $sql . "<br>" . mysqli_error($conn);
          }
        }
    ?>