Jump to content

adhbvklwqdbviabjiawdnbij

Members
 View Profile  See their activity

  • Posts

    37

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by adhbvklwqdbviabjiawdnbij

  1. adhbvklwqdbviabjiawdnbij
    The error messages "O campo Email nao foi preenchido." and "O campo Senha nao foi preenchido." are not appearing when the fileds are blank. index.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>Login</title> <link href="loginmodule.css" rel="stylesheet" type="text/css" /> </head> <body> <h1>Login</h1> <form id="loginForm" name="loginForm" method="post" action="actions/login.php"> <table width="300" border="0" align="left" cellpadding="2" cellspacing="0"> <tr> <td width="112"><b>Email</b></td> <td width="188"><input name="email" type="text" class="textfield" id="email" /></td> </tr> <tr> <td><b>Senha</b></td> <td><input name="password" type="password" class="textfield" id="password" /></td> </tr> <tr> <td></td> <td><p><a href="resend_password.php">Esqueceu sua senha?</a></p></td> </tr> <tr> <td> </td> <td><input type="submit" name="Submit" value="Login" /></td> </tr> </table> </form> </body> </html> actions/login.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('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 members WHERE email='$email' AND passwd='".md5($_POST['password'])."'"; $result=mysql_query($qry); //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) == 1) { //Login Successful session_regenerate_id(); $member = mysql_fetch_assoc($result); $_SESSION['SESS_MEMBER_ID'] = $member['member_id']; $_SESSION['SESS_NAME'] = $member['name']; session_write_close(); header("location: ../home.php"); exit(); }else { //Login failed header("location: ../login_failed.php"); exit(); } }else { die("Query failed"); } ?>
  2. adhbvklwqdbviabjiawdnbij
    I would like to make a script in which the user registers on my website. After that, my script would sign in the user on another website and check up some information from a particular .pdf file. And everytime something changes in this .pdf, it would send an email notifying the user.
  3. adhbvklwqdbviabjiawdnbij
    But now i'm having problem in index.php. =/ Just another question. I would like also if that tables exist, to replace it. Like "cleaning" the tables.
  4. adhbvklwqdbviabjiawdnbij
    Now everything in this part is ok. Thanks. <?php ini_set("display_errors", "1"); error_reporting(-1); include('mysql.php'); $con = mysql_connect("$host", "$user", "$password"); if (!$con) { die('Fail: ' . mysql_error()); } $sql1 = 'CREATE DATABASE IF NOT EXISTS ' . $database; mysql_query($sql1, $con) or trigger_error('Fail Creating Database: ' . mysql_error()); mysql_select_db("$database") or trigger_error('Fail Selecting Database: ' . mysql_error()); $sql2 = 'CREATE TABLE IF NOT EXISTS `battles` ( `battle_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `winner` bigint(20) unsigned NOT NULL DEFAULT 0, `loser` bigint(20) unsigned NOT NULL DEFAULT 0, primary key (`battle_id`) )'; mysql_query($sql2, $con) or trigger_error('Error Creating Table battles: ' . mysql_error()); $sql3 = 'CREATE TABLE IF NOT EXISTS `images` ( `image_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `score` int(10) unsigned NOT NULL DEFAULT 1500, `wins` int(10) unsigned NOT NULL DEFAULT 0, `losses` int(10) unsigned NOT NULL DEFAULT 0, primary key (`image_id`) )'; mysql_query($sql3, $con) or trigger_error('Error Creating Table images: ' . mysql_error()); if ($handle = opendir('images')) { while (false !== ($file = readdir($handle))) { if($file!='.' && $file!='..') { $images[] = "('".$file."')"; } } closedir($handle); } $sql4 = "INSERT INTO images (filename) VALUES ".implode(',', $images)." "; mysql_query($sql4, $con) or trigger_error('Error Inserting The Images: ' . mysql_error()); mysql_close(); ?> But now i'm having problem in index.php. =/ Just another question. I would like also if that tables exist, to replace it. Like "cleaning" the tables.
  5. adhbvklwqdbviabjiawdnbij
    I did it. <?php ini_set("display_errors", "1"); error_reporting(-1); include('mysql.php'); $con = mysql_connect("$host", "$user", "$password"); if (!$con) { die('Fail: ' . mysql_error()); } $sql1 = 'CREATE DATABASE IF NOT EXISTS `' . $database . '`'; mysql_query($sql1, $con) or trigger_error('Fail Connecting To Database: ' . mysql_error()); mysql_select_db("$database") or trigger_error('Fail Selecting Database: ' . mysql_error()); $sql2 = 'CREATE TABLE IF NOT EXISTS `battles` ( `battle_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `winner` bigint(20) unsigned NOT NULL, `loser` bigint(20) unsigned NOT NULL, )'; mysql_query($sql2, $con) or trigger_error('Error Creating Table battles: ' . mysql_error()); $sql3 = 'CREATE TABLE IF NOT EXISTS `images` ( `image_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `score` int(10) unsigned NOT NULL DEFAULT '1500', `wins` int(10) unsigned NOT NULL DEFAULT '0', `losses` int(10) unsigned NOT NULL DEFAULT '0', )'; mysql_query($sql3, $con) or trigger_error('Error Creating Table images: ' . mysql_error()); mysql_close(); ?> But it's not working.
  6. adhbvklwqdbviabjiawdnbij
    Wait. I wll edit it.
  7. adhbvklwqdbviabjiawdnbij
    http://localhost/.../install.php Yes, show up a blank page. And in "view source" theres nothing. install.php <?php ini_set("display_errors", "1"); error_reporting(-1); include('mysql.php'); $con = mysql_connect("$host", "$user", "$password"); if (!$con) { die('Falha Na Conexão: ' . mysql_error()); } $sql1 = 'CREATE DATABASE IF NOT EXISTS `' . $database . '`'; mysql_query($sql1, $con) or trigger_error('Error Creating Database: ' . mysql_error()); $sql2 = 'CREATE TABLE IF NOT EXISTS `battles` ( `battle_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `winner` bigint(20) unsigned NOT NULL, `loser` bigint(20) unsigned NOT NULL, )'; mysql_query($sql2, $con); $sql3 = 'CREATE TABLE IF NOT EXISTS `images` ( `image_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `score` int(10) unsigned NOT NULL DEFAULT '1500', `wins` int(10) unsigned NOT NULL DEFAULT '0', `losses` int(10) unsigned NOT NULL DEFAULT '0', )'; mysql_query($sql3, $con); if ($handle = opendir('images')) { while (false !== ($file = readdir($handle))) { if($file!='.' && $file!='..') { $images[] = "('".$file."')"; } } closedir($handle); } $sql4 = "INSERT INTO images (filename) VALUES ".implode(',', $images)." "; mysql_query($sql4, $con); mysql_close(); ?>
  8. adhbvklwqdbviabjiawdnbij
    Nothing... =// I commented out all the rest, let only this. Didnt work. <?php ini_set("display_errors", "1"); error_reporting(-1); include('mysql.php'); $con = mysql_connect("$host", "$user", "$password"); if (!$con) { die('Falha Na Conexão: ' . mysql_error()); } $sql1 = 'CREATE DATABASE IF NOT EXISTS `' . $database . '`'; mysql_query($sql1, $con) or trigger_error('Error Creating Database: ' . mysql_error()); mysql_close(); ?>
  9. adhbvklwqdbviabjiawdnbij
    Again, nothing happened... <?php ini_set("display_errors", "1"); error_reporting(-1); include('mysql.php'); $con = mysql_connect("$host", "$user", "$password"); if (!$con) { die('Falha Na Conexão: ' . mysql_error()); } $sql1 = 'CREATE DATABASE IF NOT EXISTS `' . $database . '`'; mysql_query($sql1, $con) or trigger_error('Error Creating Database: ' . mysql_error()); $sql2 = 'CREATE TABLE IF NOT EXISTS `battles` ( `battle_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `winner` bigint(20) unsigned NOT NULL, `loser` bigint(20) unsigned NOT NULL, )'; mysql_query($sql2, $con); $sql3 = 'CREATE TABLE IF NOT EXISTS `images` ( `image_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `score` int(10) unsigned NOT NULL DEFAULT '1500', `wins` int(10) unsigned NOT NULL DEFAULT '0', `losses` int(10) unsigned NOT NULL DEFAULT '0', )'; mysql_query($sql3, $con); if ($handle = opendir('images')) { while (false !== ($file = readdir($handle))) { if($file!='.' && $file!='..') { $images[] = "('".$file."')"; } } closedir($handle); } $sql4 = "INSERT INTO images (filename) VALUES ".implode(',', $images)." "; mysql_query($sql4, $con); mysql_close(); header('location: /'); ?>
  10. adhbvklwqdbviabjiawdnbij
    I did. Nothing happened.
  11. adhbvklwqdbviabjiawdnbij
    The database is not being created. <?php include('mysql.php'); $con = mysql_connect("$host", "$user", "$password"); if (!$con) { die('Fail. - ' . mysql_error()); } $sql1 = 'CREATE DATABASE IF NOT EXISTS `' . $database . '`'; mysql_query($sql1, $con); $sql2 = 'CREATE TABLE IF NOT EXISTS `battles` ( `battle_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `winner` bigint(20) unsigned NOT NULL, `loser` bigint(20) unsigned NOT NULL, )'; mysql_query($sql2, $con); $sql3 = 'CREATE TABLE IF NOT EXISTS `images` ( `image_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `score` int(10) unsigned NOT NULL DEFAULT '1500', `wins` int(10) unsigned NOT NULL DEFAULT '0', `losses` int(10) unsigned NOT NULL DEFAULT '0', )'; mysql_query($sql3, $con); if ($handle = opendir('images')) { while (false !== ($file = readdir($handle))) { if($file!='.' && $file!='..') { $images[] = "('".$file."')"; } } closedir($handle); } $sql4 = "INSERT INTO images (filename) VALUES ".implode(',', $images)." "; mysql_query($sql4, $con); mysql_close(); header('location: /'); ?>
  12. adhbvklwqdbviabjiawdnbij
    This code is not working. Why? <?php include('mysql.php'); $con = mysql_connect("$host", "$user", "$password"); $sql1 = 'CREATE DATABASE IF NOT EXISTS `' . $database . '`'; $sql2 = 'CREATE TABLE IF NOT EXISTS `battles` ( `battle_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `winner` bigint(20) unsigned NOT NULL, `loser` bigint(20) unsigned NOT NULL, )'; $sql3 = 'CREATE TABLE IF NOT EXISTS `images` ( `image_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(255) NOT NULL, `score` int(10) unsigned NOT NULL DEFAULT '1500', `wins` int(10) unsigned NOT NULL DEFAULT '0', `losses` int(10) unsigned NOT NULL DEFAULT '0', )'; if ($handle = opendir('images')) { while (false !== ($file = readdir($handle))) { if($file!='.' && $file!='..') { $images[] = "('".$file."')"; } } closedir($handle); } $sql4 = "INSERT INTO images (filename) VALUES ".implode(',', $images)." "; mysql_query($sql1, $sql2, $sql3, $sql4, $con); mysql_close(); header('location: /'); ?> I would like to "clean" the tables if exist, how can i do this?
×
×
  • 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.