Hi,
this is an Ticket Support system, so i can't do connect to database
Help me please and sorry my english...
I'm from Brazil.
this is an Ticket Support system, so i can't do connect to database
PHP:
<?
break;
}
case "openticket":{
$open = $_GET['open'];
if($open == 1){
connect_db();
$query = mysql_query("SELECT * FROM `accounts` WHERE `id` = '$acc_logged'") or die(mysql_error());
$sql = mysql_fetch_array($query);
$result= mysql_db_query($db_db,"SELECT * FROM `ticket` ORDER BY id DESC") or die(mysql_error());
$data = date('Y/m/d');
$hora = date('H:i:s');
$email2 = $_POST['email2'];
$autor = $_POST['name2'];
$department = $_POST['department'];
$subject = $_POST['subject'];
$message = $_POST['message'];
$priority = $_POST['priority'];
$codigo = $_POST['codigo'];
$status = $_POST['status2'];
if($subject == "" || $message == ""){
echo '<TABLE BORDER=0 colspan="3" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tr><td class="header3">Fill all fields correctly.</td></tr></table>';
}
else{
$sql = "INSERT INTO ticket (id, account_id, name, email, department, subject, message, priority, status, autor, date, time, id_registro) values ('','" .$acc_logged. "','" .$autor. "','" .$email2. "','" .$department. "','" .$subject. "','" .$message. "','" .$priority. "','" .$status. "','" .$autor. "','" .$data. "','" .$hora. "','" .$codigo. "')";
$consulta = mysql_query($sql);
echo '<TABLE BORDER=0 colspan="3" CELLSPACING=1 CELLPADDING=4 WIDTH=100%><tr><td class="header3">Sending message...</td></tr></table>';
?>
<META HTTP-EQUIV="refresh" content=3;URL=?subtopic=accountmanagement>
<?
}
?>
<BR>
<input type="button" value="Back" onclick="history.back();">
<?
}elseif($open == ""){
$codigo = rand(1, 99999999);
connect_db();
$query = mysql_query("SELECT * FROM `accounts` WHERE `id` = '$acc_logged'");
$sql = mysql_fetch_array($query);
$name = $sql['rlname'];
$email = $sql['email'];
?>
Help me please and sorry my english...
I'm from Brazil.