[go: up one dir, main page]

Menu

[r1]: / funcoes.php  Maximize  Restore  History

Download this file

40 lines (33 with data), 1.2 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?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>";
}
?>