<?php
$sql = "CREATE TABLE IF NOT EXISTS questoes (
id int NOT NULL AUTO_INCREMENT,
pergunta varchar(255) NOT NULL,
op1 varchar(255) NOT NULL,
op2 varchar(255) NOT NULL,
PRIMARY KEY (id)
);";
if ($mysqli->query($sql) === TRUE) {
echo "Tabela criada com sucesso\n";
} else {
echo "Erro a criar a tabela: " . $conn->error ."\n";
}
//$mysqli->query($sql);
$sql_insert = "INSERT INTO questoes (pergunta,op1,op2) VALUES" .
" ('pergunta1','opcao1','opcao2'),".
"('pergunta2','opcaoa','opcaob'),".
"('pergunta3','opcaoc','opcaod'),".
"('pergunta4','opcaoe','opcaof'),".
"('pergunta5','opcaog','opcaoh'),".
"('pergunta6','opcaoi','opcaoj')";
$mysqli->query($sql_insert);
//selecionar valor
$sql = "SELECT * FROM questoes";
$max = ($mysqli->query($sql))->num_rows;
srand((double) microtime() * 1000000);
echo "-->".$max."\n";
$aleatorio = rand(1, $max);
echo $aleatorio;
$result = $mysqli->query("select * from questoes Where id = $aleatorio");
$row = $result -> fetch_assoc();
echo $row['id']."\n";
echo $row['pergunta']."\n";
echo $row['op1']."\n";
echo $row['op2']."\n";
//formulario
//...
echo "<h1>Questoes</h1>";
echo "<h1>Questoes</h1>" ;/*.
"<p>".$row['pergunta']."</p>" .
"<p>".$row['op1']."</p>" .
"<p>".$row['op2']."</p>";*/
echo "<form action='' method='post'>";
echo '<input type="radio" id="op1" name="op" value="1">';
echo '<label for="op1">'.$row['op1'].'</label><br/>';
echo '<input type="radio" id="op2" name="op" value="2">';
echo '<label for="op2">'.$row['op2'].'</label><br/>';
echo '<button type="submit">Enviar</button>';
echo "</form>";
$result -> free_result();
$mysqli -> close();
?>