Login Script - PHP Help #3 - Need help creating one

free web hosting
Free Web Hosting > Computers & Tech > Programming > Scripting > PHP

Login Script - PHP Help #3 - Need help creating one

FirefoxRocks
It turns out that the authentication script that I copied from http://www.php-mysql-tutorial.com/user-aut...on/database.php doesn't work even when it is left unchanged. What a crappy piece of code.

Now I am trying to build by own login script from scratch. I already have a little knowledge on how to do this (connecting, echoing, retrieving) but I need some more examples and/or tips. I know what I need and maybe this could help you out:
Note: Green items are fixed.
  1. No duplicate username in MySQL Database
  2. Authorized users only. I have to authorize each user or else a message comes up that says that they have not been authorized yet.
  3. IP address logging. This means logging the IP address when registered and logging the IP address at last logon.
  4. After logon, it all redirects to one page (if certain group).
  5. If the username is in moderator status, it redirects to the Moderator Page. Otherwise, it redirects to the Member page.
  6. A lost password function.

That's all I need right now. For everyone who helps, I will mention your Trap17/Astahost username into the the credits page of the site when it is completed! smile.gif biggrin.gif

 

 

 


Reply

faulty.lee
QUOTE(FirefoxRocks @ Feb 21 2007, 09:00 AM) *
It turns out that the authentication script that I copied from http://www.php-mysql-tutorial.com/user-aut...on/database.php doesn't work even when it is left unchanged. What a crappy piece of code.

Now I am trying to build by own login script from scratch. I already have a little knowledge on how to do this (connecting, echoing, retrieving) but I need some more examples and/or tips. I know what I need and maybe this could help you out:
Note: Green items are fixed.
  1. No duplicate username in MySQL Database
  2. Authorized users only. I have to authorize each user or else a message comes up that says that they have not been authorized yet.
  3. IP address logging. This means logging the IP address when registered and logging the IP address at last logon.
  4. After logon, it all redirects to one page (if certain group).
  5. If the username is in moderator status, it redirects to the Moderator Page. Otherwise, it redirects to the Member page.
  6. A lost password function.
That's all I need right now. For everyone who helps, I will mention your Trap17/Astahost username into the the credits page of the site when it is completed! smile.gif biggrin.gif


I'm assuming you're going to use php as your programming language.

I've just posted some tips regarding this here
http://www.astahost.com/authentication-script-t14988.html

As for ip address, you can always get it from the server's variable
$_SERVER['REMOTE_ADDR']
and
$_SERVER['REMOTE_HOST']

Authorization is just keeping a bit or 2 to indicate the user's status and use the login script to decide what to do with different bit. Same goes or moderator.

Lost password is slightly tougher. You'll need to know how to send email, then you have to choose either let the user key in their own password after they click the "recover password" link on their email, or provide them a temporary password so they can change it later.

Just get the hang of it first. We can come to the detail later, step by step, which is easier to cop with.

Good Luck

 

 

 


Reply

mastercomputers
1) Is your script that you are using based similar off this script you provided in the links?

2)Is there anything different from it that you have done apart from what you're asking for and have already fixed?

3)What version of PHP should this cater for or would you like it to be compatible with PHP3 and up?

I might just improve on this script, keeping it similar to how it's structured it's tables for the database, give me a few hours to have something whipped up.

Cheers,

MC

Reply

FirefoxRocks
1. It can be based off the one given in the previous topic (Authentication Script), but I am going to whip something up anyways (maybe similar, maybe not smile.gif)

2. No, just something that works.

3. I have this information provided by cPanel in Trap17.
QUOTE
Apache version 1.3.37 (Unix)
MySQL version 5.0.27-standard
PostgreSQL version 7.4.13
PHP version 5.1.6

So I guess compatibility for PHP 5+ is okay.

I already have the registration thing setup okay. I used to have a version that works, but somehow it has malfunctioned (OMG BACKUP!!!) and now I have nothing else to modify upon.

Reply

FirefoxRocks
Okay, I have whipped up this code and IT WORKS!!! smile.gif smile.gif biggrin.gif
CODE
<?php
session_start();
$name = $_POST['username'];
$password = $_POST['password'];

$con = mysql_connect("localhost","portal_xkingdom","Yahoo!rocks");
    if(!$con)
        {
        die('Sorry, the XKingdom Center database has encountered an error right now. Please try again later or contact the website administrator. The MySQL error is: ' . mysql_error());
        }
mysql_select_db("portal_xkingdom", $con);

$result = mysql_query("SELECT * FROM users WHERE name='$name' and password = '$password'");
$auth = mysql_query("SELECT auth FROM users");
$rowcheck = mysql_num_rows($result);
if($rowcheck==1)
    {
    /* while($auth_check = mysql_fetch_array($auth))
        {
        if($auth_check==YES)
            { */
            $_SESSION['db_is_logged_in'] = true;
            setcookie("user", "$name", time()+86400);
            header('Location: moderate.php');
            header('(anti-spam-content-type:) text/html;charset=iso-8859-1');
            /* }
        elseif($auth_check==NO)
            {
            $error="You are not authorized as an XKingdom Member yet. Please try again later. If this problem persists for more than 24 hours, please contact the website administrator.";  
            }
        }*/
    }
elseif($rowcheck>1)
{
$error="You have entered an incorrect username/password combination. Please try again. If you forgot your password, contact the website administrator.";
        header('(anti-spam-content-type:) text/html;charset=iso-8859-1');
}
header('(anti-spam-content-type:) text/html;charset=iso-8859-1');
mysql_close();
?>


I have built the code from scratch using the W3Schools help and my previous knowledge from browsing a variety of downloaded PHP scripts which DIDN'T work. I have commented out the authorization part because it isn't working. This means that I have re-met the green requirements wacko.gif Now i just need to meet the other requirements, which number isn't that important. I need some more help with that.

Reply

lonelym
QUOTE
You don't need to make a login page from scratch. That'd be like ... like... working. o_O.


I suggest going to planetsourcecode.com, search ALS (Advance Login System) and download it. extract it to your htdocs, and open install.php. It has a register/login system, email activation system, secure pages for higher members and admins, a message center, news, and even member hiearchy. If you want to make one from scratch, I suggest reading the php files of the ALS and checking to see how it was made. Good luck.

Reply


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

Recent Queries:-
  1. how to create my own login script - 44.82 hr back. (1)
  2. free php login scripts - 137.00 hr back. (1)
  3. php code for password recovery and username - 176.34 hr back. (1)
  4. php mail script met login - 178.16 hr back. (1)
  5. swishmax tutorial - image gallery - 248.63 hr back. (1)
  6. login system showing incorrect username/password - 250.74 hr back. (1)
  7. members area mkdir login script - 489.11 hr back. (1)
Similar Topics

Keywords : login script php creating

  1. Creating A Template Engine - General Advice? (1)
  2. Need Help With A PHP - MySQL Registration Script - Wont INSERT into the database (13)
    hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE CODE #
    register1.php # common include file to MySQL include("DB.PHP"); $Username=$_POST ; $Password=$_POST
    ; $Name=$_POST ; $Last=$_POST ; $Sex=$_POST ; $Month=$_POST ; $Day=$_POST ; $Year=$_POST ;
    $Adresse=$_POST ; $City=$_POST ; $State=$_POST ; $Zipcode=$_POST ; $Country=$_POST ; $Phone=$_POST ;
    $Email=$_POST ; $Father_Name=$_POST ; $Mother_Name=$_POST ; $Parent_Phone=$_POST ;
    $Parent_Email=$_POST ; $Level=$_POST ; $Academic=$_POST ; $Image_Link=$_POST ; $sql9="INSERT INTO
    U...
  3. Myspacetv Download Php Script Help - (6)
    I was trying to make a php script that can view myspace videos with jw flv player and wont to know
    how to do so if i put in
    "http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=38105626" it show the video
    "http://cache01-videos02.myspacecdn.com/11/vid_e382054c036835500bacfef1ebb5157e.flv(its the flv
    video file from myspacetv), I cant see the similarity with the links please help, thanks for viewing
    this topic /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />...
  4. Php Login Script - (0)
    login script click the link to get your free php login script installer just follow the
    instuctions the exe gives you and it will give you the script just place the code in the sever and
    open index.html and follow on from there. what it has: it has reg page, login protection code ect.
    it is simple to use and i think quite fun but im BORN TO BE WEIRD,you will need at least one working
    mysql data base /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif"
    /> hope you enjoy it. iknow i did from the alexmedia crew...
  5. Script Request - script request (2)
    another script request i am looking for a file manger tutorial with edit delete search upload move
    copy and a WYSIWYG(What You See Is What You Get) editer like on on freewebs.com and css editor plz
    help! i need on badly vmkrightpoint Edit"i keep search google and msn and yahoo i can't find
    on!! lol"...
  6. Php Script To Download File From Another Site - (9)
    hi i need a php or java script code for downloading files from other sites to my site for example:
    http://download.com/file.zip to http://mysite.com/file.zip thanks...
  7. Permission Denied In Creating A Directory - mkdir() (6)
    QUOTE Warning: mkdir(/home/whistle/public_html/see/seeto): Permission denied in
    /home/whistle/public_html/see/config.php on line 56 My web hosting is on the astahost. The
    absolute path of my php script is "(/home/whistle/public_html/see". When I try to create a directory
    named "seeto", the error message about permission denied is displayed. The same script I tried on
    another web hosting server "Lycos", it works perfectly. Can anyone tell me what is wrong with it?
    Or anything I should notice more? Thanks. CODE if (mkdir("/home/whistle/public_html/see/seeto"...
  8. How Do I Create And Write To Files? - creating, writing, deleting files (4)
    Hi, Can someone please tell me how to create files and write to them in PHP. I just want to create
    a simple file containing text, and then be able to read it or update it. Thanks Alfie...
  9. Make A Script Run Even If No User Is Online - (6)
    Hey! Is there any way to make a script run, even if no user is online. Because at the moment, my
    scripts run, only when a user is online. And another thing: How can i make the following: (this is
    just an example) mysql_query"SELECT maxhp FROM users WHERE username = 'allusers'"; How can I
    select all users maxhp, in the same query? Thanks //Feelay...
  10. Writing And Testing My Own Login Script [solved] - (20)
    i have this error QUOTE Warning: session_start() : Cannot send session cache limiter - headers
    already sent (output started at /home/eggie/public_html/race.php:2) in
    /home/eggie/public_html/race.php on line 5 in every page i have with session start...what's
    the problem?? CODE Race include("style.css"); include("config.php"); session_start();
    if(!session_is_registered(myusername)){ echo 'Your Session has Expired!'; exit;} //If you
    click race... if ($_GET =='race') { $asa=$_POST ; if(!isset($asa)) { echo 'You
    didn\'t select an...
  11. Login Script - (8)
    I have another question--- i downloaded script of a game and it worked until my server changed to
    newer version of php after which it didn't work... the most probable reason is that globals are
    not enabled... now i need someone who can tell me what to put instead of what to make it work...
    this is my login.php script CODE if (!$user || !$pass) {     include("head.php");     print
    "Please fill out all fields.";     include("foot.php");     exit; } include("head.php"); $password =
    md5($pass); $password2 = md5($password); $password3 = md5($password2); $password4 =...
  12. Free Forum Hosting Type Script Help! - Free forum hosting type script help!!! (2)
    i want to make something like http://invisionfree.com/ that makes an dir with your phpbb 3 forum
    in it with an admin CP plz help i really want to make something like it!! i was thinking of coding
    my own with file handling but i'm not good at some of it like "when u click submit to register
    a forums it will move the phpbb3 file that leads to the users dir then it will rename the dir to
    your username so like my.site.com/username it might work" with the admin username and pass and
    admin's email it will open the config.php then edit all the data but it will ke...
  13. What Would Make A Good Registration Script? - (4)
    I see newbies all the time looking for either a login script or after a little querying you find
    they really would like to have a registration script. The first thing for such a script for a
    members area would of course be a form and being kind of old fashioned I still like to format my
    forms with a table but I do use inline CSS to make it a little nicer. I never did like forms that
    had an asterick * by a field and then a Note: Fields marked with * are required. So what I do
    instead is add a background color to those areas and then use a CSS background color statin...
  14. Warning: Mysql_result(): Supplied Argument Is Not A Valid Mysql Result Resource In ... - This Is for My attack Script. (4)
    Hey. I am making a "Version 2.0" For my attack script, but I can't make it work. This is the
    error I am gettin: Warning: mysql_result(): supplied argument is not a valid MySQL result resource
    in And here is the code: CODE $dbQueryHealth = mysql_query("SELECT temphealth FROM
    characters WHERE user =". $_POST ."");           $currentHealth = mysql_result($dbQueryHealth, 0);
            $dbQueryExp = mysql_query("SELECT exp FROM characters WHERE user = ".$_POST ."");  
            $currentExp = mysql_result($dbQueryExp, 0); I have checked the PHP Manual,...
  15. Password Recovery Script - (6)
    While trying to make password recovery script for "bhupinunder" i run into a problem... i made this:
    CODE $dbh = mysql_connect('localhost','jaskaran_gc','gc') or die
    ("Cannot Connect: " . mysql_error()); mysql_select_db('jaskaran_gc',$dbh); ?> ";?>
    if ($recover=answer) print"$email"; ?> and it doesn't print anything...but if i put it
    like this CODE $dbh = mysql_connect('localhost','jaskaran_gc','gc') or
    die ("Cannot Connect: " . mysql_error()); mysql_select_db('jaskaran_gc',$dbh...
  16. SQL Doesn't Connect In PHP Script - I made some code updates now the script is broken. (19)
    i have created a website and it is not working properly... i have had a website on sphosting.com and
    everything worked fine till i got some errors(i got the errors because of the crappy host)...now the
    fun part starts...they said they solved the problem but i got another one..i said them to repair it
    again and they did...now i tried to login but as i entered the info it said the info isn't
    correct...i checked the SQL and everything seemed fine..i tried again and again the error came...i
    tried than to register,entered ALL info and when this was suppose to come out "Yo...
  17. Automated Product Suggestion Script - Compare user lists and suggest related items based on pattern matching (2)
    I recently got an idea for a project and one of the features I wanted the project to have was an
    automated suggestion service. If anyone has been to Amazon, it would work much like their
    recommended product feature. What I want to do is take several users lists of whatever but for this
    example, I'll use web links like from the browser history. I would want to suggest links to a
    user based on common links in many other users lists. User A: Amazon, Ebay, Excite, Google, Yahoo,
    MySpace, Walmart User B: Amazon, Ebay, Google, Yahoo, You Tube, MySpace, CVS User C: Amazo...
  18. Php Script Help - help with scripting of php (1)
    Ok first a little back story of what happened and why I am asking for help. I have been playing text
    based rpgs and found that I really like them. Well I have also found that most programers don't
    want to listen to their clients in the sugestion box and when u make a content sughesstion they get
    rude or make fun of your idea. So I decided I would sart my own and make it where the users had say
    so in added content. Not saying all sugestions will get added but I will not make fun or get mad at
    them. Any who when I bought the script I was under the impression it was fu...
  19. Run A Script When Expires A Session - (6)
    For example, when a user logins to a page -with a login form- and after validating and verifying
    it's credentials i store some information related to this user in session variables and a table
    with his state -connected- is updated, then i use it in other pages, etc. When this user logouts
    -by clicking a logout link- i release -unregister, destroy, etc- all the session variables stored
    and the same table is updated with his state -disconnected-. All of this funcionality works very
    well, the problem comes when the user do not click on the logout link and the session ...
  20. Something Wrong With This Script? - Unexpected T_SRING (9)
    Here is the code that I have: CODE $con = mysql_connect("localhost","user","password"); if
    (!$con)   {die(' Could not connect: ' . mysql_error() . ' ');}
    mysql_select_db("database", $con); $ip=$_SERVER ; echo "Adding MXP info..."; mysql_query (INSERT
    INTO mxp (date, user, victim, turns, side, gold, lost, killed, mxp, points_b, points_a, type, power,
    ip) VALUES ('$_POST ','$_POST ','$_POST ','$_POST ','$_POST
    ','$_POST ','$_POST ','$_POST ','$_POST ','$_POST
    ','$_POST ...
  21. Automatic/remote Php Script Execution - (9)
    Hi, I was wondering, is it possible to execute a PHP script when a user isn't on the page with
    it? Say for example, have it so that a script checks that if a certain time has passed since a user
    was last active, it logs them off? So that if they've closed the window, it doesn't keep
    them marked as logged in. Also, is there any way, with PHP to alert a user when something changes,
    as soon as it happens? Say that if they recieve a new message, a box pops up telling them? You could
    do this with Ajax I suppose, but (correct me if I'm wrong) continually runni...
  22. Trainable Anti-spam Filter Script - Any clues howto write one/get one ? (3)
    Hi all, Does anybody have ideas about writing trainable anti-spam mail filters - that you can
    add onto any web-mail script ? Looking for something written in perl/php that'll allow me to
    just check the checkboxes beside spam mails and click any button (say, "mark as spam") and the
    script studies the mail headers and creates its own list of originating spammer domains/ips & blocks
    out mails from 'em ? Thanks /smile.gif' border='0' style='vertical-align:middle'
    alt='smile.gif' /> ...
  23. Please Help (php Join Script) - (5)
    Ok as you all know by now I have been working on a php based game
    to help me learn php. It has been going great and it is almost done. I got some very good help on is
    sues here and along with sites like php.net. However I am stuck and can not find a solution to a
    problem anywere. My Problem: I want users to join but I don't want some charicters to be in
    there name (example I dont want Disallowed Charicters: , ', " I would array like: CODE
    $string = array( , ', "); This for some reason does not work for. CODE if(strpos($name,
    $string)){ //error s...
  24. Authentication Script - PHP Help #2 -- I need help tweaking it - it won't work (1)
    Okay, my first issue about the MySQL echo problem has been solved, thank you to those who helped.
    /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Now I am focusing
    on the login portion of my site, and I have this so far: CODE // we must never forget to start
    the session session_start(); $errorMessage = ''; if (isset($_POST ) && isset($_POST ))
        {    $username = $_POST ;    $password = $_POST ; //Connect to database $con =
    mysql_connect("localhost","myDatabaseUsername","myDatabasePassword"); if (!$con)   {   die('Co...
  25. Online Multiplayer Chess Script - Online multiplayer chess script (2)
    Do you have any script for this?or where can i find this script. I wait your replies. ok....
  26. Automated File Structure Creation Script - As Requested By Mark420 (3)
    While chatting with Mark420 today on the shoutbox, he mentioned that he was looking for a script to
    create his entire folder structure with just a click of a button. For example, he wanted the
    following folders created in his root folder by just clicking submit. /images /images/thumbs
    /images/icons /css /javascripts /content /content/articles /content/tutorials Presumably this
    would be used for some type of installation system or other quick server setup situation. Anyhow
    here is what I threw together for him: /* ********************************************...
  27. How To Delete File Using PHP Shell Script - (3)
    i have this problem regarding file access seems that my admin host or the server system itself have
    locked up the acces to create new file, delete a file.. change file permissions and such controls
    to file.. someone told me to use php shell script.. can you help me out here? ******** i just
    need to find out how to use php shell script and add it to my php scripts to delete a file.. thanks...
  28. Installed A PR Checker Script - But Not Working Correctly - (6)
    I'm new to PHP and still have much to learn. I came across a free script to check google PR.
    You place a file called pagerank.php and then have an includes. So I did this: CODE ?>
    Then I have my HTML (the page header and so forth), and added a form where they can input their URL.
    The form action is CODE " method="post" name="checkpr" id="checkpr"> First of all ... I
    seem to be missing something completely basic. My page isn't displaying at ALL as I expected.
    No graphic header and no form. It's actually showing all my HTML code in...
  29. Auto Responder Script - (6)
    Anyone knows a free autoresponder script (preferably PHP) that enables to send a series of emails
    according to a specific time interval? If customizable fields can be included, it's better. And
    also a tracking script which lets me track the click throughs of links like .com/tracking-word"
    target="_blank">http://www. .com/tracking-word and a handy Tell-A-Friend script. I really
    appreciate your input. Thank you....
  30. Blog Script? - (5)
    Hi, Can someone help me to find an easy and free Blogscript? I'm also looking for great
    templateheaders special for blogs. It doesn't matter if it is in php, cgi or another
    programming, as long as it is free: ) Thanx!...



Looking for login, script, php, 3, creating






*SIMILAR VIDEOS*
Searching Video's for login, script, php, 3, creating
Creating A
Template
Engine
General
Advice?
Need Help
With A PHP -
MySQL
Registration
Script Wont
INSERT into
the database
Myspacetv
Download Php
Script Help
Php Login
Script
Script
Request
script
request
Php Script
To Download
File From
Another Site
Permission
Denied In
Creating A
Directory
mkdir()
How Do I
Create And
Write To
Files?
creating,
writing,
deleting
files
Make A
Script Run
Even If No
User Is
Online
Writing And
Testing My
Own Login
Script
[solved]
Login Script
Free Forum
Hosting Type
Script
Help!
Free forum
hosting type
script
help!
3;!
What Would
Make A Good
Registration
Script?
Warning:
Mysql_result
(): Supplied
Argument Is
Not A Valid
Mysql Result
Resource In
... This Is
for My
attack
Script.
Password
Recovery
Script
SQL
Doesn't
Connect In
PHP Script I
made some
code updates
now the
script is
broken.
Automated
Product
Suggestion
Script
Compare user
lists and
suggest
related
items based
on pattern
matching
Php Script
Help help
with
scripting of
php
Run A Script
When Expires
A Session
Something
Wrong With
This Script?
Unexpected
T_SRING
Automatic/re
mote Php
Script
Execution
Trainable
Anti-spam
Filter
Script Any
clues howto
write
one/get one
?
Please Help
(php Join
Script)
Authenticati
on Script
PHP Help #2
-- I need
help
tweaking it
- it
won't
work
Online
Multiplayer
Chess Script
Online
multiplayer
chess script
Automated
File
Structure
Creation
Script As
Requested By
Mark420
How To
Delete File
Using PHP
Shell Script
Installed A
PR Checker
Script - But
Not Working
Correctly
Auto
Responder
Script
Blog Script?
advertisement




Login Script - PHP Help #3 - Need help creating one