Implementation of a sign-up (not sign-in) form in MySQL

I did what you suggested, placing the third variable within its own tags. The good news is that by doing that the error message and the additional login disappeared. The bad news is that it didn't do anything beyond that.

In the listing page (I only have the login page and the listing page so far), the Username comes up by inserting:

<?php
session_start();
echo $_SESSION['MM_Username'];
?>

so I know that the right user is logged in. However, when I also add

<?php
session_start();
echo $_SESSION['MM_Family'];
?>

the family ID doesn't show up.

Besides, assuming I am managed to put the Family ID in the SESSION, how do I retrieve it?

Also, Crash, do you know of any way that one could chat with an expert in real time? I feel like I'm inches away from solving this problem, and if I could run a couple of trial-and-error approaches with someone guiding me, it'd be taken care of in a matter of minutes no doubt.

Please let me know your thoughts.

Thanks.

You can set the Session ID in your login page, as you know they will be
hitting that (whereas if you set it on another page you really might not
know which page they will be accessing).

You should then be able to filter all recordsets by the
$_SEssion['FamilyID'] var.

I saw you posted above, assumign same problem will reply there as well.

jon

"Elfkonig" <webforumsuser@macromedia.com> wrote in message
news:efkgva$caf$1@forums.macromedia.com...
>I have figured out how to filter, but where do I set the
>$_SESSION['FamilyID']? In the login page, or in the listing (results by
>Family) page)?
>
> Let me know if seeing the code would help. Thanks.

I have figured out how to filter, but where do I set the $_SESSION['FamilyID']? In the login page, or in the listing (results by Family) page)?

Let me know if seeing the code would help. Thanks.

I am afraid I have a long way to go still to get a handle on code.

I inserted the echo $_SESSION['MM_Username'] code that you suggested and indeed, my record listing page shows the name of the username that logged in.

After that, I simply don't know how to filter recordsets. I've been looking around but have found no clear instructions. I've used a number of self-teaching guides, such as PHP for DW 8 and others, but there's no mention of filtering.

Any hints?

I am trying to implement your suggestion, which makes total sense. I'll let you know the results.

Once the parent is logged in, you should have a value for their family_id.

Search the student tables for the corresponding family_id an list the
members of that family currently enrolled in classes.


"Elfkonig" <webforumsuser@macromedia.com> wrote in message
news:efei4e$ofn$1@forums.macromedia.com...
> Hi,
>
> I am a newbie to PHP/MySQL. However, I have successfully created several
> databases and connected to them. I've been able to create users and
> sign-in
> pages (admin sections) to add, edit and delete items to the database.
>
> However, I've hit a wall with a project I'm working on.
>
> The goal is to create a system where people can sign their kids up for a
> class. So, I have created several tables for that purpose. A "family"
> table for
> the parents, a "student" table for the kids, a "class" table for the each
> class
> and then a user type" table to determine the level of access that each
> user
> will have.
>
> Each family has a unique family_id and each student has a unique
> student_id.
> Each student_id record has a family_id collumn as a foreign key, since
> each
> family can have one or more kids.
>
> How do I create a system where parents can log in and ONLY see whether
> their
> own kids are signed up or not for a particular class and add them to it if
> they
> are not?
>
> I would appreciate any help.
>