Untitled

<?php require_once "PDO_connect.php";
$query="SELECT * FROM smartphone.select_nom_prenom_user";
try{
  $prep = $bdd->prepare($query);
  $prep->execute();
  $resultats = $prep->fetchAll();
}catch(Exception $e){;
  echo "Erreur ! ".$e->getMessage() ;
}
$host = "local

    host";
    $user = "root";
    $pass = "Mm101010";
    $dbn = "smart

phone";
      $link = mysqli_connect($host, $user, $pass, $dbn);
$type_gestion = 1;
switch ($type_gestion) {
    case '1':
        if (PHP_VERSION_ID < 50400) error_reporting (E_ALL | E_STRICT);
        else error_reporting (E_ALL);
  ini_set('display_errors', true);
  ini_set('html_errors', false);
  ini_set('display_startup_errors',true);
        ini_set('log_errors', false);
  ini_set('error_prepend_string','<span style="color: red;">');
  ini_set('error_append_string','<br /></span>');
  ini_set('ignore_repeated_errors', true);
    break;
}
?>
<!DOCTYPE>
<html>
<head>
 <title>Abonnement</title>
<script type="text/javascript" src=""quot;https://cdn.datatables.net/3.1.0/js/jquery.dataTables.min.js"></script>
 <link rel="stylesheet" type="text/css" href="Select.css">
  <style>
  #selectable .ui-selected { background: #0000FF; }
  #selectable .ui-selecting { background: #0000FF; }
  </style>
  <script type="text/javascript"></script>
  <script src=""quot;https://code.jquery.com/jquery-1.12.4.js"></script>
  <script src=""quot;https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
  <script>
  $( function() {
    $( "#selectable" ).selectable();
  } );
function affiche(tag)
{
 msgfield = document.getElementById("id_champ");

 msgfield.value = tag ;
        msgfield.focus();
}
var oTDs = document.querySelectorAll('td');
var oSelect = document.querySelector('select');
function action(val) {
    var trouve,
    i,  nb = oTDs.length;
    for (i = 0; i < nb; i += 1) {
        trouve = oTDs[i].textContent.indexOf( val) > -1;
        oTDs[i].parentNode.className = trouve ? 'selected' : '';
    }
}
oSelect.onchange = function () {
    action(this.value);
};
@en_tete= "SELECT `select_nom_prenom_user`.`USER_ID`, `select_nom_prenom_user`.`Nom`, `select_nom_prenom_user`.`Num_SIM`,`select_nom_prenom_user`.`Num_ligne` FROM select_nom_prenom_user WHERE (`select_nom_prenom_user`."
    @QWhere="`" & @nomchamp & "` " & @contenuchamp & ")"
function clic() { document.getElementById("onclic").innerHTML = ""; }
    @nomchamp = "Nom"
    @contenuchamp = $Nom
    @query= @en_tete & @QWhere
    $result = mysqli_query($link, $query)
    @nomchamp = "Num_SIM"
    @contenuchamp = $Num_SIM
    @query= @en_tete & @QWhere
    $result = mysqli_query($link, $query)
</script>
</head>
<body>
<center>
  <table id="selectable" class="DataTable" >
   <thead>
   <tr>
     <th>Operateur</th>
     <th>SIM</th>
     <th>PUK</th>
     <th>Num ligne</th>
     <th>Volume</th>
     <th>Statut abo</th>
   </tr>
   </thead><tbody>
   <?php
   echo "<br>";
   if(!empty($resultats)){
   foreach  ($resultats as $row) {

      echo "<tr>";
      echo "<td data-name="Operateur">".$row["Operateur"]."</td>";
      echo "<td data-name="Num_SIM">".$row["Num_SIM"]."</td>";
      echo "<td data-name="PUK">".$row["PUK"]."</td>";
      echo "<td data-name="Num_ligne">".$row["Num_ligne"]."</td>";
      echo "<td data-name="Volume">".$row["Volume"]."</td>";
      echo "<td data-name="Statut_abo">".$row["Statut_abo"]."</td>";
      echo "</tr>";
   }
     }else {
   echo "Pas d'enregistrements dans cette table...";
   }

      ?>
      </tbody></table><br><br>
      <?php
$select = "SELECT `select_nom_prenom_user`.`USER_ID`, `select_nom_prenom_user`.`Num_SIM`, `select_nom_prenom_user`.`Num_ligne`, `select_nom_prenom_user`.`Nom`
FROM `select_nom_prenom_user`
WHERE (`select_nom_prenom_user`.`Nom` " & $ANDRE & ")"
    if($result);//error

        echo'<option value="" selected="selected" disabled="disabled">Selectionnée : Nom</option>';
        while ($idresult = mysqli_fetch_row($result))
        {
            $USER_ID = $idresult[0];
            $Nom = $idresult[1];

            echo'<option value="' . $USER_ID . '">' . $Nom . '</option>';
        }
        echo'</select></p><p>';
_    }?>