Jump to content

adhbvklwqdbviabjiawdnbij

Members
  • Posts

    37
  • Joined

  • Last visited

    Never

Everything posted by adhbvklwqdbviabjiawdnbij

  1. I'm trying: exec ("/usr/bin/php send_action.php >/dev/null &"); This file is on the same folder of send_action.php, but its not working...
  2. Something like this? exec('theactioniwanttoexecute.php');
  3. I have an action that will take a long time to finish, so how can I run this action in background? So I will not have to wait it ends...
  4. Ok, i know how to send one email every 30 seconds, but how to send 10 emails every 30 seconds?
  5. Thanks... How can i make the script run in "background"? How can i make the script send 10 email every 30 seconds?
  6. Is there anything I should change on this code? I'll use it to send about 20000 emails... I don't like this one, because while sending the emails, the page keep loading... I kind dont "trust" on this script.. index.php <?php include('config.php'); include('class.phpmailer.php'); include('email.php'); // Get users info $getUser_sql_not_sent = "SELECT * FROM emails WHERE sent = '0'"; $getUser_not_sent = mysql_query($getUser_sql_not_sent); $getUser_num_not_sent = mysql_num_rows($getUser_not_sent); $getUser_sql_sent = "SELECT * FROM emails WHERE sent = '1'"; $getUser_sent = mysql_query($getUser_sql_sent); $getUser_num_sent = mysql_num_rows($getUser_sent); $getUser_sql_all = "SELECT * FROM emails"; $getUser_all = mysql_query($getUser_sql_all); $getUser_num_all = mysql_num_rows($getUser_all); $getUser_sql_accessed = "SELECT * FROM emails WHERE accessed = '1'"; $getUser_accessed = mysql_query($getUser_sql_accessed); $getUser_num_accessed = mysql_num_rows($getUser_accessed); $money = $getUser_num_accessed * 0.20; $money_formated = number_format($money, 2, ',', ''); $x = $getUser_num_sent * 100; $y = $getUser_num_all; $percentage = $x / $y; $percentage_formated = number_format($percentage, 0, '', ''); if ($getUser_num_not_sent == $getUser_num_all) { echo '<form action = "send.php" method = "post">'; echo '<strong>Assunto do Email</strong><br />'; echo $emailSubject; echo '<br />'; echo '<strong>Corpo do Email</strong><br />'; echo $emailBody; echo '<br /><br />'; echo '<input name = "send" type = "submit" value = "Enviar Emails" />'; echo '</form>'; } else { echo "Foram enviados " . $percentage_formated . "&#37; dos emails. " . $getUser_num_accessed . " acessaram o site, bonificação de R&#36; " . $money_formated . " para o Claudius Ibn."; } ?> <?php include('config.php'); include('class.phpmailer.php'); include('email.php'); echo 'Os emails estao sendo enviados, voce pode sair do site que o processo continuara mesmo assim.'; // Get users info $getUser_sql_not_sent = "SELECT * FROM emails WHERE sent = '0'"; $getUser_not_sent = mysql_query($getUser_sql_not_sent); $getUser_num_not_sent = mysql_num_rows($getUser_not_sent); $mail = new PHPMailer(); while ($row = mysql_fetch_array($getUser_not_sent)) { // Get the current user's email $emailUser = $row['email']; // Define mail object and mail parameters $mail -> From = 'campainha@ibnshare.com'; $mail -> FromName = 'Campainha'; $mail -> AddAddress($emailUser); $mail -> Subject = $emailSubject; $mail -> Body = $emailBody; // Send and verify if(!$mail -> Send()) { echo 'Erro: '. $mail -> ErrorInfo; } else { mysql_query("UPDATE emails SET sent = '1' WHERE email = '$emailUser'"); } sleep(30); } ?>
  7. Why the button "Enviar Emails" is not working? --> http://www.ibnshare.com/email/ (login: 123abc password: 123abc) echo '<form action = "send.php" method = "post">'; echo '<strong>Assunto do Email</strong><br />'; echo $emailSubject; echo '<br />'; echo '<strong>Corpo do Email</strong><br />'; echo $emailBody; echo '<br /><br />'; echo '<input name = "send" type = "button" value = "Enviar Emails" />'; echo '</form>';
  8. With this script: <?php $i=1; while($i<=5) { echo "The number is " . $i . "<br />"; $i++; sleep(3); } ?> I get: How can I make this dynamic. For example: First it would get: After 3 seconds... After 3 seconds... .......
  9. I made some changes on the script. <?php require_once('../includes/link.php'); $query = "SELECT * FROM emails"; $result = mysql_query($query); while($row = mysql_fetch_array($result)) { mail("$row['email']", "Teste - Enviar Emails", "Teste - Enviar Emails", "From: Teste - Enviar Emails"); sleep(3); } ?> But is giving Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING on mail("$row['email']", "Teste - Enviar Emails", "Teste - Enviar Emails", "From: Teste - Enviar Emails");
  10. Using just this <?php session_start(); require_once('../includes/link.php'); $errmsg_arr = array(); $errflag = false; echo "$_SESSION['SESS_EMAIL]"; ?> I got the same error Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/ibn/public_html/emailbomber/actions/sendemails.php on line 8
  11. The error persist Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/ibn/public_html/emailbomber/actions/sendemails.php on line 8 <?php session_start(); require_once('../includes/link.php'); $errmsg_arr = array(); $errflag = false; mail("$_SESSION['SESS_EMAIL']", "Teste - Enviar Emails", "Olá, ".$_SESSION['SESS_NAME']."\n\nTeste - Enviar Emails, From Teste"); $errmsg_arr[] = 'Os email serao enviados dentro de no maximo 48 horas.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../users/user/sendemails.php"); ?>
  12. Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/ibn/public_html/emailbomber/actions/sendemails.php on line 8 <?php session_start(); require_once('../includes/link.php'); $errmsg_arr = array(); $errflag = false; mail("$_SESSION['SESS_EMAIL']", "Teste - Enviar Emails", "Olá, ".$_SESSION['SESS_NAME']."\n\nTeste - Enviar Emails, "From Teste"); $errmsg_arr[] = 'Os email serao enviados dentro de no maximo 48 horas.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../users/user/sendemails.php"); ?>
  13. I know this should be made with ajax, but i have no idea from where start. I'd like to show the option "Escola" only if the option "Administrador" or "Moderador" be selected in the option "Status". How can i do that? <?php session_start(); require_once('includes/auth.php'); ?> <!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=iso-8859-1" /> <title>Registrar Usuario</title> <link rel="stylesheet" href="../../css/styles.css" type="text/css"> </head> <body> <h1>Registrar Usuario</h1> <?php include("includes/header.php"); ?> <p>Uma senha sera gerada e enviada para o email do usuario.</p> <form id="loginForm" name="loginForm" method="post" action="../../actions/sadmin_register_user.php"> <table width="300" border="0" align="left" cellpadding="2" cellspacing="0"> <tr> <th>Status</th> <td> <select name="school" id="school" > "; <option value="1">Super Administrador</option> <option value="2">Super Moderador</option> <option value="3">Administrador</option> <option value="4">Moderador</option> </select> </td> </tr> <tr> <th>Escola</th> <td> <?php require_once('../../includes/link.php'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); $query = "SELECT * FROM schools"; $result = mysql_query($query); echo "<select name=\"school\" id=\"school\" > "; while($row = mysql_fetch_array($result)) { echo "<option value=\"" . $row['id'] . "\">" . $row['name'] . "</option>"; } echo "</select>"; ?> </td> </tr> <tr> <th>Nome Completo</th> <td><input name="name" type="text" class="textfield" id="name" /></td> </tr> <tr> <th>Email</th> <td width="168"><input name="email" type="text" class="textfield" id="email" /></td> </tr> <tr> <th>Confirmar Email</th> <td><input name="cemail" type="text" class="textfield" id="cemail" /></td> </tr> <tr> <td> </td> <td><input type="submit" name="Submit" value="Registrar" /></td> </tr> </table> </form> </body> </html>
  14. Here is my database: CREATE TABLE IF NOT EXISTS `users` ( `id` int(100) unsigned NOT NULL auto_increment, `status` int(100) default NULL, `school_id` int(100) default NULL, `class_id` int(100) default NULL, `registration` varchar(255) default NULL, `name` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `schools` ( `id` int(100) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `classes` ( `id` int(100) unsigned NOT NULL auto_increment, `school_id` int(100) default NULL, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `subjects` ( `id` int(100) unsigned NOT NULL auto_increment, `school_id` int(100) default NULL, `class_id` int(100) default NULL, `teacher_id` int(100) default NULL, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `grades` ( `id` int(100) unsigned NOT NULL auto_increment, `school_id` int(100) default NULL, `class_id` int(100) default NULL, `subject_id` int(100) default NULL, `teacher_id` int(100) default NULL, `student_id` int(100) default NULL, `value` float(2,2) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; INSERT INTO `users` (`name`, `status`, `email`, `password`) VALUES ('Claudius ou Afonso', '1', 'email', 'e8d95a51f3af4a3b134bf6bb680a213a');
  15. login.php <?php session_start(); require_once('../includes/link.php'); include('../functions/clean.php'); $errmsg_arr = array(); $errflag = false; $email = clean($_POST['email']); $password = clean($_POST['password']); if(($email == '') OR ($password == '')) { $errmsg_arr[] = 'Por favor, preencha todos os campos.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../index.php"); exit(); } $query = "SELECT * FROM users WHERE email = '$email' AND password = '".md5($_POST['password'])."'"; $result = mysql_query($query); $user = mysql_fetch_assoc($result); if(mysql_num_rows($result) == 1) { $user = mysql_fetch_assoc($result); session_regenerate_id(); $_SESSION['SESS_USER_ID'] = $user['id']; $_SESSION['SESS_STATUS'] = $user['status']; $_SESSION['SESS_SCHOOL_ID'] = $user['school_id']; $_SESSION['SESS_CLASS_ID'] = $user['class_id']; $_SESSION['SESS_NAME'] = $user['name']; $_SESSION['SESS_REGISTRATION'] = $user['registration']; $_SESSION['SESS_EMAIL'] = $user['email']; session_write_close(); if($_SESSION['SESS_STATUS'] == 1) { header("location: ../users/superadministrator/index.php"); exit(); } } else { $errmsg_arr[] = 'Suas informacoes de login estao incorreta. Por favor, tente novamente.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../index.php"); exit(); } ?>
  16. I find one error and changed what you said. Changed $query = "SELECT * FROM users WHERE email = '$email' AND passwd = '".md5($_POST['password'])."'";" to $query = "SELECT * FROM users WHERE email = '$email' AND password = '".md5($_POST['password'])."'"; And removed the if($result) and it's else, but now its giving a blank screen!
  17. I'm always getting the "Falha ao selecionar o usuario no banco de dados." error. Why??? Another thing, any tip to improve my code? A way to do the same thing, but with a "more clean" code... login.php <?php session_start(); require_once('../includes/link.php'); include('../functions/clean.php'); $errmsg_arr = array(); $errflag = false; $email = clean($_POST['email']); $password = clean($_POST['password']); if(($email == '') OR ($password == '')) { $errmsg_arr[] = 'Por favor, preencha todos os campos.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../index.php"); exit(); } $query = "SELECT * FROM users WHERE email = '$email' AND passwd = '".md5($_POST['password'])."'"; $result = mysql_query($query); $user = mysql_fetch_assoc($result); if($result) { if(mysql_num_rows($result) == 1) { $user = mysql_fetch_assoc($result); session_regenerate_id(); $_SESSION['SESS_ID'] = $user['id']; $_SESSION['SESS_STATUS'] = $user['status']; $_SESSION['SESS_SCHOOL_ID'] = $user['school_id']; $_SESSION['SESS_CLASS_ID'] = $user['class_id']; $_SESSION['SESS_NAME'] = $user['name']; $_SESSION['SESS_REGISTRATION'] = $user['registration']; $_SESSION['SESS_EMAIL'] = $user['email']; session_write_close(); if($_SESSION['SESS_STATUS'] == 1) { header("location: ../users/superadministrator/index.php"); exit(); } } else { $errmsg_arr[] = 'Suas informacoes de login estao incorreta. Por favor, tente novamente.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../index.php"); exit(); } } else { die("Falha ao selecionar o usuario no banco de dados."); } ?> link.php <?php define('DB_HOST', 'localhost'); define('DB_USER', 'root'); define('DB_PASSWORD', ''); define('DB_DATABASE', 'social_escola'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$link) { die('Falha ao conectar ao servidor: ' . mysql_error()); } $db = mysql_select_db(DB_DATABASE); if (!$db) { die('Falha ao selecionar o banco de dados: ' . mysql_error()); } ?> clean.php <?php function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } ?>
  18. I want to select the user from super_administrators, administrators, teachers and students, and give the user permission based from what table he "came". But is giving the "Query failed" error... <?php //Start session session_start(); //Include database connection details require_once('../config/config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } //Function to sanitize values received from the form. Prevents SQL injection function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } //Sanitize the POST values $email = clean($_POST['email']); $password = clean($_POST['password']); //Input Validations if($email == '') { $errmsg_arr[] = 'O campo Email nao foi preenchido.'; $errflag = true; } if($password == '') { $errmsg_arr[] = 'O campo Senha nao foi preenchido.'; $errflag = true; } //If there are input validations, redirect back to the login form if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../index.php"); exit(); } //Create query $qry = "SELECT * FROM super_administrators,administrators,teachers,students WHERE email = '$email' AND passwd = '".md5($_POST['password'])."'"; $result = mysql_query($qry); $member = mysql_fetch_assoc($result); $table = mysql_field_table('$result', '0'); //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) == 1) { if($table == 'super_administrators') { session_regenerate_id(); $_SESSION['SESS_ID'] = $member['id']; $_SESSION['SESS_NAME'] = $member['name']; $_SESSION['SESS_EMAIL'] = $member['email']; session_write_close(); header("location: ../users/sadmin/index.php"); exit(); } if($table == 'administrators') { session_regenerate_id(); $_SESSION['SESS_ID'] = $member['id']; $_SESSION['SESS_SCHOOL_ID'] = $member['school_id']; $_SESSION['SESS_NAME'] = $member['name']; $_SESSION['SESS_EMAIL'] = $member['email']; session_write_close(); header("location: ../users/admin/index.php"); exit(); } if($table == 'teachers') { session_regenerate_id(); $_SESSION['SESS_ID'] = $member['id']; $_SESSION['SESS_SCHOOL_ID'] = $member['school_id']; $_SESSION['SESS_NAME'] = $member['name']; $_SESSION['SESS_EMAIL'] = $member['email']; session_write_close(); header("location: ../users/prof/index.php"); exit(); } if($table == 'students') { session_regenerate_id(); $_SESSION['SESS_ID'] = $member['id']; $_SESSION['SESS_SCHOOL_ID'] = $member['school_id']; $_SESSION['SESS_CLASS_ID'] = $member['class_id']; $_SESSION['SESS_NAME'] = $member['name']; $_SESSION['SESS_REGISTRATION'] = $member['registration']; $_SESSION['SESS_EMAIL'] = $member['email']; session_write_close(); header("location: ../users/aluno/index.php"); exit(); } } else { $errmsg_arr[] = 'Suas informacoes de login estao incorreta. Por favor, tente novamente.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../index.php"); exit(); } } else { die("Query failed"); } ?>
  19. I dont know why the $school_id = clean($_POST['school']); is not working... register_user.php <?php session_start(); require_once('auth.php'); ?> <!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=iso-8859-1" /> <title>Registrar Usuario</title> <link rel="stylesheet" href="../../css/styles.css" type="text/css"> </head> <body> <h1>Registrar Usuario</h1> <?php include("header.php"); ?> <p>Uma senha sera gerada e enviada para o email do usuario.</p> <form id="loginForm" name="loginForm" method="post" action="../../actions/sadmin_register_user.php"> <table width="300" border="0" align="left" cellpadding="2" cellspacing="0"> <tr> <th>Escola</th> <td><select name="school" id="school" > <?php require_once('../../config/config.php'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Falha ao conectar ao servidor: ' . mysql_error()); } $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Falha ao selecionar o banco de dados."); } $qry = "SELECT * FROM schools"; $result = mysql_query($qry); while($row = mysql_fetch_array($result)) { echo "<option value=\"" . $row['school_id'] . "\">" . $row['school_name'] . "</option>"; } ?> </select></td> </tr> <tr> <th>Nome Completo</th> <td><input name="name" type="text" class="textfield" id="name" /></td> </tr> <tr> <th width="124">Email</th> <td width="168"><input name="email" type="text" class="textfield" id="email" /></td> </tr> <tr> <th>Confirmar Email</th> <td><input name="cemail" type="text" class="textfield" id="cemail" /></td> </tr> <tr> <td> </td> <td><input type="submit" name="Submit" value="Registrar" /></td> </tr> </table> </form> </body> </html> sadmin_register_user.php <?php //Start session session_start(); //Include database connection details require_once('../config/config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Falha ao conectar ao servidor: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Falha ao selecionar o banco de dados."); } //Function to sanitize values received from the form. Prevents SQL injection function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } //Sanitize the POST values $name = clean($_POST['name']); $school_id = clean($_POST['school']); $email = clean($_POST['email']); $cemail = clean($_POST['cemail']); $category = 3; //Get random password function createRandomPassword() { $chars = "abcdefghijkmnopqrstuvwxyz0123456789"; srand((double)microtime()*1000000); $i = 0; $pass = '' ; while ($i <= 7) { $num = rand() % 33; $tmp = substr($chars, $num, 1); $pass = $pass . $tmp; $i++; } return $pass; } $password = createRandomPassword(); //Input Validations if($name == '') { $errmsg_arr[] = 'O campo Nome nao foi preenchido.'; $errflag = true; } if($email == '') { $errmsg_arr[] = 'O campo Email nao foi preenchido.'; $errflag = true; } if($cemail == '') { $errmsg_arr[] = 'O campo Confirmar Email nao foi preenchido.'; $errflag = true; } if( strcmp($email, $cemail) != 0 ) { $errmsg_arr[] = 'O campo Senha e Confirmar Senha nao correpondem.'; $errflag = true; } //Check for duplicate login ID if($email != '') { $qry = "SELECT * FROM members WHERE email='$email'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) > 0) { $errmsg_arr[] = 'Esse email ja se encontra em uso.'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed"); } } //If there are input validations, redirect back to the registration form if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../users/sadmin/register_user.php"); exit(); } //Create INSERT query $qry = "INSERT INTO members(name, school_id, category, matricula, email, passwd) VALUES('$name','$school_id','$category','$matricula','$email','".md5($password)."')"; $result = @mysql_query($qry); //Check whether the query was successful or not if($result) { mail ( "$email", "Sua Senha", "Sua senha e: ".$password."", "From: you@yoursite.com" ); $errmsg_arr[] = 'O usuario foi registrado com sucesso.'; $errflag = true; $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../users/sadmin/register_user.php"); exit(); }else { die("Query failed"); } ?>
  20. Worked. Now i`m having another problem when logouting... Warning: Cannot modify header information - headers already sent by (output started at /home/ibn/public_html/escola/actions/logout.php:18) in /home/ibn/public_html/escola/actions/logout.php on line 19 <?php //Start session session_start(); //Unset the variables stored in session unset($_SESSION['SESS_MEMBER_ID']); unset($_SESSION['SESS_FIRST_NAME']); unset($_SESSION['SESS_CATEGORY']); ?> <!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=iso-8859-1" /> <title>Sair</title> <link href="../loginmodule.css" rel="stylesheet" type="text/css" /> </head> <body> <?php header("location: ../index.php"); ?> </body> </html>
  21. I want to show de Logout button when $_SESSION['SESS_CATEGORY'] is 3 but i get a error: Parse error: syntax error, unexpected '<' in /home/ibn/public_html/escola/home.php on line 17 <?php if(trim($_SESSION['SESS_CATEGORY']) == '3') { echo <a href="actions/logout.php">Logout</a>; exit(); } ?>
  22. I got a blank screen when use this register.php on an action: <?php //Start session session_start(); //Include database connection details require_once('../config/config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Falha ao conectar ao servidor: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Falha ao selecionar o banco de dados."); } //Function to sanitize values received from the form. Prevents SQL injection function clean($str) { $str = @trim($str); if(get_magic_quotes_gpc()) { $str = stripslashes($str); } return mysql_real_escape_string($str); } //Sanitize the POST values $name = clean($_POST['name']); $matricula = clean($_POST['matricula']); $email = clean($_POST['email']); //Get randon password $password = randomStr(6, ; //Input Validations if($name == '') { $errmsg_arr[] = 'O campo Nome nao foi preenchido.'; $errflag = true; } if($matricula == '') { $errmsg_arr[] = 'O campo Matricula nao foi preenchido.'; $errflag = true; } if($email == '') { $errmsg_arr[] = 'O campo Email nao foi preenchido.'; $errflag = true; } //Check for duplicate email if($email != '') { $qry = "SELECT * FROM members WHERE email='$email'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) > 0) { $errmsg_arr[] = 'Esse email ja se encontra em uso.'; $errflag = true; } @mysql_free_result($result); } else { die("Query failed"); } } //If there are input validations, redirect back to the registration form if($errflag) { $_SESSION['ERRMSG_ARR'] = $errmsg_arr; session_write_close(); header("location: ../register.php"); exit(); } //Create INSERT query $qry = "INSERT INTO members(name, matricula, email, passwd) VALUES('$name','$matricula','$email','".md5($password'])."')"; $result = @mysql_query($qry); //Check whether the query was successful or not if($result) { header("location: ../register_success.php"); exit(); }else { die("Query failed"); } ?>
  23. Thanks. I used: <?php session_start(); ?> and <?php if( isset($_SESSION['ERRMSG_ARR']) && is_array($_SESSION['ERRMSG_ARR']) && count($_SESSION['ERRMSG_ARR']) >0 ) { echo '<ul class="err">'; foreach($_SESSION['ERRMSG_ARR'] as $msg) { echo '<li>',$msg,'</li>'; } echo '</ul>'; unset($_SESSION['ERRMSG_ARR']); } ?>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.