newbie style

nijy

Hey there, im very new to php and have run into a wall! let me first explain what i have set out to create:
a login system using sessions
a booking page which inserts a logged in users data
a viewing page, where the correct logged in user can view there bookings
a edit page to make ammendments to bookings
and a delete page.
I have managed to create a login system reading up a few tutorials online along with the booking page which inserts the data. What i am having problems with is viewing the data, basically what i want it setup to do is -
1. get the users name from the session,
2. get the data from the db according to what the user name is
The data i want to call is in multiple colums and in multiple rows heres how the db is layed out:
+-------------------------------+
¦Booking table ¦
+-------------------------------+
¦ username ¦ day ¦ month ¦ year ¦
¦ jay ¦ 12 ¦ may ¦ 2005 ¦
¦ kim ¦ 17 ¦ may ¦ 2005 ¦
¦ jay ¦ 13 ¦ may ¦ 2005 ¦
+-------------------------------+
basically what i want to do is depending on which username is logged in i want to show all rows in which the username appears, so from the above if the user jay is logged in it should show the day / month / year as
day ¦ month ¦ year
12 may 2005
13 may 2005

and not show the row in which kim appears.
Can somebody please help me! i really have hit a wall and would truly appricieate a hand thank you.

TheDefender

Well, if you are setting up sessions with the username, then I assume you have a session variable called: $_SESSION['username'];

So, setup your query as:

$getbookings = "SELECT * FROM booking_table WHERE username = ".$SESSION['username'];

Precisely, where are you having your troubles? (other than storing your date split up like that, rather than in one date field... It is next to impossible to properly sort by dates when you break it up like that...)

rachel2004

So break this problem down into pieces. First you want to grab the 'username' from your $SESSION variable, right?

session_start();
if (isset($_SESSION['username'])) {
    $user = $_SESSION['username'];
} else {
    echo "<h1>No user is logged in!</h1>";
}

Once you have that, put it into an SQL query:

$sql = "SELECT day, month, year FROM Booking WHERE username = '".$user."'";
$result = mysql_query($sql, $link)
    or die("<p>Couldn't execute query: <strong>".mysql_error."</strong>. Problem with this query: <strong>".$sql."</strong>");
while ($row = mysql_fetch_array($result)) {
    echo "<li />Dates are: ".$row['day']." ".$row['month']." ".$row['year'];
}

nijy

Problem solved thanks to the help of both of you! Thank you very much 😃