MySQL database details

Discussion in 'Programming' started by bersude2, Feb 21, 2009.

0
  1. #1
    I'm thinking of the best way to word this so it makes sense to you...

    A user inputs their info into a form that submits it to a MySQL database table (which works fine)

    Now, I want to display that users info on the next page, something like "Welcome FirstName LastName"...

    I created the database details page to do this and by default it displays column 0 in the MySQL table. I want it to display the most recent entry, which will be that specific user - you follow?

    Do I need to create a session (which I don't know how to do) with the most recent entry?

    Thanks for your input.
     
    bersude2, Feb 21, 2009 IP
  2. readytoblog

    readytoblog Peon

    Messages:
    111
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Suppose 1nano second later, I also sign up, so the previous user will be greeted with my name, if we follow your logic.

    if you are programming in php, have a look at this code:
    free2code.net/tutorials/programming/php/4/phplogin.php
     
    readytoblog, Feb 22, 2009 IP
  3. kisanka

    kisanka Member

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    yes you do need to create a session.

    http://www.php.net/session
    Code (markup):
     
    kisanka, Feb 22, 2009 IP
  4. NFreak

    NFreak Peon

    Messages:
    38
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    A session is not completely necessary. After they submit their data, add it to the database along with their IP address, that way you will prevent the issue that readytoblog brought up.

    When you grab the info on the next page, just do a simple

    SELECT first, last FROM users WHERE ip='$_SERVER[REMOTE_ADDR]'

    Sessions would definitely be the best way to do it, but it isn't necessary. Also, sessions are fairly easy. Just add "session_start();" as your first line of code on all pages that you are going to use them on, and session variables could be set like

    $_SESSION[first]=$_GET[first];

    Basically works just like all other variables, except they can be accessed from all pages with that simple function call at the top.
     
    NFreak, Feb 22, 2009 IP