-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_topic.php
62 lines (42 loc) · 1.39 KB
/
add_topic.php
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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="forum.css" />
<title>Adicionar Tópico</title>
</head>
<body>
<?php
$host="localhost";
$username="root";
$password="";
$db_name="forum";
$tbl_name="forum_q";
mysql_connect("$host", "$username", "$password")or die("Não conectou");
mysql_select_db("$db_name")or die("Não foi possível selecionar banco de dados!");
session_start();
$login = $_SESSION["LOGIN"];
$logado = $_SESSION["LOGADO"];
if ($logado == 0)
{
header("location:forum.php");
}
$topic=$_POST['topic'];
$detail=$_POST['detail'];
$datetime=date("d/m/y h:i:s");
$res = mysql_query("select * from dados_usuario where usuario = '$login' ");
$row = mysql_fetch_assoc($res);
$nome = $row["nome"];
$sql="INSERT INTO $tbl_name(topic, detail, name, datetime)VALUES('$topic', '$detail', '$nome', '$datetime')";
$result=mysql_query($sql);
if($result){
echo "Tópico inserido com sucesso!<BR>";
echo "<a href=usuario.php>Veja seu tópico !</a>";
}
else {
echo "ERRO";
}
mysql_close();
?>
</body>
</html>