1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
|
<?php
require_once ('../PHP-TESTS/mysqli_connect_test.php');
echo '<form action="test2.php" method="post">
<h3>QUESTIONS</h3>
<p> Numero de la question: <input type="text" name="question_number"></p>
<p> Question: <input type="text" name="question"></p>
<p> Commentaire: <input type="text" name="comment"></p>
<p><input type="submit" name="submit" value="Submit" /> </p>
<input type="hidden" name="submitted" value="TRUE" />
</form>';
echo '<h1>Registered questions</h1>';
require_once ('../PHP-TESTS/mysqli_connect_test.php');
$q= "SELECT question, comment FROM questions";
$r=@mysqli_query($dbc, $q);
$num=mysqli_num_rows($r);
if ($num > 0){
echo '<table align="center" cellspacing="3" cellpadding="3" width="75%">
<tr>
<td align="left"><b>Question</b></td>
<td align="left"><b>Comment</b></td>
</tr>';
while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
echo '<tr>
<td align="left">' . $row['question'] . '</td>
<td align="left">' . $row['comment'] . '</td>
</tr>';
}
echo '</table>';
mysqli_free_result ($r);
}
else {
echo '<p> There are currently no registered questions. </p>';
}
if ((isset ($_POST['submitted'])) || (isset ($_POST['submit']))){
$errors=array();
if (empty ($_POST['question_number'])){
$errors[]= 'Your forgot to enter the number of the question.';
}
else {
$n =mysqli_real_escape_string($dbc,trim ($_POST['question_number']));
}
if (empty($_POST['question'])) {
$errors[] = 'Your forgot to enter the question.';
}
else {
$q = mysqli_real_escape_string($dbc,trim($_POST['question']));
}
if (!empty($_POST['comment'])){
$c=mysqli_real_escape_string($dbc,trim($_POST['comment']));
}
else {
$c='';
}
if (empty($errors)){
$q = "INSERT INTO questions(question, comment) VALUES ('$q', '$c')";
$r = @mysqli_query($dbc, $q);
if (mysqli_affected_rows($dbc) == 1) {
echo '<h1> Your question has been successfully inserted !</h1>';
}
else {
echo '<h1> System Error </h1>
<p> Your question could not be inserted due to a system error </p>';
echo '<p> ' . mysqli_error($dbc) . '<br/> <br /> Query : ' . $q . ' </p>';
}
exit ();
}
else {
echo '<h1> Error !</h1>
<p> The following error(s) occured : <br />';
foreach ($errors as $msg) {
echo " - $msg <br /> \n";
}
echo '</p><p> Please try again. </p><p><br /></p>';
}
mysqli_close($dbc);
}
?> |
Partager