prva

<link rel="stylesheet" type="text/css" href="css.css">
<?PHP

$errorMessage = "";

if ($_SERVER['REQUEST_METHOD'] == 'POST'){

		//===================================================
		//	GET THE QUESTION AND ANSWERS FROM THE FORM
		//===================================================
	$question = $_POST['question'];
	$answerA = $_POST['AnswerA'];
	$answerB = $_POST['AnswerB'];
	$answerC = $_POST['AnswerC'];


	$question  = htmlspecialchars($question);
	$answerA = htmlspecialchars($answerA);
	$answerB = htmlspecialchars($answerB);
	$answerC = htmlspecialchars($answerC);


		//============================================
		//	OPEN A CONNECTION THE DATABASE
		//============================================
$user_name = "BRUDER";
	$password = "fhi";
	$database = "BRUDER";
	$hostname="localhost";

	$db_handle = mysql_connect($hostname, $user_name, $password);
	$db_found = mysql_select_db($database, $db_handle);

	if ($db_found) {

		//============================================
		//	GET THE LAST QUESTION NUMBER
		//============================================

		$SQL = "Select * FROM tblquestions";

		$result = mysql_query($SQL);
		$numRows = mysql_num_rows($result);

		$boolLastRow = mysql_data_seek($result, ($numRows - 1));

		$row = mysql_fetch_row($result);

		$qID = $row[0];

		$next_Q_Number = ltrim($qID, 'q');
		$next_Q_Number++;
		$question_Number = 'q' . $next_Q_Number;


		//=========================================================
		//	INSERT THE QUESTION INTO THE tblquestions TABLE
		//=========================================================

		$SQL = "INSERT INTO tblquestions (QID, Question, qA, qB, qC) VALUES ('$question_Number', '$question', '$answerA', '$answerB', '$answerC')";

		$result = mysql_query($SQL);


		//=============================================================
		//	SET A ROW IN THE answers TABLE, WITH THE SAME QID FIELD
		//=============================================================

		$SQL = "INSERT INTO answers (QID, A, B, C) VALUES ('$question_Number', 0, 0, 0)";
		$result = mysql_query($SQL);


		mysql_close($db_handle);

		print "Otazka bola vlozena do databazy";

	}
	else {
		print "Database NOT Found ";
		mysql_close($db_handle);
	}
}

?>


<html>
<head>
<title>Survey Admin Page</title>
</head>
<body>

<FORM NAME ="form1" METHOD ="POST" ACTION ="setQuestion.php" align="center">

Enter a question: <INPUT TYPE = 'TEXT' Name ='question'  value="Sem zadajte otazku" maxlength="40" align="center" class="textbox" onfocus="if (this.value == 'Sem zadajte otazku') {this.value=''}">
<p>
Answer A: <INPUT TYPE = 'TEXT' Name ='AnswerA'  value="Odpoved A" maxlength="20" onfocus="if (this.value == 'Odpoved A') {this.value=''}">
Answer B: <INPUT TYPE = 'TEXT' Name ='AnswerB'  value="Odpoved B" maxlength="20" onfocus="if (this.value == 'Odpoved B') {this.value=''}">
Answer C: <INPUT TYPE = 'TEXT' Name ='AnswerC'  value="Odpoved C" maxlength="20" onfocus="if (this.value == 'Odpoved C') {this.value=''}">

<P align = center>
<INPUT TYPE = "Submit" Name = "Submit1"  VALUE = "Vytvorit tuto otazku v databaze">
</P>

</FORM>

<P>
<?PHP print $errorMessage;?>

<?
echo "Tu je zoznam otazok:";
$user_name = "BRUDER";
	$password = "fhi";
	$database = "BRUDER";
	$hostname="localhost";

	$db_handle = mysql_connect($hostname, $user_name, $password);
	$db_found = mysql_select_db($database, $db_handle);

	if ($db_found) {
   $sql='SELECT QID, Question FROM tblquestions ';
   $result = mysql_query($sql);
   if (mysql_num_rows($result) > 0) {

    while($row = mysql_fetch_row($result)) {
        echo "<br> QID: ". $row[0]. " - Otazka: ". $row[1].  "";
    }
} else {
    echo "0 results";
}
}
mysql_close($db_handle);
?>
<br>
<FORM  METHOD ="get" ACTION ="sqlSurvey.php" align="center">
zadaj id otazky: <INPUT TYPE = 'TEXT' Name ='otazka'  value="q?" maxlength="5" align="center"  onfocus="if (this.value == 'q?') {this.value=''}">

<INPUT TYPE = "Submit" Name = "Submit1"  VALUE = "submit">
</FORM>
</P>
</body>
</html>