@ 2014-05-16T09:50:53Z <!DOCTYPE html>
<!--
Cette page permet l'ajout d'un objet
-->
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<!-- formulaire ajout objet -->
<?php
// initialisation de OK
if(!isset($_POST['ok'])) $ok=""; else $ok=$_POST['ok'];
if(isset($_POST['valider']))
{
if(empty($_POST['libObjet']))
{
echo 'Veuillez remplir le libellé<br>';
$ok = "";
}
if(empty($_POST['nbSortie']) AND empty($_POST['nbEntree']))
{
echo 'L\'objet doit avoir au moins une entrée ou une sortie<br>' ;
$ok = "";
}
// OK ssi tout est valide
if(!empty($_POST['libObjet']) AND !empty($_POST['typeObjet']) AND (!empty($_POST['nbEntree']) OR !empty($_POST['nbSortie'])))
{
$ok = 'ok';
}
// Permet l'ajout d'un objet à la base
if(isset($_POST['valider']) AND $ok == 'ok')
{
require_once 'includes/inc_connect.php';
print_r($_POST);
connectdb();
// on récupère les variables
$strLibObjet = htmlentities($_POST["libObjet"]);
$strTypeObjet = htmlentities($_POST["typeObjet"]);
$nbEntree = htmlentities($_POST["nbEntree"]);
$nbSortie = htmlentities($_POST["nbSortie"]);
$strSalle = htmlentities($_POST["noSalle"]);
$noArmoire = ($_POST["noArmoire"] > 0) ? htmlentities($_POST["noArmoire"]) : ''; // condition ternaire
// requête qui envoie les données
$sql = "INSERT INTO objet (id_obj, lib_obj, nb_entree, nb_sortie, salle, type_obj, no_armoire) VALUES('', '$strLibObjet', '$nbEntree', '$nbSortie', '$strSalle', '$strTypeObjet', '$noArmoire')";
echo $sql."<br>";
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
// message
if($req)
{
echo 'executé avec succès';
}
else
{
echo 'problème';
}
mysql_close();
}
}
// FORMULAIRE
if(!isset($_POST['valider']) OR $ok == "")
{
?><form action="ajout.php" method="post" class="formAjout">
<div>
<label for="libObjet"><br>libellé de l'objet :</label>
<input type="text" name="libObjet" id="libObjet" value=""/>
</div>
<div>
<label for="typeObjet">Type de l'objet :</label>
<select name="typeObjet">
<?php
require_once 'includes/inc_connect.php';
connectdb();
$req = "SELECT lib_type, designation_type FROM type";
$result = mysql_query($req);
while ($reqType = mysql_fetch_assoc($result))
{
echo "<option value=$reqType[lib_type]>$reqType[designation_type]</option>";
}
mysql_close();
?>
</select>
</div>
<div>
<label for="nbEntree">Nombre de port en entrée :</label>
<input type="number" name="nbEntree" id ="nbEntree" step="1" value="null" min="0" max="500"/>
</div>
<div>
<label for="nbSortie">Nombre de port en sortie :</label>
<input type="number" name="nbSortie" id="nbSortie" step="1" value="null" min="0" max="500"/>
</div>
<div>
<label for="noSalle">N° de la salle</label>
<select name="noSalle">
<?php
require_once 'includes/inc_connect.php';
connectdb();
$req = "SELECT no_salle FROM salle";
$result = mysql_query($req);
while ($reqSalle = mysql_fetch_assoc($result))
{
echo "<option value=$reqSalle[no_salle]>$reqSalle[no_salle]</option>";
}
mysql_close();
?>
</select>
</div>
<div>
<label for="noArmoire">N° de l'armoire</label>
<input type="number" name="noArmoire" id="noArmoire" step="1" min="0" max="20" value="null"/>
</div>
<input type="submit" name="valider" value="Ajouter" />
<input type="hidden" name="ok" value="ok" />
</form>
<?php
}
?>
</body>
</html>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for git.master , git.master_jit , rfc.property-hooks <!DOCTYPE html>
<!--
Cette page permet l'ajout d'un objet
-->
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<!-- formulaire ajout objet -->
<form action="ajout.php" method="post" class="formAjout">
<div>
<label for="libObjet"><br>libellé de l'objet :</label>
<input type="text" name="libObjet" id="libObjet" value=""/>
</div>
<div>
<label for="typeObjet">Type de l'objet :</label>
<select name="typeObjet">
Warning: require_once(): open_basedir restriction in effect. File(includes/inc_connect.php) is not within the allowed path(s): (/tmp:/in:/etc) in /in/7OE7X on line 83
Warning: require_once(includes/inc_connect.php): Failed to open stream: Operation not permitted in /in/7OE7X on line 83
Fatal error: Uncaught Error: Failed opening required 'includes/inc_connect.php' (include_path='.:') in /in/7OE7X:83
Stack trace:
#0 {main}
thrown in /in/7OE7X on line 83
Process exited with code 255 . This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.
Active branches Archived branches Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page
preferences:dark mode live preview
39.19 ms | 402 KiB | 8 Q