Greenguy's Board


Go Back   Greenguy's Board > Newbie Questions
Register FAQ Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 2010-03-04, 01:00 PM   #11
DIVAD3
I'm going to the backseat of my car with the woman I love, and I won't be back for TEN MINUTES
 
DIVAD3's Avatar
 
Join Date: Aug 2009
Location: Up-Sate NY !
Posts: 79
Send a message via ICQ to DIVAD3
Ok after reading ALL that you are indicating. I believe I understand completely what I have done wrong. so here is what I have done for changes.

register.php

Quote:
<?php

// dbConfig.php is a file that contains your
// database connection information. This
// tutorial assumes a connection is made from
// this existing file.
include ("dbConfig.php");


//Input vaildation and the dbase code
if ( $_GET["op"] == "reg" )
{
$bInputFlag = false;
foreach ( $_POST as $field )
{
if ($field == "")
{
$bInputFlag = false;
}
else
{
$bInputFlag = true;
}
}
// If we had problems with the input, exit with error
if ($bInputFlag == false)
{
die( "Problem with your registration info. "
."Please go back and try again.");
}

// Fields are clear, add user to database
// Setup query
$q = "INSERT INTO `dbUsers` (`username`,`password`,`email`) "
."VALUES ('".$_POST["username"]."', "
."PASSWORD('".$_POST["password"]."'), "
."'".$_POST["email"]."')";
// Run query
$r = mysql_query($q);

// Make sure query inserted user successfully
if ( !mysql_insert_id() )
{
die("Error: User not added to database.");
}
else
{
// Redirect to thank you page.
Header("Location: register.php?op=thanks");
}
} // end if


//The thank you page
elseif ( $_GET["op"] == "thanks" )
{
echo "<h2>Thanks for registering!</h2>";
}

//The web form for input ability
else
{
echo "<form action=\"?op=reg\" method=\"POST\">\n";
echo "Username: <input name=\"username\" MAXLENGTH=\"16\"><br />\n";
echo "Password: <input type=\"password\" name=\"password\" MAXLENGTH=\"16\"><br

/>\n";
echo "Email Address: <input name=\"email\" MAXLENGTH=\"25\"><br />\n";
echo "<input type=\"submit\">\n";
echo "</form>\n";
}
// EOF
?>
As for the login:
PHP Code:
<?php
session_start
();
// dBase file
include "dbConfig.php";

if (
$_GET["op"] == "login")
 {
 if (!
$_POST["admblogdetailzus"] || !$_POST["OLIVIAlynn616"])
  {
  die(
"You need to provide a username and password.");
  }
 
 
// Create query
 
$q "SELECT * FROM `dbUsers` "
  
."WHERE `username`='".$_POST["admblogdetailzus"]."' "
  
."AND `password`=PASSWORD('".$_POST["OLIVIAlynn616"]."') "
  
."LIMIT 1";
 
// Run query
 
$r mysql_query($q);

 if ( 
$obj = @mysql_fetch_object($r) )
  {
  
// Login good, create session variables
  
$_SESSION["valid_id"] = $obj->id;
  
$_SESSION["valid_user"] = $_POST["username"];
  
$_SESSION["valid_time"] = time();

  
// Redirect to member page
  
Header("Location: members.php");
  }
 else
  {
  
// Login not successful
  
die("Sorry, could not log you in. Wrong login information.");
  }
 }
else
 {
//If all went right the Web form appears and users can log in
 
echo "<form action=\"?op=login\" method=\"POST\">";
 echo 
"Username: <input name=\"username\" size=\"15\"><br />";
 echo 
"Password: <input type=\"password\" name=\"password\" size=\"8\"><br />";
 echo 
"<input type=\"submit\" value=\"Login\">";
 echo 
"</form>";
 }
?>
As for the dbcong.php:

PHP Code:
<?
// Replace the variable values below
// with your specific database information.
$host "localhost";
$user "admblogdetailzus";
$pass "OLIVIAlynn616";
$db   "dbuser";

// This part sets up the connection to the 
// database (so you don't need to reopen the connection
// again on the same page).
$ms mysql_pconnect($host$user$pass);
if ( !
$ms )
{
echo 
"Error connecting to database.\n";
}

// Then you need to make sure the database you want
// is selected.
mysql_select_db($db);
?>

Last edited by DIVAD3; 2010-03-04 at 01:04 PM..
DIVAD3 is offline   Reply With Quote
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:24 AM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc