I have a database table called quiz(quest ,op1,op2,op3,op4,answer,num), all fields except num are of type varchar ,num being the primary key. now in a php page i need the question(<p>
element) to be dynamically retrieved as quest field, four radio buttons to have their values assigned by the op(n) fields of this database. Please explain how i can do that.
html:
SELECT ALL
<html>
<head>
<script language="javascript">
function loadXMLDoc()
{
var q=Math.floor((Math.random()*3)+1);
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
[color=#8000FF]document.getElementById("op1").innerHTML=xmlhttp.responseText;
document.getElementById("op2").innerHTML=xmlhttp.responseText;
document.getElementById("op3").innerHTML=xmlhttp.responseText;
document.getElementById("op4").innerHTML=xmlhttp.responseText;[/color]//this is the code i need help //with
}
}
xmlhttp.open("GET","questions.php?num="+q,true);
xmlhttp.send();
}
</script></head>
<h1 align='center'><b>Object oriented programming-#1</b></h1>
<h2 align='center'>Supriya Raheja<h2>
<title>quiz has started</title>
<body>
<div style="text-align:left">
<table border="1">
<tr>
<td width="25%"><table border="0">
<tr>
<td><button type="button">Goto Q1</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q2</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q3</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q4</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q5</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q6</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q7</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q8</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q9</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q10</button></td>
<td><input type="checkbox">
</tr>
<tr>
<td><button type="button">Goto Q11</button></td>
<td><input type="checkbox">
</tr>
</td>
</table>
<td width="1000px">
<input type="radio" name="op1" value="" ></br>
<input type="radio" name="op2" value="" ></br>
<input type="radio" name="op3" value="" ></br>
<input type="radio" name="op4" value="" ></br>
<button style="text-align:bottom" type="button" onclick="loadXMLDoc()">Change
Content</button>
</td>
</tr>
</table>
</body>
</html>
php
<?php
$q=$_GET["q"];
$con = mysqli_connect('localhost','root','ayushigarg','quiz4');
if (!$con)
{
die('Could not connect: ' . mysqli_error($con));
}
mysqli_select_db($con,"quiz4");
$sql="SELECT * FROM quiz WHERE num = '".$q."'";
$result = mysqli_query($con,$sql);
//echo "<table border='1'>
$row = mysql_fetch_array($result)
echo '{"questionTxt" : "' . $row['quest'] .
'", "answ1" : "' . $row['op1'] .
'", "answ2" : "' . $row['op2'] .
'", "answ3" : "' . $row['op3'] .
'", "answ4" : "' . $row['op4'] .
'", "hint" : "' . $row['hint'] . '"}';
mysqli_close($con);
?>
?>
i want these answ1 , answ2 etc values to be assigned to op1, op2 etc values whecn i click on change content button... pls help