That Wikipedia Game
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM articulos";
$result = $conn->query($sql);
echo "$result->num_rows articles sent so far.";
$conn->close();
}
function articulonuevo(){
global $servername, $username, $password, $dbname;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM articulos";
$result = $conn->query($sql);
if ($result->num_rows < 2){
echo "Not enough articles were sent.";
} else {
$sql = "SELECT * FROM articulos ORDER BY RAND() LIMIT 1";
$result = $conn->query($sql);
$articulorestult = $result->fetch_assoc();
echo "Chosen article: " . $articulorestult["articulo"] . ".";
$sql = "DELETE FROM articulos WHERE id=" . $articulorestult["id"];
$conn->query($sql);
}
$conn->close();
}
function terminarpartida(){
global $servername, $username, $password, $dbname;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "DELETE FROM wikigame.articulos; ALTER TABLE wikigame.articulos AUTO_INCREMENT = 1";
$conn->multi_query($sql);
echo "Game finished. All articles have been deleted.";
$conn->close();
}
?>