Activer et configurer PDO sous MAMP et Mac OS X Yosemite [Résolu/Fermé]

Signaler
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016
-
Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020
-
Bonjour,

Apres des recherches sur des forums, des visionnaires de vidéos, des manipus, des réinstallations etc.. je craque.... je n'arrive toujours pas à activer ce satané PDO => page blanche sur l'ordi alors qu'un formulaire au moins devrait s'afficher.


Help please !! merci :)

6 réponses

Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020
2 842
Bonjour,

Es-tu sûr que le souci vienne de la PDO ?
Il se pourrait simplement que le PB provienne de ton code.....

Tu peux nous le montrer ?

NB: **** Attention ****
Merci de bien vouloir utiliser la coloration syntaxique (les balises de code) lorsque tu postes du code sur le forum.
Explications disponibles ici :
https://codes-sources.commentcamarche.net/faq/10686-le-nouveau-codes-sources-comment-ca-marche#balises-code

.

1
Merci

Quelques mots de remerciements seront grandement appréciés. Ajouter un commentaire

CCM 60511 internautes nous ont dit merci ce mois-ci

Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

Pratiquement sur :attention ça fait mal le code est long

<?php

try
{
    // On se connecte à MySQL
    $bdd = new PDO('mysql:host=localhost;dbname=candidats', 'root', 'root');
}
catch(Exception $e)
{
    // En cas d'erreur, on affiche un message et on arrête tout
        die('Erreur : '.$e->getMessage());
}



if(isset($_POST['forminscription']))
{
 $pseudo = htmlspecialchars($_POST['pseudo']);
 $mail = htmlspecialchars($_POST['mail']);
 $mail2 = htmlspecialchars($_POST['mail2']);
 $mdp = sha1($_POST['mdp']);
 $mdp2 = sha1($_POST['mdp2']);

 if(!empty($POST['pseudo']) AND !empty($POST['mail']) AND !empty($POST['mail2']) AND !empty($POST['mdp']) AND !empty($POST['mdp2']))
 {
  $pseudolength = strlen($pseudo);
  if($pseudolength<=255)
  {
   
   if($mail == $mail2)
   {
    if(filter_var($mail, FILTER_VALIDATE_EMAIL))
    {
     $reqmail = $bdd->prepare("SELECT * FROM Informations WHERE mail = ?");
     $reqmail->execute(array($mail));
     $mailexist = $reqmail->rowCount();
     if($mailexist == 0)
     {
      
      if ($mdp == $mdp2)
      {
       $longueurkey = 15;
       $key = "";
       for($i=1;$i<$longueurkey;i++){
        $key .=mt_rand(0,9);
       }

       $insertcandidat = $bdd->prepare("INSERT INTO Informations(pseudo, mail, motdepasse,confirmkey) VALUES(?, ?, ?, ?)");
       $insertcandidat->execute(array($pseudo, $mail, $mdp,$key));

       $header="MIME-Version: 1.0\r\n";
       $header.='From:"Expediteur.com"<mica.aidan@gmail.com>'."\n";/*En l'occurence mettre le nom de l'entreprise et le mail support*/
       $header.='Content-Type:text/html; charset="uft-8"'."\n";
       $header.='Content-Transfer-Encoding: 8bit';

       $message='
       <html>
        <body>
         <div align="center">
          <a href="[http://localhost:8888/emploi/espace%20candidats/confirmation_candidats.php?pseudo= http://localhost:8888/emploi/espace%20candidats/confirmation_candidats.php?pseudo='.urldecode(|nofollow]$pseudo).'&key='.$key.'">Confirmez votre compte !</a>
         </div>
         </body>
         </html>
         ';

         mail($mail, "Confirmation de la création de votre compte", $message, $header);
       
       $erreur="Votre compte a bien été créé ! <a href=\"connexion.php\">Me connecter</a>"; 
      }
      else
      {
       $erreur = "Vos mots de passe ne correspondent pas !";
      }
     }
     else
     {
      $erreur = "Adresse mail déjà utilisée !";
     }
    }   
    else
    {
     $erreur="Votre adressse mail n'est pas valide !";
    }

    }
    else
    {
     $erreur = "Vos adresses mails ne correspondent pas !";
    }
   }
   else
   {
    $erreur="Votre pseudo ne doit pas dépasser 255 caractères !";
   }
  }
  else
  {
   $erreur = "Tous les champs doivent être complétés !";
  }
 }
?>




<!DOCTYPE html>
<html>
 <head>
  <title>Inscription-Espace candidats</title>
  <meta charset="utf-8">
 </head>
 
 <body>
  <div align="center">
   <h2>Inscription</h2>
   <br/><br/>

   <form action="profile_candidats.php" method="POST">
    <table>
     <tr>
      <td align="center">
       <label for="pseudo">Pseudo : </label>
      </td>
     
      <td align="center">
       <input type="text" placeholder=" Votre pseudo" id="pseudo" name="pseudo" value="<?php if(isset($pseudo)) { echo $pseudo; } ?>" required/>
      </td>
     </tr>
     <tr>
      <td align="center">
       <label for="mail"> Votre E-Mail : </label>
      </td>
     
      <td align="center">
       <input type="mail" placeholder=" Votre mail" id="mail" name="mail" value="<?php if(isset($mail)) { echo $mail; } ?>" required/>
      </td>
     </tr>
     <tr>
      <td align="center">
       <label for="mail2"> Confirmer votre E-Mail : </label>
      </td>
     
      <td align="center">
       <input type="mail" placeholder=" Confirmer votre e-mail" id="mail2" name="mail2" value="<?php if(isset($mail2)) { echo $mail2; } ?>" required/>
      </td>
     </tr>
     <tr>
      <td align="center">
       <label for="mdp"> Votre mot de passe : </label>
      </td>
     
      <td align="center">
       <input type="password" placeholder=" Indiquez un mot de passe" id="mdp" name="mdp" required/>
      </td>
     </tr>
     <tr>
      <td align="center">
       <label for="mdp2"> Confirmer mot de passe : </label>
      </td>
     
      <td align="center">
       <input type="password" placeholder=" Confirmez votre mot de passe" id="mdp2" name="mdp2" required/>
      </td>
     </tr>
     
     <?php
     
     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $sexe=htmlspecialchars($_POST['sexe']);
      if(!empty($POST['sexe'])
      
      {
       $reqsexe = $bdd->prepare("INSERT INTO Informations(sexe) VALUES(?)");
       $reqsexe->execute(array($sexe));
       
      }
      else
      {
       echo "Etes-vous un homme ou une femme ? "
      }

     }

     ?>
     <tr>
      <td align="center">
       <input type="checkbox" name="sexe" id="sexe" value="Homme" /> <label for="sexe">Homme</label>
       <input type="checkbox" name="sexe" id="sexe" value="Femme"/> <label for="sexe">Femme</label>
      </td>


     </tr>


     <?php
     
     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $nom = htmlspecialchars($_POST['nom']);
      if(!empty($_POST['nom']))
      {
       $reqnom = $bdd->prepare("INSERT INTO Informations(nom) VALUES (?)");
       $reqnom->execute(array($reqnom);
      }
      else
      {
       echo "Il semble que vous n'ayez entré aucune valeur dans le champs nom"
      }
     }


     ?>

     <tr>
      <td align="center">
       <label for="nom">Nom:(évitez les accents) </label>
      </td>

      <td align="center">
       <input type="text" name="nom" placeholder="nom" id="nom" required value="<?php if(isset($nom)) { echo $nom; } ?>"/>
      </td>
     </tr>

     
     <?php
     
     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $nom = htmlspecialchars($_POST['prenom']);
      if(!empty($_POST['prenom']))
      {
       $reqprenom = $bdd->prepare("INSERT INTO Informations(prenom) VALUES (?)");
       $reqprenom->execute(array($reqnom);
      }
      else
      {
       echo "Il semble que vous n'ayez entré aucune valeur dans le champs prénom"
      }
     }


     ?>
     <tr>
      <td align="center">
       <label for="prenom">Prénom: </label>
      </td>

      <td align="center">
       <input type="text" name="prenom" placeholder="prenom" id="prenom" required value="<?php if(isset($prenom)) { echo $prenom; } ?>"/>
      </td>
     </tr>

     <?php
     
     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $age = htmlspecialchars($_POST['age']);
      if(!empty($_POST['age']) AND if(preg_match("#^[0-9]{2}$#", $_POST['age'])){...;}else{echo 'veuillez saisir un nombre svp';})
      {
       $reqage = $bdd->prepare("INSERT INTO Informations(age) VALUES (?)");
       $reqage->execute(array($reqage);
      }
      else
      {
       echo "Il semble que vous n'ayez entré aucune valeur dans le champs age"
      }
     }


     ?>

     <tr>
      <td align="center">
       <label for="age">Age: (indiquer en nombre svp merci)</label>
      </td>

      <td align="center">
       <input type="text" name="age" id="age" placeholder="30" required value="<?php if(isset($age)) { echo $age; } ?>"/>
      </td>
     </tr>

     <?php
     
     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $adresse_postale = htmlspecialchars($_POST['adresse_postale']);
      if(!empty($_POST['adresse_postale']))
      {
       $reqadresse_postale = $bdd->prepare("INSERT INTO Informations(adresse postale) VALUES (?)");
       $reqadresse_postale->execute(array($reqadresse_postale);
      }
      else
      {
       echo "Il semble que vous n'ayez entré aucune valeur dans le champs adresse postale"
      }
     }
     ?>


     <tr>
      <td align="center">
       <label for="adresse_postale"></label>
      </td>

      <td align="center">
       <textarea name="adresse_postale" id="adresse_postale" rows="2" cols="70" required value="<?php if(isset($adresse_postale)) { echo $adresse_postale; } ?>" ></textarea>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $code_postal = htmlspecialchars($_POST['code_postal']);

      if(!empty($_POST['code_postal']) AND if(preg_match("#[0-9]{5}#", $_POST['code_postal']))
      {
       $reqcode_postal = $bdd->prepare("INSERT INTO Informations(code postal) VALUES (?)");
       $reqcode_postal->execute(array($reqcode_postal);
      }
      else
      {
       echo "Il semble que vous n'ayez entré aucune valeur dans le champs code postal"
      }
     }
     ?>

     <tr>
      <td align="center">
       <label for="code_postal"></label>
      </td>

      <td align="center">
       <input type="text" name="code_postal" id="code_postal" placeholder="13001" required  value="<?php if(isset($code_postal)) { echo $code_postal; } ?>"/>
      </td>
     </tr>

     <?php
     
     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $adresse_postale = htmlspecialchars($_POST['ville']);
      if(!empty($_POST['ville']))
      {
       $reqville = $bdd->prepare("INSERT INTO Informations(ville) VALUES (?)");
       $reqville->execute(array($reqville);
      }
      else
      {
       echo "Il semble que vous n'ayez entré aucune valeur dans le champs ville"
      }
     }
     ?>

     <tr>
      <td align="center">
       <label for="ville"></label>
      </td>
      <td align="center">
       <input type="text" name="ville" placeholder="Ville" id="ville" required value="<?php if(isset($ville)) { echo $ville; } ?>"/>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
      {
       $pays = htmlspecialchars($_POST['pays']);
      if(!empty($_POST['pays']))
       {
       $reqpays = $bdd->prepare("INSERT INTO Informations(pays) VALUES (?)");
       $reqpays->execute(array($reqpays);

       }
       else
        {
         echo "Il semble que vous n'ayez entré aucune valeur dans le champs pays"
         }
     
      }
      
     ?>
     
     <tr>
      <td align="center">
       <label for="pays">Pays:</label>
      </td>

      <td align="center">
       <select name ="pays">
        <option value="FRANCE" selected>FRANCE</option>
        <option value="AKROTIRI ET DEKHELIA">AKROTIRI ET DEKHELIA</option>
        <option value="ALBANIE">ALBANIE</option>
        <option value="ALLEMAGNE">ALLEMAGNE</option>
        <option value="ANTILLES NEERLANDAISES">ANTILLES NEERLANDAISES</option>
        <option value="ARMENIE">ARMENIE</option>
        <option value="AUTRICHE">AUTRICHE</option>
        <option value="BELGIQUE">BELGIQUE</option>
        <option value="BIELORUSSIE">BIELORUSSIE</option>
        <option value="BOSNIE-HERZEGOVINE">BOSNIE-HERZEGOVINE</option>
        <option value="BULGARIE">BULGARIE</option>
        <option value="CHYPRE">CHYPRE</option>
        <option value="CROATIE">CROATIE</option>
        <option value="DANEMARK">DANEMARK</option>
        <option value="ESPAGNE">ESPAGNE</option>
        <option value="ESTONIE">ESTONIE</option>
        <option value="FINLANDE">FINLANDE</option>
        <option value="GIBRALTAR">GIBRALTAR</option>
        <option value="GRECE">GRECE</option>
        <option value="GUERNESEY">GUERNESEY</option>
        <option value="GEORGIE">GEORGIE</option>
        <option value="HONGRIE">HONGRIE</option>
        <option value="ILE DE MAN">ILE DE MAN</option>
        <option value="ILES FEROE">ILES FEROE</option>
        <option value="IRLANDE">IRLANDE</option>
        <option value="ISLANDE">ISLANDE</option>
        <option value="ITALIE">ITALIE</option>
        <option value="JERSEY">JERSEY</option>
        <option value="LETTONIE">LETTONIE</option>
        <option value="LIECHTENSTEIN">LIECHTENSTEIN</option>
        <option value="LITUANIE">LITUANIE</option>
        <option value="LUXEMBOURG">LUXEMBOURG</option>
        <option value="MACEDOINE">MACEDOINE</option>
        <option value="MALTE">MALTE</option>
        <option value="MOLDAVIE">MOLDAVIE</option>
        <option value="MONTENEGRO SERBIE">MONTENEGRO SERBIE</option>
        <option value="NORVEGE">NORVEGE</option>
        <option value="PAYS-BAS">PAYS-BAS</option>
        <option value="POLOGNE">POLOGNE</option>
        <option value="PORTUGAL">PORTUGAL</option>
        <option value="PRINCIPAUTE D'ANDORRE">PRINCIPAUTE D'ANDORRE</option>
        <option value="PRINCIPAUTE DE MONACO">RINCIPAUTE DE MONACO</option>
        <option value="ROUMANIE">ROUMANIE</option>
        <option value="ROYAUME-UNI">ROYAUME-UNI</option>
        <option value="RUSSIE">RUSSIE</option>
        <option value="REPUBLIQUE TCHEQUE">REPUBLIQUE TCHEQUE</option>
        <option value="SAINT-MARIN">SAINT-MARIN</option>
        <option value="SLOVAQUIE">SLOVAQUIE</option>
        <option value="SLOVENIE">SLOVENIE</option>
        <option value="SUISSE">SUISSE</option>
        <option value="SUEDE">SUEDE</option>
        <option value="UKRAINE">UKRAINE</option>
        <option value="ANGUILLA">ANGUILLA</option>
        <option value="ANTIGUA-BARBUDA">ANTIGUA-BARBUDA</option>
        <option value="ARGENTINE">ARGENTINE</option>
        <option value="BAHAMAS">BAHAMAS</option>
        <option value="BARBADE">BARBADE</option>
        <option value="BERMUDES">BERMUDES</option>
        <option value="BOLIVIE">BOLIVIE</option>
        <option value="BRESIL">BRESIL</option>
        <option value="BELIZE">BELIZE</option>
        <option value="CANADA">CANADA</option>
        <option value="CHILI">CHILI</option>
        <option value="COLOMBIE">COLOMBIE</option>
        <option value="COSTA RICA">COSTA RICA</option>
        <option value="CUBA">CUBA</option>
        <option value="DOMINIQUE">DOMINIQUE</option>
        <option value="EQUATEUR">EQUATEUR</option>
        <option value="ETATS-UNIS">ETATS-UNIS</option>
        <option value="GRENADE">GRENADE</option>
        <option value="GROENLAND">GROENLAND</option>
        <option value="GUATEMALA">GUATEMALA</option>
        <option value="GUYANA">GUYANA</option>
        <option value="HAITI">HAITI</option>
        <option value="HONDURAS">HONDURAS</option>
        <option value="ILES CAYMAN">ILES CAYMAN</option>
        <option value="ILES TURQUES ET CAIQUES">ILES TURQUES ET CAIQUES</option>
        <option value="ILES VIERGES BRITANNIQUES">ILES VIERGES BRITANNIQUES</option>
        <option value="JAMAIQUE">JAMAIQUE</option>
        <option value="MALOUINES">MALOUINES</option>
        <option value="MEXIQUE">MEXIQUE</option>
        <option value="MONTSERRAT">MONTSERRAT</option>
        <option value="NICARAGUA">NICARAGUA</option>
        <option value="PANAMA">PANAMA</option>
        <option value="PARAGUAY">PARAGUAY</option>
        <option value="PORTO RICO">PORTO RICO</option>
        <option value="PEROU">PEROU</option>
        <option value="REPUBLIQUE DOMINICAINE">REPUBLIQUE DOMINICAINE</option>
        <option value="SAINTE-LUCIE">SAINTE-LUCIE</option>
        <option value="SALVADOR">SALVADOR</option>
        <option value="ST-CHRISTOPHE,NIEVES">ST-CHRISTOPHE,NIEVES</option>
        <option value="ST-VINCENT GRENADINES">ST-VINCENT GRENADINES</option>
        <option value="SURINAM">SURINAM</option>
        <option value="TRINITE TOBAGO">TRINITE TOBAGO</option>
        <option value="URUGUAY">URUGUAY</option>
        <option value="VENEZUELA">VENEZUELA</option> 
        <option value="AFGHANISTAN">AFGHANISTAN</option>
        <option value="ARABIE SAOUDITE">ARABIE SAOUDITE</option>
        <option value="AZERBAIDJAN">AZERBAIDJAN</option>
        <option value="BAHREIN">BAHREIN</option>
        <option value="BANGLADESH">BANGLADESH</option>
        <option value="BHOUTAN">BHOUTAN</option>
        <option value="BRUNEI DARUSSALAM">BRUNEI DARUSSALAM</option>
        <option value="CAMBODGE">CAMBODGE</option>
        <option value="CHINE">CHINE</option>
        <option value="COREE DU NORD">COREE DU NORD</option>
        <option value="COREE DU SUD">COREE DU SUD</option>
        <option value="EMIRATS ARABES UNIS">EMIRATS ARABES UNIS</option>
        <option value="INDE">INDE</option>
        <option value="INDONESIE">INDONESIE</option>
        <option value="IRAK">IRAK</option>
        <option value="IRAN">IRAN</option>
        <option value="ISRAEL">ISRAEL</option>
        <option value="JAPON">JAPON</option>
        <option value="JORDANIE">JORDANIE</option>
        <option value="KAZAKHSTAN">KAZAKHSTAN</option>
        <option value="KIRGHIZISTAN">KIRGHIZISTAN</option>
        <option value="KOWEIT">KOWEIT</option>
        <option value="LAOS">LAOS</option>
        <option value="LIBAN">LIBAN</option>
        <option value="MALAISIE">MALAISIE</option>
        <option value="MALDIVES">MALDIVES</option>
        <option value="MONGOLIE">MONGOLIE</option>
        <option value="MYANMAR (BIRMANIE)">MYANMAR (BIRMANIE)</option>
        <option value="NEPAL">NEPAL</option>
        <option value="OMAN">OMAN</option>
        <option value="OUZBEKISTAN">OUZBEKISTAN</option>
        <option value="PAKISTAN">PAKISTAN</option>
        <option value="PALESTINE">PALESTINE</option>
        <option value="PHILIPPINES">PHILIPPINES</option>
        <option value="QATAR">QATAR</option>
        <option value="SINGAPOUR">SINGAPOUR</option>
        <option value="SRI LANKA">SRI LANKA</option>
        <option value="SYRIE">SYRIE</option>
        <option value="TADJIKISTAN">TADJIKISTAN</option>
        <option value="TAIWAN">TAIWAN</option>
        <option value="THAILANDE">THAILANDE</option>
        <option value="TIMOR ORIENTAL">TIMOR ORIENTAL</option>
        <option value="TURKMENISTAN">TURKMENISTAN</option>
        <option value="TURQUIE">TURQUIE</option>
        <option value="VIET-NAM">VIET-NAM</option>
        <option value="YEMEN">YEMEN</option>
        <option value="AFRIQUE DU SUD">AFRIQUE DU SUD</option>
        <option value="ALGERIE">ALGERIE</option>
        <option value="ANGOLA">ANGOLA</option>
        <option value="BOTSWANA">BOTSWANA</option>
        <option value="BURKINA-FASO">BURKINA-FASO</option>
        <option value="BURUNDI">BURUNDI</option>
        <option value="BENIN">BENIN</option>
        <option value="CAMEROUN">CAMEROUN</option>
        <option value="CAP-VERT">CAP-VERT</option>
        <option value="CENTRAFRIQUE">CENTRAFRIQUE</option>
        <option value="COMORES">COMORES</option>
        <option value="CONGO">CONGO</option>
        <option value="COTE D'IVOIRE">COTE D'IVOIRE</option>
        <option value="DJIBOUTI">DJIBOUTI</option>
        <option value="EGYPTE">EGYPTE</option>
        <option value="ERYTHREE">ERYTHREE</option>
        <option value="ETHIOPIE">ETHIOPIE</option>
        <option value="GABON">GABON</option>
        <option value="GAMBIE">GAMBIE</option>
        <option value="GHANA">GHANA</option>
        <option value="GUINEE">GUINEE</option>
        <option value="GUINEE EQUATORIALE">GUINEE EQUATORIALE</option>
        <option value="GUINEE-BISSAU">GUINEE-BISSAU</option>
        <option value="BURUNDI">BURUNDI</option>
        <option value="BENIN">BENIN</option>
        <option value="CAMEROUN">CAMEROUN</option>
        <option value="KENYA">KENYA</option>
        <option value="LESOTHO">LESOTHO</option>
        <option value="LIBYE">LIBYE</option>
        <option value="LIBERIA">LIBERIA</option>
        <option value="MADAGASCAR">MADAGASCAR</option>
        <option value="MALAWI">MALAWI</option>
        <option value="MALI">MALI</option>
        <option value="MAROC">MAROC</option>
        <option value="MAURICE">MAURICE</option>
        <option value="MAURITANIE">MAURITANIE</option>
        <option value="MOZAMBIQUE">MOZAMBIQUE</option>
        <option value="NAMIBIE">NAMIBIE</option>
        <option value="NIGER">NIGER</option>
        <option value="NIGERIA">NIGERIA</option>
        <option value="OUGANDA">OUGANDA</option>
        <option value="RWANDA">RWANDA</option>
        <option value="REPUBLIQUE DEMOCRATIQUE DU CONGO">REPUBLIQUE DEMOCRATIQUE DU CONGO</option>
        <option value="SAINTE-HELENE">SAINTE-HELENE</option>
        <option value="SEYCHELLES">SEYCHELLES</option>
        <option value="SIERRA LEONE">SIERRA LEONE</option>
        <option value="SOMALIE">SOMALIE</option>
        <option value="SOUDAN">SOUDAN</option>
        <option value="SWAZILAND">SWAZILAND</option>
        <option value="SAO TOME ET PRINCIPE">SAO TOME ET PRINCIPE</option>
        <option value="SENEGAL">SENEGAL</option>
        <option value="TANZANIE">TANZANIE</option>
        <option value="TCHAD">TCHAD</option>
        <option value="TOGO">TOGO</option>
        <option value="TUNISIE">TUNISIE</option>
        <option value="ZAMBIE">ZAMBIE</option>
        <option value="ZIMBABWE">ZIMBABWE</option>
        <option value="ANTARCTIQUE">ANTARCTIQUE</option>
        <option value="AUSTRALIE">AUSTRALIE</option>
        <option value="CHRISTMAS, COCOS ET NORFOLK">CHRISTMAS, COCOS ET NORFOLK</option>
        <option value="COOK, NIUE ET TOKELAU">COOK, NIUE ET TOKELAU</option>
        <option value="FIDJI">FIDJI</option>
        <option value="GUAM MARIANNES NORD ET SAMOA ">GUAM MARIANNES NORD ET SAMOA </option>
        <option value="KIRIBATI">KIRIBATI</option>
        <option value="MARSHALL">MARSHALL</option>
        <option value="MICRONESIE">MICRONESIE</option>
        <option value="NAURU">NAURU</option>
        <option value="NOUVELLE-ZELANDE">NOUVELLE-ZELANDE</option>
        <option value="PALAU">PALAU</option>
        <option value="PAPOUASIE NOUVELLE GUINEE">PAPOUASIE NOUVELLE GUINEE</option>
        <option value="PITCAIRN">PITCAIRN</option>
        <option value="SALOMON">SALOMON</option>
        <option value="SAMOA OCCIDENT.">SAMOA OCCIDENT.</option>
        <option value="TONGA">TONGA</option>
        <option value="TUVALU">TUVALU</option>
        <option value="VANUATU">VANUATU</option>

       </select>
   
       </td>
     </tr>
     
     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
      {
       $telephone = htmlspecialchars($_POST['telephone']);
      if(!empty($_POST['telephone']) AND if preg_match("#^+{2}[0-9]{5,}$#", $_POST['telephone'])
       {
        echo:"Veuillez bien respecter la synthaxe du numéro de téléphone"

        }
        else
        {
         $reqtelephone = $bdd->prepare("INSERT INTO Informations(telephone) VALUES (?)");
         $reqtelephone->execute(array($reqtelephone);
        }
        else
        {
         echo "Il semble que vous n'ayez entré aucune valeur dans le champs telephone"
         }
     
      }
      
     ?>

     <tr>
      <td align="center">
       <label for="telephone"></label>
      </td>

      <td align="center">
       <input type="tel" name="telephone" id="telephone"placeholder="+33611111111" required value="<?php if(isset($telephone)) { echo $telephone; } ?>"/>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $permis = htmlspecialchars($_POST['permis']);
      if(!empty($_POST['permis']))

      {
       $reqpermis = $bdd->prepare("INSERT INTO Informations(permis) VALUES (?)");
       $reqpermis->execute(array($reqpermis);
      }
      else
      {
       echo "Merci de faire votre choix"
      }
      
     }
     ?>

     <tr>
      
      <td align="center">
       Permis de conduire
       <input input type="radio" name="permis" value="Oui" id="Oui" checked="checked" required />
       <input input type="radio" name="permis" value="Non" id="Non" checked="checked" required />
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $formation = htmlspecialchars($_POST['formation']);
      if(!empty($_POST['formation']))

      {
       $reqformation = $bdd->prepare("INSERT INTO Informations(formation) VALUES (?)");
       $reqformation->execute(array($reqformation);
      }
      else
      {
       echo "Merci de choisir votre formation"
      }
      
     }
     ?>

     <tr>
      <td align="center"> 
       <label for="formation"> Niveau de Formation</label>
      </td>
       
      <td align="center">
       <select name ="formation">
        <option value="Aucun Diplome">Aucun Diplome</option>
        <option value="Brevet des collèges">Brevet des collèges</option>
        <option value="CAP">CAP</option>
        <option value="BEP">BEP</option>
        <option value="BAC general">BAC general</option>
        <option value="BAC technologique">BAC technologique</option>
        <option value="BAC professionel">BAC professionel</option>
        <option value="BAC+1">BAC+1</option>
        <option value="BAC+2">BAC+2</option> 
        <option value="BAC+3">BAC+3</option>
        <option value="BAC+4">BAC+4</option>
        <option value="BAC+5">BAC+5</option>
        <option value="BAC+5 et plus">BAC+5 et plus</option>
       </select>
      </td>

     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $domaine_d_etudes = htmlspecialchars($_POST['domaine_d_etudes']);
      if(!empty($_POST['domaine_d_etudes']))

      {
       $reqdomaine_d_etudes = $bdd->prepare("INSERT INTO Informations(domaine) VALUES (?)");
       $reqdomaine_d_etudes->execute(array($reqdomaine_d_etudes);
      }
      else
      {
       echo "Merci de choisir votre domaine d'études"
      }
      
     }
     ?>

     <tr> 

      <td align="center">
       <label for="domaine_d_etudes">Domaine d'études</label>
      </td>

      <td align="center">
       <select name="domaine_d_etudes" id="domaine_d_etudes" required/>
        <option value="Agriculture et peche,Espaces naturels et espaces verts,Soins aux animaux">Agriculture et pêche,Espaces naturels et espaces verts,Soins aux animaux</option>
        <option value="Agroalimentaire">Agroalimentaire</option>
        <option value="Arts et faconnage d'ouvrages d'art">Arts et faconnage d'ouvrages d'art</option>
        <option value="Banque, Assurance,Immobilier">Banque, Assurance,Immobilier</option>
        <option value="Commerce,Vente et Grande Distribution">Commerce,Vente et Grande Distribution</option>
        <option value="Communication, Media et Multimedia">Communication, Media et Multimedia</option>
        <option value="Consulting,Finance et Services comptables et administratifs">Consulting,Finance et Services comptables et administratifs</option>
        <option value="Contruction et BTP">Contruction et BTP</option>
        <option value="Droit">Droit</option>
        <option value="Enseignement et Recherche">Education et Recherche</option>
        <option value="Electronique">Electronique</option>
        <option value="Fonction publique">Fonction publique</option>
        <option value="Hotellerie-Restauration Tourisme Loisirs et Animation">Hôtellerie-Restauration Tourisme Loisirs et Animation</option>
        <option value="Informatique">Informatique</option>
        <option value="Internet">Internet</option>
        <option value="Industrie">Industrie</option>
        <option value="Installation et maintenance">Installation et maintenance</option>
        <option value="Librairies et imprimeries">Librairies et imprimeries</option>
        <option value="Mecanique">Mécanique</option>
        <option value="Sante">Sante</option>
        <option value="Services a la personne et a la collectivite">Services a la personne et a la collectivite</option>
        <option value="Spectacle">Spectacle</option>
        <option value="Support a l'entreprise">Support a l'entreprise</option>
        <option value="Transport et Logistique">Transport et Logistique</option>
       </select>
      </td>
     
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $etablissement = htmlspecialchars($_POST['etablissement']);
      if(!empty($_POST['etablissement']))

      {
       $reqetablissement = $bdd->prepare("INSERT INTO Informations(type de formation(FAC,BTS..)) VALUES (?)");
       $reqetablissement->execute(array($reqetablissement);
      }
      else
      {
       echo "Merci d'indiquer votre type d'établissement dans lequel vous avez réalisé vos études"
      }
      
     }
     ?>
     <tr>
      <td align="center">
       <label for="etablissement">Dans quel type d'établissement avez-vous réalisé vos études ? </label>

      </td>
      <td align="center">
       <input type="text" id="etablissement" name="etablissement" placeholder="IEP/Grande Ecole/IEP/BTS/Fac/Prépa"/>
      </td>
     </tr>
     
     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $experience = htmlspecialchars($_POST['experience']);
      if(!empty($_POST['experience']))

      {
       $reqexperience = $bdd->prepare("INSERT INTO Informations(expérience) VALUES (?)");
       $reqexperience->execute(array($reqdomaine_d_etudes);
      }
      else
      {
       echo "Merci de préciser la durée de votre expérience profesionnelle"
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="experience">Votre expérience profesionnelle</label>
      </td>

      <td align="center">
       <select name="experience" id="experience" required>
        <option value="Aucune">Aucune</option>
        <option value="0-2 ans">0-2 ans</option>
        <option value="2-4 ans">2-4 ans</option>
        <option value="4-6 ans">4-6 ans</option>
        <option value="6-8 ans">6-8 ans</option>
        <option value="8-10 ans">8-10 ans</option>
        <option value="10-12 ans">10-12 ans</option>
        <option value="12-14 ans">12-14 ans</option>
        <option value="14-16 ans">14-16 ans</option>
        <option value="16-20 ans">16-20 ans</option>
        <option value="20 ans et +">20 ans et plus</option>
       </select> 

      </td>
     </tr>
     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $secteur_d_experience_profesionnelle = htmlspecialchars($_POST['secteur_d_experience_profesionnelle']);
      if(!empty($_POST['secteur_d_experience_profesionnelle']))

      {
       $reqsecteur_d_experience_professionnelle = $bdd->prepare("INSERT INTO Informations(secteur d'experience profesionnelle) VALUES (?)");
       $reqsecteur_d_experience_professionnelle->execute(array($reqsecteur_d_experience_professionnelle);
      }
      else
      {
       echo "Merci de préciser le secteur de votre expérience profesionnelle"
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="secteur_d_experience_profesionnelle">Secteur de votre expérience profesionnelle</label>
      </td>

      <td align="center">
       <select name="secteur_d_experience_profesionnelle" id="secteur_d_experience_profesionnelle " required/><!--Les métiers.net-->
        <option value="Agriculture-Agroalimentaire"></option>
        <option value="Aéronautique">Aéronautique</option>
        <option value="Art-Culture-Audiovisuel">Art-Culture-Audiovisuel</option>
        <option value="Autres services"></option>
        <option value="Banque-Assurance">Banque-Assurance</option>
        <option value="Bois-Papier-Carton-Imprimerie">Bois-Papier-Carton-Imprimerie</option>
        <option value="BTP-Architecture">BTP-Architecture</option>
        <option value="Commerce-Immobilier">Commerce-Immobilier</option>
        <option value="Defense_publique-Securite">Défense publique-Sécurité</option>
        <option value="Droit">Droit</option>
        <option value="Economie-Gestion-Finance">Economie-Gestion-Finance</option>
        <option value="Enseignement-Recherche">Enseignement-Recherche</option>
        <option value="Etudes-Conseils">Etudes-Conseils</option>
        <option value="Environnement-Amenagement-Proprete">Environnement-Aménagement-Propreté</option>
        <option value="Hotellerie-Restauration-Tourisme">Hôtellerie-Restauration-Tourisme</option>
        <option value="Industries">Industries</option>
        <option value="Information-Communication-Medias-Publicite">IInformation-Communication-Médias-Publicité</option>
        <option value="Informatique-Telecoms-Internet">Informatique-Telecoms-Internet</option>
        <option value="Lettres-Langues-Sciences Humaines">Lettres-Langues-Communication</option>
        <option value="Mecanique">Mécanique</option>
        <option value="Plastique-Caoutchouc">Plastique-Caoutchouc</option>
        <option value="Sante-Social-Soins esthetiques">Sante-Social-Soins esthétiques</option>
        <option value="Sport">Sport</option>
        <option value="Transport-Logistique">Transport-Logistique</option>
        <option value="Aucun">Aucun</option>
       </select>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $dernier_emploi = htmlspecialchars($_POST['dernier_emploi']);
      if(!empty($_POST['dernier_emploi']))

      {
       $reqdernier_emploi = $bdd->prepare("INSERT INTO Informations(dernier emploi) VALUES (?)");
       $reqdernier_emploi->execute(array($reqdernier_emploi);
      }
      else
      {
       echo "Merci de préciser votre dernier emploi. Si aucun, précisez aucun."
      }
      
     }
     ?>
     <tr>
      <td align="center">
       <label for="dernier_emploi">Quel était votre emploi ? </label>
      </td>
      <td align="center">
       <input type="text" name="dernier_emploi" id="dernier_emploi" placeholder="Secrétaire/commercial/cariste"/ value="<?php if(isset($dernier_emploi)) { echo $dernier_emploi; } ?>">
      </td>
     </tr>
     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $langue_maternelle = htmlspecialchars($_POST['langue_maternelle']);
      if(!empty($_POST['langue_maternelle']))

      {
       $reqlangue_maternelle = $bdd->prepare("INSERT INTO Informations(langue maternelle) VALUES (?)");
       $reqlangue_maternelle->execute(array($reqlangue_maternelle);
      }
      else
      {
       echo "Merci de préciser votre langue maternelle. "
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="langue_maternelle">Langue Maternelle (attention aux fautes d'orthographe)</label>
      </td>
      <td align="center">
       <input type="text" name="langue_maternelle" id="langue_maternelle" required value="<?php if(isset($langue_maternelle)) { echo $langue_maternelle; } ?>"/>
      </td>
     </tr>
     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $langue_etrangere1 = htmlspecialchars($_POST['langue_etrangere1']);
      if(!empty($_POST['langue_etrangere1']))

      {
       $reqlangue_etrangere1 = $bdd->prepare("INSERT INTO Informations(langue étrangère1) VALUES (?)");
       $reqlangue_etrangere1->execute(array($reqlangue_etrangere1);
      }
      else
      {
       echo "Merci de préciser votre langue étrangère. Si aucune, précisez aucune. "
      }
      
     }
     ?> 
     <tr>
      <td align="center">
       <label for="langue_etrangere1">Merci d'indiquer votre langue étrangère n°1 et le niveau (notions,intermédiaire,avancé,bilingue), si aucune, mettez aucune.(attention aux fautes d'orthographe)</label>
      </td>
      <td align="center">
       <input type="text" id="langue_etrangere1" name="langue_etrangere1" placeholder="anglais courant" value="<?php if(isset($langue_etrangere1)) { echo $langue_etrangere1; } ?>">
      </td>
     </tr>
     
     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $langue_etrangere2 = htmlspecialchars($_POST['langue_etrangere2']);
      if(!empty($_POST['langue_etrangere2']))

      {
       $reqlangue_etrangere2 = $bdd->prepare("INSERT INTO Informations(langue étrangère2) VALUES (?)");
       $reqlangue_etrangere2->execute(array($reqlangue_etrangere2);
      }
      else
      {
       echo "Merci de préciser votre langue étrangère n°2. Si aucune, précisez aucune. "
      }
      
     }
     ?>
     <tr>
      <td align="center">
       <label for="langue_etrangere2">Merci d'indiquer votre langue étrangère n°2 et le niveau, si aucune, mettez aucune.(attention aux fautes d'orthographe)</label>
      </td>
      <td align="center">
       <input type="text" id="langue_etrangere2" name="langue_etrangere2" placeholder="espagnol courant" value="<?php if(isset($langue_etrangere2)) { echo $langue_etrangere2; } ?>">
      </td>

     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $langue_etrangere3 = htmlspecialchars($_POST['langue_etrangere3']);
      if(!empty($_POST['langue_etrangere2']))

      {
       $reqlangue_etrangere3 = $bdd->prepare("INSERT INTO Informations(langue étrangère3) VALUES (?)");
       $reqlangue_etrangere3->execute(array($reqlangue_etrangere2);
      }
      else
      {
       echo "Merci de préciser votre langue étrangère n°3. Si aucune, précisez aucune. "
      }
      
     }
     ?>


     <tr>
      <td align="center">
       <label for="langue_etrangere3">Merci d'indiquer votre langue étrangère n°3 et le niveau, si aucune, mettez aucune.(attention aux fautes d'orthographe)</label>
      </td>
      <td align="center">
       <input type="text" id="langue_etrangere3" name="langue_etrangere3" placeholder="chinois notions" value="<?php if(isset($langue_etrangere3)) { echo $langue_etrangere3; } ?>">
      </td>
     </tr>
     <p>Les recruteurs ont souvent besoin de connaitre vos compétences. </br>La notion de compétence n'est pas à prendre à la légère.</br>Si vous êtes compétent(e) dans un domaine, indiquez-le, sinon, ce n'est pas grave n'indiquez rien.</br> Cette notion est importante et recommandée.</p>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $competence1 = htmlspecialchars($_POST['competence1']);
      if(!empty($_POST['competence1']))

      {
       $reqcompetence1 = $bdd->prepare("INSERT INTO Informations(compétence1) VALUES (?)");
       $reqcompetence1->execute(array($reqcompetence1);
      }
      else
      {
       echo "Merci de préciser votre compétence 1. Si aucune, indiquez aucune. "
      }
      
     }
     ?>
     <tr>
      
      <td align="center">
       <label for="competence2">Compétence 1</label>
      </td>

      <td align="center">
       <input type="text" name="competence1" id="competence1" placeholder="compétence 1"value="<?php if(isset($competence1)) { echo $competence1; } ?>"/>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $competence2 = htmlspecialchars($_POST['competence2']);
      if(!empty($_POST['competence2']))

      {
       $reqcompetence2 = $bdd->prepare("INSERT INTO Informations(compétence2) VALUES (?)");
       $reqcompetence2->execute(array($reqcompetence2);
      }
      else
      {
       echo "Merci de préciser votre compétence 2. Si aucune, indiquez aucune. "
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="competence2">Compétence 2</label>
      </td>

      <td align="center">
       <input type="text" name="competence2" id="competence2" placeholder="compétence 2" value="<?php if(isset($competence2)) { echo $competence2; } ?>"/>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $competence3 = htmlspecialchars($_POST['competence3']);
      if(!empty($_POST['competence3']))

      {
       $reqcompetence3 = $bdd->prepare("INSERT INTO Informations(compétence3) VALUES (?)");
       $reqcompetence3->execute(array($reqcompetence3);
      }
      else
      {
       echo "Merci de préciser votre compétence 3. Si aucune, indiquez aucune. "
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="competence3">Compétence 3</label>
      </td>

      <td align="center">
       <input type="text" name="competence3" id="competence3" placeholder="compétence 3" value="<?php if(isset($competence3)) { echo $competence3; } ?>"/>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $competence4 = htmlspecialchars($_POST['competence4']);
      if(!empty($_POST['competence4']))

      {
       $reqcompetence4 = $bdd->prepare("INSERT INTO Informations(compétence4) VALUES (?)");
       $reqcompetence4->execute(array($reqcompetence3);
      }
      else
      {
       echo "Merci de préciser votre compétence 4. Si aucune, indiquez aucune. "
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="competence4">Compétence 4</label>
      </td>

      <td align="center">
       <input type="text" name="competence4" id="competence4" placeholder="compétence 4" value="<?php if(isset($competence4)) { echo $competence4; } ?>"/>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $competence5 = htmlspecialchars($_POST['competence5']);
      if(!empty($_POST['competence5']))

      {
       $reqcompetence5 = $bdd->prepare("INSERT INTO Informations(compétence5) VALUES (?)");
       $reqcompetence5->execute(array($reqcompetence5);
      }
      else
      {
       echo "Merci de préciser votre compétence 5. Si aucune, indiquez aucune. "
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="competence5">Compétence 5</label>
      </td>

      <td align="center">
       <input type="text" name="competence5" id="competence5" placeholder="compétence 5" value="<?php if(isset($competence5)) { echo $competence5; } ?>"/>
      </td>
     </tr>

     <?php

     $bdd = new PDO ('mysql:host=localhost;dbname=candidats', 'root', 'root');

     if(isset($_POST['forminscription']))
     {
      $url_candidats = htmlspecialchars($_POST['url_candidats']);
      if(!empty($_POST['url_candidats']))

      {
       $requrl_candidat = $bdd->prepare("INSERT INTO Informations(url candidat) VALUES (?)");
       $requrl_candidat->execute(array($requrl_candidat);
      }
      else
      {
       echo "Merci de préciser votre URL. Si aucune, indiquez aucune. "
      }
      
     }
     ?>

     <tr>
      <td align="center">
       <label for="url_candidats">URL Viadeo/Linkedin/blog</label>
      </td>

      <td align="center">
       <input type="url" name="url_candidats" id="url_candidats" value="<?php if(isset($url_candidats)) { echo $url_candidats; } ?>"/>
      </td> 
     
     <tr></tr>
      <td></td>
      <td align="center">
       <br />
       <input type="submit" name="forminscription"value="Je m'inscris"/> 
      </td>
     </tr> 
    </table>
    
   </form>
   <?php 
   if(isset($erreur))
   {
    echo '<font color = "red">' .$erreur. "</font>";
   }

   ?>
  </div>

 </body>

</html>



EDIT : Ajout de la coloration syntaxique.
Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020
2 842
Où est la coloration syntaxique ??
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

désolé je ne sais pas vraiment comment mettre en place la coloration syntaxique
Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020
2 842 >
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

Il suffit de lire le lien que je t'avais donné :
Explications disponibles ici :
https://codes-sources.commentcamarche.net/faq/10686-le-nouveau-codes-sources-comment-ca-marche#balises-code

.
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016
>
Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020

Je vois désolé mais concentrons nous plutot sur PDO stp tu aurais une solution a me proposer stp ?

merci

Salut,

tu utilise quelle version de PHP ?
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

J'utilise la version 5.6.10

salut,



En se basant sur ce lien :

https://php.developpez.com/faq/?page=pdo

place ce code dans un fichier php

<?php

foreach(get_loaded_extensions() as $extension)
{
    if(strpos(strtolower($extension), 'pdo') !== FALSE)
    {
        echo $extension.'<br/>';
    }
}

?>



et donne nous STP ce qui s'affiche .

bonne journée
Utilisateur anonyme
salut,

j'espère ne pas dire d'erreur, mais si c'était un problème avec pdo, tu aurais une erreur avec ton bloc catch :

try
{
// On se connecte à MySQL
$bdd = new PDO('mysql:host=localhost;dbname=candidats', 'root', 'root');
}
catch(Exception $e)
{
// En cas d'erreur, on affiche un message et on arrête tout
die('Erreur : '.$e->getMessage());
}
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

Rien ne s'affiche :(
Je vais vous envoyer le PHP.ini peut être que vous trouverez l'erreur merci encore :)
[PHP]

;;;;;;;;;;;
; WARNING ;
;;;;;;;;;;;
; This is the default settings file for new PHP installations.
; By default, PHP installs itself with a configuration suitable for
; development purposes, and *NOT* for production purposes.
; For several security-oriented considerations that should be taken
; before going online with your site, please consult php.ini-recommended
; and https://www.php.net/manual/en/security.php


;;;;;;;;;;;;;;;;;;;
; About this file ;
;;;;;;;;;;;;;;;;;;;
; This file controls many aspects of PHP's behavior. In order for PHP to
; read it, it must be named 'php.ini'. PHP looks for it in the current
; working directory, in the path designated by the environment variable
; PHPRC, and in the path that was defined in compile time (in that order).
; Under Windows, the compile-time path is the Windows directory. The
; path in which the php.ini file is looked for can be overridden using
; the -c argument in command line mode.
;
; The syntax of the file is extremely simple. Whitespace and Lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.
;
; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
;
; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one
; of the INI constants (On, Off, True, False, Yes, No and None) or an expression
; (e.g. E_ALL & ~E_NOTICE), or a quoted string ("foo").
;
; Expressions in the INI file are limited to bitwise operators and parentheses:
; | bitwise OR
; & bitwise AND
; ~ bitwise NOT
; ! boolean NOT
;
; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.
;
; An empty string can be denoted by simply not writing anything after the equal
; sign, or by using the None keyword:
;
; foo = ; sets foo to an empty string
; foo = none ; sets foo to an empty string
; foo = "none" ; sets foo to the string 'none'
;
; If you use constants in your value, and these constants belong to a
; dynamically loaded extension (either a PHP extension or a Zend extension),
; you may only use these constants *after* the line that loads the extension.
;
; All the values in the php.ini-dist file correspond to the builtin
; defaults (that is, if no php.ini is used, or if you delete these lines,
; the builtin defaults will be identical).


;;;;;;;;;;;;;;;;;;;;
; Language Options ;
;;;;;;;;;;;;;;;;;;;;

; Enable the PHP scripting language engine under Apache.
engine = On

; Allow the <? tag. Otherwise, only <?php and <script> tags are recognized.
; NOTE: Using short tags should be avoided when developing applications or
; libraries that are meant for redistribution, or deployment on PHP
; servers which are not under your control, because short tags may not
; be supported on the target server. For portable, redistributable code,
; be sure not to use short tags.
short_open_tag = On

; Allow ASP-style <% %> tags.
asp_tags = Off

; The number of significant digits displayed in floating point numbers.
precision = 12

; Enforce year 2000 compliance (will cause problems with non-compliant browsers)
y2k_compliance = On

; Output buffering allows you to send header lines (including cookies) even
; after you send body content, at the price of slowing PHP's output layer a
; bit. You can enable output buffering during runtime by calling the output
; buffering functions. You can also enable output buffering for all files by
; setting this directive to On. If you wish to limit the size of the buffer
; to a certain size - you can use a maximum number of bytes instead of 'On', as
; a value for this directive (e.g., output_buffering=4096).
output_buffering = Off

; You can redirect all of the output of your scripts to a function. For
; example, if you set output_handler to "mb_output_handler", character
; encoding will be transparently converted to the specified encoding.
; Setting any output handler automatically turns on output buffering.
; Note: People who wrote portable scripts should not depend on this ini
; directive. Instead, explicitly set the output handler using ob_start().
; Using this ini directive may cause problems unless you know what script
; is doing.
; Note: You cannot use both "mb_output_handler" with "ob_iconv_handler"
; and you cannot use both "ob_gzhandler" and "zlib.output_compression".
;output_handler =

; Transparent output compression using the zlib library
; Valid values for this option are 'off', 'on', or a specific buffer size
; to be used for compression (default is 4KB)
; Note: Resulting chunk size may vary due to nature of compression. PHP
; outputs chunks that are few hundreds bytes each as a result of
; compression. If you prefer a larger chunk size for better
; performance, enable output_buffering in addition.
; Note: You need to use zlib.output_handler instead of the standard
; output_handler, or otherwise the output will be corrupted.
zlib.output_compression = Off

; You cannot specify additional output handlers if zlib.output_compression
; is activated here. This setting does the same as output_handler but in
; a different order.
;zlib.output_handler =

; Implicit flush tells PHP to tell the output layer to flush itself
; automatically after every output block. This is equivalent to calling the
; PHP function flush() after each and every call to print() or echo() and each
; and every HTML block. Turning this option on has serious performance
; implications and is generally recommended for debugging purposes only.
implicit_flush = Off

; The unserialize callback function will called (with the undefind class'
; name as parameter), if the unserializer finds an undefined class
; which should be instanciated.
; A warning appears if the specified function is not defined, or if the
; function doesn't include/implement the missing class.
; So only set this entry, if you really want to implement such a
; callback-function.
unserialize_callback_func=

; When floats & doubles are serialized store serialize_precision significant
; digits after the floating point. The default value ensures that when floats
; are decoded with unserialize, the data will remain the same.
serialize_precision = 100

; Whether to enable the ability to force arguments to be passed by reference
; at function call time. This method is deprecated and is likely to be
; unsupported in future versions of PHP/Zend. The encouraged method of
; specifying which arguments should be passed by reference is in the function
; declaration. You're encouraged to try and turn this option Off and make
; sure your scripts work properly with it in order to ensure they will work
; with future versions of the language (you will receive a warning each time
; you use this feature, and the argument will be passed by value instead of by
; reference).
; allow_call_time_pass_reference = On

; Safe Mode
;
safe_mode = Off

; By default, Safe Mode does a UID compare check when
; opening files. If you want to relax this to a GID compare,
; then turn on safe_mode_gid.
safe_mode_gid = Off

; When safe_mode is on, UID/GID checks are bypassed when
; including files from this directory and its subdirectories.
; (directory must also be in include_path or full path must
; be used when including)
safe_mode_include_dir =

; When safe_mode is on, only executables located in the safe_mode_exec_dir
; will be allowed to be executed via the exec family of functions.
safe_mode_exec_dir =

; Setting certain environment variables may be a potential security breach.
; This directive contains a comma-delimited list of prefixes. In Safe Mode,
; the user may only alter environment variables whose names begin with the
; prefixes supplied here. By default, users will only be able to set
; environment variables that begin with PHP_ (e.g. PHP_FOO=BAR).
;
; Note: If this directive is empty, PHP will let the user modify ANY
; environment variable!
safe_mode_allowed_env_vars = PHP_

; This directive contains a comma-delimited list of environment variables that
; the end user won't be able to change using putenv(). These variables will be
; protected even if safe_mode_allowed_env_vars is set to allow to change them.
safe_mode_protected_env_vars = LD_LIBRARY_PATH

; open_basedir, if set, limits all file operations to the defined directory
; and below. This directive makes most sense if used in a per-directory
; or per-virtualhost web server configuration file. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
;open_basedir =

; This directive allows you to disable certain functions for security reasons.
; It receives a comma-delimited list of function names. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
disable_functions =

; This directive allows you to disable certain classes for security reasons.
; It receives a comma-delimited list of class names. This directive is
; *NOT* affected by whether Safe Mode is turned On or Off.
disable_classes =

; Colors for Syntax Highlighting mode. Anything that's acceptable in
; <font color="??????"> would work.
;highlight.string = #DD0000
;highlight.comment = #FF9900
;highlight.keyword = #007700
;highlight.bg = #FFFFFF
;highlight.default = #0000BB
;highlight.html = #000000


;
; Misc
;
; Decides whether PHP may expose the fact that it is installed on the server
; (e.g. by adding its signature to the Web server header). It is no security
; threat in any way, but it makes it possible to determine whether you use PHP
; on your server or not.
expose_php = On


;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 128M ; Maximum amount of memory a script may consume (8MB)

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; error_reporting is a bit-field. Or each number up to get desired error
; reporting level
; E_ALL - All errors and warnings
; E_ERROR - fatal run-time errors
; E_WARNING - run-time warnings (non-fatal errors)
; E_PARSE - compile-time parse errors
; E_NOTICE - run-time notices (these are warnings which often result
; from a bug in your code, but it's possible that it was
; intentional (e.g., using an uninitialized variable and
; relying on the fact it's automatically initialized to an
; empty string)
; E_CORE_ERROR - fatal errors that occur during PHP's initial startup
; E_CORE_WARNING - warnings (non-fatal errors) that occur during PHP's
; initial startup
; E_COMPILE_ERROR - fatal compile-time errors
; E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
; E_USER_ERROR - user-generated error message
; E_USER_WARNING - user-generated warning message
; E_USER_NOTICE - user-generated notice message
;
; Examples:
;
; - Show all errors, except for notices
;
;error_reporting = E_ALL & ~E_NOTICE
;
; - Show only errors
;
;error_reporting = E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR
;
; - Show all errors except for notices
;
error_reporting = E_ALL

; Print out errors (as a part of the output). For production web sites,
; you're strongly encouraged to turn this feature off, and use error logging
; instead (see below). Keeping display_errors enabled on a production web site
; may reveal security information to end users, such as file paths on your Web
; server, your database schema or other information.
display_errors = Off

; Even when display_errors is on, errors that occur during PHP's startup
; sequence are not displayed. It's strongly recommended to keep
; display_startup_errors off, except for when debugging.
display_startup_errors = On

; Log errors into a log file (server-specific log, stderr, or error_log (below))
; As stated above, you're strongly advised to use error logging in place of
; error displaying on production web sites.
log_errors = On

; Set maximum length of log_errors. In error_log information about the source is
; added. The default is 1024 and 0 allows to not apply any maximum length at all.
log_errors_max_len = 1024

; Do not log repeated messages. Repeated errors must occur in same file on same
; line until ignore_repeated_source is set true.
ignore_repeated_errors = Off

; Ignore source of message when ignoring repeated messages. When this setting
; is On you will not log errors with repeated messages from different files or
; sourcelines.
ignore_repeated_source = Off

; If this parameter is set to Off, then memory leaks will not be shown (on
; stdout or in the log). This has only effect in a debug compile, and if
; error reporting includes E_WARNING in the allowed list
report_memleaks = On

; Store the last error/warning message in $php_errormsg (boolean).
track_errors = Off

; Disable the inclusion of HTML tags in error messages.
;html_errors = Off

; If html_errors is set On PHP produces clickable error messages that direct
; to a page describing the error or function causing the error in detail.
; You can download a copy of the PHP manual from https://www.php.net/docs.php
; and change docref_root to the base URL of your local copy including the
; leading '/'. You must also specify the file extension being used including
; the dot.
;docref_root = "/phpmanual/"
;docref_ext = .html

; String to output before an error message.
;error_prepend_string = "<font color=ff0000>"

; String to output after an error message.
;error_append_string = "</font>"

; Log errors to specified file.
error_log = "/Applications/MAMP/logs/php_error.log"

; Log errors to syslog (Event Log on NT, not valid in Windows 95).
;error_log = syslog


;;;;;;;;;;;;;;;;;
; Data Handling ;
;;;;;;;;;;;;;;;;;
;
; Note - track_vars is ALWAYS enabled as of PHP 4.0.3

; The separator used in PHP generated URLs to separate arguments.
; Default is "&".
;arg_separator.output = "&"

; List of separator(s) used by PHP to parse input URLs into variables.
; Default is "&".
; NOTE: Every character in this directive is considered as separator!
;arg_separator.input = ";&"

; This directive describes the order in which PHP registers GET, POST, Cookie,
; Environment and Built-in variables (G, P, C, E & S respectively, often
; referred to as EGPCS or GPC). Registration is done from left to right, newer
; values override older values.
variables_order = "EGPCS"

; Whether or not to register the EGPCS variables as global variables. You may
; want to turn this off if you don't want to clutter your scripts' global scope
; with user data. This makes most sense when coupled with track_vars - in which
; case you can access all of the GPC variables through the $HTTP_*_VARS[],
; variables.
;
; You should do your best to write your scripts so that they do not require
; register_globals to be on; Using form variables as globals can easily lead
; to possible security problems, if the code is not very well thought of.
register_globals = Off

; This directive tells PHP whether to declare the argv&argc variables (that
; would contain the GET information). If you don't use these variables, you
; should turn it off for increased performance.
register_argc_argv = On

; Maximum size of POST data that PHP will accept.
post_max_size = 32M

; This directive is deprecated. Use variables_order instead.
gpc_order = "GPC"

; Magic quotes
;

; Use Sybase-style magic quotes (escape ' with '' instead of \').
magic_quotes_sybase = Off

; Automatically add files before or after any PHP document.
auto_prepend_file =
auto_append_file =

; As of 4.0b4, PHP always outputs a character encoding by default in
; the Content-type: header. To disable sending of the charset, simply
; set it to be empty.
;
; PHP's built-in default is text/html
default_mimetype = "text/html"
;default_charset = "iso-8859-1"

; Always populate the $HTTP_RAW_POST_DATA variable.
;always_populate_raw_post_data = On


;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;

; UNIX: "/path1:/path2"
include_path = ".:/Applications/MAMP/bin/php/php5.6.10/lib/php"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"

; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues. The alternate is to use the
; cgi.force_redirect configuration below
doc_root =

; The directory under which PHP opens the script using /~username used only
; if nonempty.
user_dir =

; Directory in which the loadable extensions (modules) reside.
extension_dir = "/Applications/MAMP/bin/php/php5.6.10/lib/php/extensions/no-debug-non-zts-20131226/"

; Whether or not to enable the dl() function. The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
enable_dl = On

; cgi.force_redirect is necessary to provide security running PHP as a CGI under
; most web servers. Left undefined, PHP turns this on by default. You can
; turn it off here AT YOUR OWN RISK
; **You CAN safely turn this off for IIS, in fact, you MUST.**
; cgi.force_redirect = 1

; if cgi.nph is enabled it will force cgi to always sent Status: 200 with
; every request.
; cgi.nph = 1

; if cgi.force_redirect is turned on, and you are not running under Apache or Netscape
; (iPlanet) web servers, you MAY need to set an environment variable name that PHP
; will look for to know it is OK to continue execution. Setting this variable MAY
; cause security issues, KNOW WHAT YOU ARE DOING FIRST.
; cgi.redirect_status_env = ;

; cgi.fix_pathinfo provides *real* PATH_INFO/PATH_TRANSLATED support for CGI. PHP's
; previous behaviour was to set PATH_TRANSLATED to SCRIPT_FILENAME, and to not grok
; what PATH_INFO is. For more information on PATH_INFO, see the cgi specs. Setting
; this to 1 will cause PHP CGI to fix it's paths to conform to the spec. A setting
; of zero causes PHP to behave as before. Default is zero. You should fix your scripts
; to use SCRIPT_FILENAME rather than PATH_TRANSLATED.
; cgi.fix_pathinfo=0

; FastCGI under IIS (on WINNT based OS) supports the ability to impersonate
; security tokens of the calling client. This allows IIS to define the
; security context that the request runs under. mod_fastcgi under Apache
; does not currently support this feature (03/17/2002)
; Set to 1 if running under IIS. Default is zero.
; fastcgi.impersonate = 1;

; cgi.rfc2616_headers configuration option tells PHP what type of headers to
; use when sending HTTP response code. If it's set 0 PHP sends Status: header that
; is supported by Apache. When this option is set to 1 PHP will send
; RFC2616 compliant header.
; Default is zero.
;cgi.rfc2616_headers = 0


;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).

upload_tmp_dir = /Applications/MAMP/tmp/php

; Maximum allowed size for uploaded files.
upload_max_filesize = 32M


;;;;;;;;;;;;;;;;;;
; Fopen wrappers ;
;;;;;;;;;;;;;;;;;;

; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
allow_url_fopen = On

; Define the anonymous ftp password (your email address)
;from="john@doe.com"

; Define the User-Agent string
; user_agent="PHP"

; Default timeout for socket based streams (seconds)
default_socket_timeout = 60

; If your scripts have to deal with files from Macintosh systems,
; or you are running on a Mac and need to deal with files from
; unix or win32 systems, setting this flag will cause PHP to
; automatically detect the EOL character in those files so that
; fgets() and file() will work regardless of the source of the file.
; auto_detect_line_endings = Off


;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
; extension=modulename.extension
;
; For example, on Windows:
;
; extension=msql.dll
;
; ... or under UNIX:
;extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.


; Extensions

; extension=apcu.so

extension=imap.so
extension=yaz.so
extension=mcrypt.so
extension=gettext.so
extension=pgsql.so
extension=pdo.so
extension=php_mysqli.so
extension=pdo_pgsql.so
extension=pdo_mysql.so
extension=dbo.so
extension=dbo_mysql.so

;extension=imagick.so
;extension=tidy.so
;extension=oauth.so

;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;

[Date]
; Defines the default timezone used by the date functions
; Will be changed by MAMP to system timezone
date.timezone = "Europe/Berlin"

[Syslog]
; Whether or not to define the various syslog variables (e.g. $LOG_PID,
; $LOG_CRON, etc.). Turning it off is a good idea performance-wise. In
; runtime, you can define these variables by calling define_syslog_variables().
define_syslog_variables = Off

[mail function]
; For Win32 only.
SMTP = localhost
smtp_port = 25

; For Win32 only.
;sendmail_from = me@example.com

; For Unix only. You may supply arguments as well (default: "sendmail -t -i").
;sendmail_path =

[Java]
;java.class.path = .\php_java.jar
;java.home = c:\jdk
;java.library = c:\jdk\jre\bin\hotspot\jvm.dll
;java.library.path = .\

[SQL]
sql.safe_mode = Off

[ODBC]
;odbc.default_db = Not yet implemented
;odbc.default_user = Not yet implemented
;odbc.default_pw = Not yet implemented

; Allow or prevent persistent links.
odbc.allow_persistent = On

; Check that a connection is still valid before reuse.
odbc.check_persistent = On

; Maximum number of persistent links. -1 means no limit.
odbc.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
odbc.max_links = -1

; Handling of LONG fields. Returns number of bytes to variables. 0 means
; passthru.
odbc.defaultlrl = 4096

; Handling of binary data. 0 means passthru, 1 return as is, 2 convert to char.
; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
; of uodbc.defaultlrl and uodbc.defaultbinmode
odbc.defaultbinmode = 1

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket = /Applications/MAMP/tmp/mysql/mysql.sock

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limimt
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Erros will be displayed.
mysql.trace_mode = Off

[MySQLi]
mysqli.default_socket = /Applications/MAMP/tmp/mysql/mysql.sock

[PDO]
pdo_mysql.default_socket = /Applications/MAMP/tmp/mysql/mysql.sock

[mSQL]
; Allow or prevent persistent links.
msql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
msql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
msql.max_links = -1

[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On

; Detect broken persistent links always with pg_pconnect(). Need a little overhead.
pgsql.auto_reset_persistent = Off

; Maximum number of persistent links. -1 means no limit.
pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
pgsql.max_links = -1

; Ignore PostgreSQL backends Notice message or not.
pgsql.ignore_notice = 0

; Log PostgreSQL backends Noitce message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0

[Sybase]
; Allow or prevent persistent links.
sybase.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
sybase.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
sybase.max_links = -1

;sybase.interface_file = "/usr/sybase/interfaces"

; Minimum error severity to display.
sybase.min_error_severity = 10

; Minimum message severity to display.
sybase.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
; If on, this will cause PHP to automatically assign types to results according
; to their Sybase type, instead of treating them all as strings. This
; compatability mode will probably not stay around forever, so try applying
; whatever necessary changes to your code, and turn it off.
sybase.compatability_mode = Off

[Sybase-CT]
; Allow or prevent persistent links.
sybct.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
sybct.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
sybct.max_links = -1

; Minimum server message severity to display.
sybct.min_server_severity = 10

; Minimum client message severity to display.
sybct.min_client_severity = 10

[dbx]
; returned column names can be converted for compatibility reasons
; possible values for dbx.colnames_case are
; "unchanged" (default, if not set)
; "lowercase"
; "uppercase"
; the recommended default is either upper- or lowercase, but
; unchanged is currently set for backwards compatibility
dbx.colnames_case = "unchanged"

[bcmath]
; Number of decimal digits for all bcmath functions.
bcmath.scale = 0

[browscap]
;browscap = extra/browscap.ini

[Informix]
; Default host for ifx_connect() (doesn't apply in safe mode).
ifx.default_host =

; Default user for ifx_connect() (doesn't apply in safe mode).
ifx.default_user =

; Default password for ifx_connect() (doesn't apply in safe mode).
ifx.default_password =

; Allow or prevent persistent links.
ifx.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
ifx.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
ifx.max_links = -1

; If on, select statements return the contents of a text blob instead of its id.
ifx.textasvarchar = 0

; If on, select statements return the contents of a byte blob instead of its id.
ifx.byteasvarchar = 0

; Trailing blanks are stripped from fixed-length char columns. May help the
; life of Informix SE users.
ifx.charasvarchar = 0

; If on, the contents of text and byte blobs are dumped to a file instead of
; keeping them in memory.
ifx.blobinfile = 0

; NULL's are returned as empty strings, unless this is set to 1. In that case,
; NULL's are returned as string 'NULL'.
ifx.nullformat = 0

[Session]
; Handler used to store/retrieve data.
session.save_handler = files

; Argument passed to save_handler. In the case of files, this is the path
; where data files are stored. Note: Windows users have to change this
; variable in order to use PHP's session functions.
; As of PHP 4.0.1, you can define the path as:
; session.save_path = "N;/path"
; where N is an integer. Instead of storing all the session files in
; /path, what this will do is use subdirectories N-levels deep, and
; store the session data in those directories. This is useful if you
; or your OS have problems with lots of files in one directory, and is
; a more efficient layout for servers that handle lots of sessions.
; NOTE 1: PHP will not create this directory structure automatically.
; You can use the script in the ext/session dir for that purpose.
; NOTE 2: See the section on garbage collection below if you choose to
; use subdirectories for session storage
;

session.save_path = /Applications/MAMP/tmp/php

; Whether to use cookies.
session.use_cookies = 1

; This option enables administrators to make their users invulnerable to
; attacks which involve passing session ids in URLs; defaults to 0.
; session.use_only_cookies = 1

; Name of the session (used as cookie name).
session.name = PHPSESSID

; Initialize session on request startup.
session.auto_start = 0

; Lifetime in seconds of cookie or, if 0, until browser is restarted.
session.cookie_lifetime = 0

; The path for which the cookie is valid.
session.cookie_path = /

; The domain for which the cookie is valid.
session.cookie_domain =

; Handler used to serialize data. php is the standard serializer of PHP.
session.serialize_handler = php

; Define the probability that the 'garbage collection' process is started
; on every session initialization.
; The probability is calculated by using gc_probability/gc_divisor,
; e.g. 1/100 means there is a 1% chance that the GC process starts
; on each request.

session.gc_probability = 1
session.gc_divisor = 100

; After this number of seconds, stored data will be seen as 'garbage' and
; cleaned up by the garbage collection process.
session.gc_maxlifetime = 1440

; NOTE: If you are using the subdirectory option for storing session files
; (see session.save_path above), then garbage collection does *not*
; happen automatically. You will need to do your own garbage
; collection through a shell script, cron entry, or some other method.
; For example, the following script would is the equivalent of
; setting session.gc_maxlifetime to 1440 (1440 seconds = 24 minutes):
; cd /path/to/sessions; find -cmin +24 | xargs rm

; PHP 4.2 and less have an undocumented feature/bug that allows you to
; to initialize a session variable in the global scope, albeit register_globals
; is disabled. PHP 4.3 and later will warn you, if this feature is used.
; You can disable the feature and the warning seperately. At this time,
; the warning is only displayed, if bug_compat_42 is enabled.

session.bug_compat_42 = 1
session.bug_compat_warn = 1

; Check HTTP Referer to invalidate externally stored URLs containing ids.
; HTTP_REFERER has to contain this substring for the session to be
; considered as valid.
session.referer_check =

; How many bytes to read from the file.
session.entropy_length = 0

; Specified here to create the session id.
session.entropy_file =

;session.entropy_length = 16

;session.entropy_file = /dev/urandom

; Set to {nocache,private,public,} to determine HTTP caching aspects
; or leave this empty to avoid sending anti-caching headers.
session.cache_limiter = nocache

; Document expires after n minutes.
session.cache_expire = 180

; trans sid support is disabled by default.
; Use of trans sid may risk your users security.
; Use this option with caution.
; - User may send URL contains active session ID
; to other person via. email/irc/etc.
; - URL that contains active session ID may be stored
; in publically accessible computer.
; - User may access your site with the same session ID
; always using URL stored in browser's history or bookmarks.
session.use_trans_sid = 0

; The URL rewriter will look for URLs in a defined set of HTML tags.
; form/fieldset are special; if you include them here, the rewriter will
; add a hidden <input> field with the info which is otherwise appended
; to URLs. If you want XHTML conformity, remove the form entry.
; Note that all valid entries require a "=", even if no value follows.
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

[MSSQL]
; Allow or prevent persistent links.
mssql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
mssql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
mssql.max_links = -1

; Minimum error severity to display.
mssql.min_error_severity = 10

; Minimum message severity to display.
mssql.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

; Connec timeout
;mssql.connect_timeout = 5

; Query timeout
;mssql.timeout = 60

; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096

; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096

; Limits the number of records in each batch. 0 = all records in one batch.
;mssql.batchsize = 0

; Specify how datetime and datetim4 columns are returned
; On => Returns data converted to SQL server settings
; Off => Returns values as YYYY-MM-DD hh:mm:ss
;mssql.datetimeconvert = On

; Use NT authentication when connecting to the server
mssql.secure_connection = Off

; Specify max number of processes. Default = 25
;mssql.max_procs = 25

[Assertion]
; Assert(expr); active by default.
;assert.active = On

; Issue a PHP warning for each failed assertion.
;assert.warning = On

; Don't bail out by default.
;assert.bail = Off

; User-function to be called if an assertion fails.
;assert.callback = 0

; Eval the expression with current error_reporting(). Set to true if you want
; error_reporting(0) around the eval().
;assert.quiet_eval = 0

[Ingres II]
; Allow or prevent persistent links.
ingres.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
ingres.max_persistent = -1

; Maximum number of links, including persistents. -1 means no limit.
ingres.max_links = -1

; Default database (format: [node_id::]dbname/srv_class).
ingres.default_database =

; Default user.
ingres.default_user =

; Default password.
ingres.default_password =

[Verisign Payflow Pro]
; Default Payflow Pro server.
pfpro.defaulthost = "test-payflow.verisign.com"

; Default port to connect to.
pfpro.defaultport = 443

; Default timeout in seconds.
pfpro.defaulttimeout = 30

; Default proxy IP address (if required).
;pfpro.proxyaddress =

; Default proxy port.
;pfpro.proxyport =

; Default proxy logon.
;pfpro.proxylogon =

; Default proxy password.
;pfpro.proxypassword =

[Sockets]
; Use the system read() function instead of the php_read() wrapper.
sockets.use_system_read = On

[com]
; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
;com.typelib_file =
; allow Distributed-COM calls
;com.allow_dcom = true
; autoregister constants of a components typlib on com_load()
;com.autoregister_typelib = true
; register constants casesensitive
;com.autoregister_casesensitive = false
; show warnings on duplicate constat registrations
;com.autoregister_verbose = true

[Printer]
;printer.default_printer = ""

[mbstring]
; language for internal character representation.
;mbstring.language = Japanese

; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
;mbstring.internal_encoding = EUC-JP

; http input encoding.
;mbstring.http_input = auto

; http output encoding. mb_output_handler must be
; registered as output buffer to function
;mbstring.http_output = SJIS

; enable automatic encoding translation accoding to
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
; portable libs/applications.
;mbstring.encoding_translation = Off

; automatic encoding detection order.
; auto means
;mbstring.detect_order = auto

; substitute_character used when character cannot be converted
; one from another
;mbstring.substitute_character = none;

; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
;mbstring.func_overload = 0

[FrontBase]
;fbsql.allow_persistent = On
;fbsql.autocommit = On
;fbsql.default_database =
;fbsql.default_database_password =
;fbsql.default_host =
;fbsql.default_password =
;fbsql.default_user = "_SYSTEM"
;fbsql.generate_warnings = Off
;fbsql.max_connections = 128
;fbsql.max_links = 128
;fbsql.max_persistent = -1
;fbsql.max_results = 128
;fbsql.batchSize = 1000

[Crack]
; Modify the setting below to match the directory location of the cracklib
; dictionary files. Include the base filename, but not the file extension.
; crack.default_dictionary = "c:\php\lib\cracklib_dict"

[exif]
; Exif UNICODE user comments are handled as UCS-2BE/UCS-2LE and JIS as JIS.
; With mbstring support this will automatically be converted into the encoding
; given by corresponding encode setting. When empty mbstring.internal_encoding
; is used. For the decode settings you can distinguish between motorola and
; intel byte order. A decode setting cannot be empty.
;exif.encode_unicode = ISO-8859-15
;exif.decode_unicode_motorola = UCS-2BE
;exif.decode_unicode_intel = UCS-2LE
;exif.encode_jis =
;exif.decode_jis_motorola = JIS
;exif.decode_jis_intel = JIS

; Local Variables:
; tab-width: 4
; End:

[xcache-common]
;extension=xcache.so

[xcache.admin]
xcache.admin.user = "xcache"
; xcache.admin.pass = md5($your_password)
xcache.admin.pass = "8e6867a5d05144cf4761d6481fc674a8"

[xcache]
; select low level shm/allocator scheme implemenation
xcache.shm_scheme = "mmap"
; to disable: xcache.size=0
; to enable : xcache.size=64M etc (any size > 0) and your system mmap allows
xcache.size = 64M
; set to cpu count
xcache.count = 1
; just a hash hints, you can always store count(items) > slots
xcache.slots = 8K
; ttl of the cache item, 0=forever
xcache.ttl = 0
; interval of gc scanning expired items, 0=no scan, other values is in seconds
xcache.gc_interval = 0

; same as aboves but for variable cache
xcache.var_size = 64M
xcache.var_count = 1
xcache.var_slots = 8K
; default ttl
xcache.var_ttl = 0
xcache.var_maxttl = 0
xcache.var_gc_interval = 300

xcache.test = Off
; N/A for /dev/zero
xcache.readonly_protection = Off
; for *nix, xcache.mmap_path is a file path, not directory.
; Use something like "/tmp/xcache" if you want to turn on ReadonlyProtection
; 2 group of php won't share the same /tmp/xcache
xcache.mmap_path = "/Applications/MAMP/tmp/xcache"


; leave it blank(disabled) or "/tmp/phpcore/"
; make sure it's writable by php (without checking open_basedir)
xcache.coredump_directory = "/Applications/MAMP/tmp/phpcore/"

; per request settings
xcache.cacher = On
xcache.stat = On
xcache.optimizer = On

[xcache.coverager]
; per request settings
; enable coverage data collecting for xcache.coveragedump_directory and xcache_coverager_start/stop/get/clean() functions (will hurt executing performance)
xcache.coverager = Off

; ini only settings
; make sure it's readable (care open_basedir) by coverage viewer script
; requires xcache.coverager=On
xcache.coveragedump_directory = ""

[OPcache]
;zend_extension="/Applications/MAMP/bin/php/php5.6.10/lib/php/extensions/no-debug-non-zts-20131226/opcache.so"
opcache.memory_consumption=128
opcache.interned_strings_buffer=8
opcache.max_accelerated_files=4000
opcache.revalidate_freq=60
opcache.fast_shutdown=1
opcache.enable_cli=1

[xdebug]
;zend_extension="/Applications/MAMP/bin/php/php5.6.10/lib/php/extensions/no-debug-non-zts-20131226/xdebug.so"

Salut,

lol, je viens de copier / coller ton code chez moi.

Procure toi un IDE qui fait de l'autocompletion et éventuellement indique les erreurs. Il manque des points virgule, des parenthèses en trop ou en moins, il y a un if dans la condition du if, des crochets en trop ou en moins...

Pour tester ce code j'ai utilisé : http://www.aptana.com/ , c'est un fork eclipse.

il y en a beaucoup d'autres qui sont bien aussi
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

"Procure toi un IDE qui fait de l'autocompletion et éventuellement indique les erreurs" ?
C'est a dire ?
Tu utilise quoi pour écrire ton code ?

Tu pourrais utiliser un IDE qui est un éditeur de texte qui aide à la programmation. Ton code est bourré d'erreurs. Tu l'a écris d'une traite sans tester ?
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016
> Utilisateur anonyme
J'utilise Sublime Text 2 et Text Wrangler. S'il est bourré d'erreurs il faudra se plaindre a Php lol :) je n'ai fait que rajouter des lignes et n'ai pas du tout touché à la ponctuation
pourquoi se plaindre à PHP ? Je ne parle pas du php.ini, mais de ton site !
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

J'ai réalisé ma page grâce à un tuto
Je l'ai relu avant de l'envoyer bien sur mais étant débutants on n'est jamais très bon dans le code ;)
Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020
2 842
Qu'as tu dans ta barre d'adresse quand tu affiches cette page dans ton navigateur ?
Passes tu bien (au niveau de l'url) par ton LocalHost ??

Ensuites... peux tu tester une simple page php contenant, par exemple :
<?php

Echo " Le code PHP s'affiche bien ! <br><br>";

// Affiche toutes les informations, comme le ferait INFO_ALL
phpinfo();

?>

Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020
2 842
Ensuite concernant ton code :
- Il manque des Points virgules
- Tu colles 10 fois la connexion à ta BDD .. pourquoi ?? Une seule fois au début de ton script suffirait ! ( au passage.... colle le code de connexion à ta BDD dans un fichier à part qu'il te suffira d'inclure dans les pages où tu en auras besoin..... comme ça.. le jour où tu déplaces ton site sur une autre BDD... tu n'auras des modifications à faire qu'à un seul endroit et non dans 200 lignes de ton code !! )

Tu peux aussi ajouter la ligne de code suivante au début de ta page :
<?php
// Reporte toutes les erreurs PHP 
error_reporting(E_ALL);


.. ça permet d'afficher les erreurs !
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

Bonsoir Jordane45 merci encore pour tout. Je pense avoir trouvé la petite bête en fait le display_error était sur Off ensuite j'avais tellement modifié le php.ini (attention ce doc doit être modifié a la fois dans apache mais aussi dans php et trouver la version qui vous convient) il suffisait (d'après ce que j'ai compris ) d'ajouter la ligne avec extension .dll pour activer le PDO c'est tout et oui en effet jordane ne connaissant que depuis quelques temps le PHP je pensais que pour chaque instruction il fallait rajouter $bdd=> pensant que c'est une variable ou peut être que c'est une variable. En fait j'ai appris qu'une variable n'était "active" que dans seule instruction php.
Pour me simplifier la vie j'avais créer plusieurs instructions PHP pour chaque cas ce qui en plus avec les formulaires d'option value prenait énormément de place dans le code et difficile de s'y retrouver. Je ne mettrai pas ce post en résolu car je n'ai pas encore pu tester avec le projet que je suis en train de construire. Pour l'instant il y a du mieux mais c'est pas encore gagné. En passant pour créer un site PHP avec système d'abonnement payant pour membres au bout d'une certaine instruction est ce que Joomla est adapté ?

Merci encore
Salut, j'ai un peu laissé tombé ce post car je pense que le problème vient déjà du code et je suis surpris qu'il n'est pas été testé en l'écrivant.

exemple d'erreurs :

ligne 44 :
       for($i=1;$i<$longueurkey;i++){


ligne 182 :

       echo "Etes-vous un homme ou une femme ? "


ligne 208 :

       $reqnom->execute(array($reqnom);


ligne : 329
      if(!empty($_POST['code_postal']) AND if(preg_match("#[0-9]{5}#", $_POST['code_postal']))


׺°"~'"°º×]|I{*------» LÖBÖTÖ «------*}I|[׺°"~'"°º×
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

Merci

Comment ca la ligne 329 n'est pas correcte ?
Messages postés
29743
Date d'inscription
mercredi 22 octobre 2003
Statut
Modérateur
Dernière intervention
13 octobre 2020
2 842 >
Messages postés
36
Date d'inscription
mercredi 15 juillet 2015
Statut
Membre
Dernière intervention
8 mars 2016

En effet.
tu as un if en trop apres ton AND