Quelque que soit le champ que je mets j’ai un message d’erreur.

Code : Tout sélectionner

Parse error: syntax error, unexpected T_STRING in C:\wamp\www\bible\ma_page.php on line 35

CREATE TABLE IF NOT EXISTS `versets` (
  `id` char(3) NOT NULL DEFAULT '',
  `ch` mediumint(3) NOT NULL DEFAULT '0',
  `vst` mediumint(3) NOT NULL DEFAULT '0',
  `LSG` text NOT NULL,
  `darby` text NOT NULL,
  `ostervald` text NOT NULL,
  `martin` text NOT NULL,
  `is_promesse` int(1) unsigned NOT NULL DEFAULT '0',
  KEY `id` (`id`,`ch`,`vst`),
  KEY `vst` (`vst`),
  KEY `ch` (`ch`),
  KEY `is_promesse` (`is_promesse`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `ref_bible` (
  `id` char(3) NOT NULL DEFAULT '',
  `livre` char(60) NOT NULL DEFAULT '',
  `chap` int(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SELECT livre, ch, vst, LSG, is_promesse, l.livre AS nom_livre, "v.versets" AS voir_versets
FROM ref_bible AS l
INNER JOIN versets AS v
ON l.id = v.id
WHERE v.is_promesse=\'1\'
AND MON_CHAMP_ID = $_POST['id']
ORDER BY is_promesse

<select name="id">
    <option value="010">Choix 1</option>

<?php
if (isset($_POST['id'])) 
{
try
{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=mbase', 'root', '', $pdo_options);

$reponse = $bdd->query('SELECT livre, ch, vst, LSG, is_promesse, l.livre AS nom_livre, "v.versets" AS voir_versets
                        FROM ref_bible AS l
						INNER JOIN versets AS v
						ON l.id = v.id
						WHERE v.is_promesse=\'1\'
						ORDER BY is_promesse' );

while ($donnees = $reponse->fetch())
{
echo $donnees['livre'] .''.$donnees['ch'] .' : '. $donnees['vst'] . '<br/>' . $donnees['LSG'] . ' <br/><br/>';
}

$reponse->closeCursor();
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
}
?>

<form action="ma_page.php" method="post">
<p>
    <select name="livre">
    <option value="010">Choix 1</option>
    <option value="02O">Choix 2</option>
    <option value="03O">Choix 3</option>
    <option value="04O">Choix 4</option>
</select>
    <input type="submit" value="Valider" />
</p>
</form>
			

<?php
try
{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=m_base', 'root', '', $pdo_options);

$reponse = $bdd->query('SELECT livre, ch, vst, LSG, is_promesse, l.livre AS nom_livre, "v.versets" AS voir_versets
                        FROM ref_bible AS l
						INNER JOIN versets AS v
						ON l.id = v.id
						WHERE v.is_promesse=\'1\'
						ORDER BY is_promesse' );

while ($donnees = $reponse->fetch())
{
echo $donnees['livre'] .''.$donnees['ch'] .' : '. $donnees['vst'] . '<br/>' . $donnees['LSG'] . ' <br/><br/>';
}

$reponse->closeCursor();
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
?>

  <form action="ma_page.php" method="post" name="value" id="page">
          <select name="value" id="value"> <option selected="selected" value="05">Tous les livres</option>
                                                       
                                                       <option  value="01O">Texte 1</option>
                                                        <option value="02O">Texte 2</option>
                                                        <option value="03O">Texte 3</option>
                                                        <option value="04O">Texte 4</option>
                                                        <option value="05O">Texte 5</option>


                        </select>
				<input name="Submit"   value=">>" type="submit" />
            
			
			        </form>
					
<?php

if (isset($_POST['id'])) 
{
$id = $_POST['id'];
try
{
    $pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
    $bdd = new PDO('mysql:host=localhost;dbname=mbase', 'root', '', $pdo_options);
    
    $req = $bdd->prepare('SELECT id, livre, ch, vst, LSG, is_promesse, l.livre AS nom_livre, "v.versets" AS voir_versets
                        FROM ref_bible AS l
						INNER JOIN versets AS v
						ON l.id = v.id
						WHERE v.is_promesse=\'1\' 
						AND id <= ?
						ORDER BY is_promesse' );
						
    $req->execute(array($_POST['id']));
    
    
    while ($donnees = $req->fetch())
    {
        echo $donnees['livre'] .' '.$donnees['ch'] .' : '. $donnees['vst'] . '<br/>' . $donnees['LSG'] . ' <br/><br/>';
    }
   
    
    $req->closeCursor();
}
catch(Exception $e)
{
    die('Erreur : '.$e->getMessage());
}
}
?>