<?php
function mysql_abrir_sessao(){
include "config.php";
$dbh = mysql_connect ("$hostname", "$username", "$password");
if (!mysql_connect($hostname, $username, $password)) {
echo 'Could not connect to mysql';
return mysql_errno();
}else{
$conectadb = mysql_select_db ($database, $dbh);
if (!mysql_select_db($database, $dbh)){
echo 'Could not connect to database';
return mysql_errno();
}
}
return $dbh;}
function formulario(){
echo "<form method=\"POST\" action=\"crialinhadotexto.php\">senha para criar novo jogo: <input type=\"password\" name=\"senhanovatabela\"<br />Nome do novo jogo: <input type=\"text\" name=\"jogo\" size=\"10\"><br />e-mail do autor do jogo: <input type=\"text\" name=\"email\" size=\"10\"><br /><input type=\"submit\" name=\"apertou\" value=\" cadastrar \"></form>";
}
function listajogos(){
mysql_abrir_sessao();
$lista = mysql_query('SELECT `id_jogo`, `jogo` FROM `jogo`;');
echo "<h2>";
if (!$lista){
echo "DB Error, could not list jogos\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_row($lista)){
echo "Jogo: {$row[0]} => {$row[1]}<br />";
}
echo "<h2>";
}
?>