Can anyone please help.

ricksteruk2005

First off please let me explain im not a advanced user of php and mysql, i can do basic stuff.

Here is what im trying to do.
I have some pages already made for a log in script that querys the database and stores the username in a cookie.
The next bit is where im getting confused, Im trying to make a form that takes their username from the cookie, and then has some check boxes, the check boxes should only allow the database to be updated once, once the user has sent the form with check boxes checked the next time they use it the check boxes should not appear however if the check boxes have not been checked then they should appear the next time they use it. Also the check boxes need to send different values to the database instead of just a 1 or 0.

Finally, once the form is complete i need to make another page that shows the user names and their points (the points are from the values sent to the database from the form)

at the moment i have one database with a table called users which contains ID, Username and password. I was not sure how to set the database up for the other fields that i need.

The form im trying to make is for a charity fishing competiton fo disabled anglers and the form will have a check boxs for the species of the fish caught and points for the fish however each species can only count once.

If anyone could help i would be very greatfull.

YAOMK

Php is stateless, meaning that as soon as the script finishes all the data it used gets flushed. There are two tools at your disposal to remember volatile data across pages: $COOKIE and $SESSION. Alternatively you can pass data through HTML hidden fields. As far as the handling of the check boxes, you can always redefined the boolean variable with say a string representation of the user input:

if($_POST['checkBox1']=1)
{
    $checkBox = 'Grouper';
}
elseif
.........

You could also use a switch statement. Anyways if you have a specific question, make sure to provide the code and we will help you. Good luck.

ricksteruk2005

Thanks for the quick reply.

I only have the one page for when someone is logged in, this is the same page i want to put the form on. At the moment, other than the log in script, i have a blank canvas.


<?php 
// Connects to your Database 
mysql_connect("localhost", "xxxxx", "") or die(mysql_error()); 
mysql_select_db("comm") or die(mysql_error()); 
//Checks if there is a login cookie
if(isset($_COOKIE['ID_my_site']))

//checks cookies to make sure they are logged in 
if(isset($_COOKIE['ID_my_site'])) 
{ 
$username = $_COOKIE['ID_my_site']; 
$pass = $_COOKIE['Key_my_site']; 
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error()); 
while($info = mysql_fetch_array( $check )) 
{ 

//if the cookie has the wrong password, they are taken to the login page 
if ($pass != $info['password']) 
{ header("Location: login.php"); 
} 

//otherwise they are shown the admin area 
else 
{ 
echo "Welcome $username<p>";
echo "Admin Area<p>"; 
echo "Your Content<p>"; 
echo "<a href=logout.php>Logout</a>"; 
} 
} 
} 
else 

//if the cookie does not exist, they are taken to the login screen 
{ 
header("Location: login.php"); 
} 
?>

Is the only code i have at the moment. I didnt want to start making the form until i could work out exactly how it was going to work etc.

YAOMK

Here is a reviewed version of your script:

<?php
// Connects to your Database 
mysql_connect("localhost", "xxxxx", "") or die(mysql_error());
mysql_select_db("comm") or die(mysql_error());
    //checks cookies to make sure they are logged in 
    if ($_COOKIE['ID_my_site'])
    {
        $username = $_COOKIE['ID_my_site'];
        $pass = $_COOKIE['Key_my_site'];
        $check = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());
        while ($info = mysql_fetch_array($check, MYSQL_ASSOC))
        {
            $logInfo[] = $info;
        }
            //if the cookie has the wrong password, they are taken to the login page 
            if ($pass != $logInfo['password']) {
                header("Location: login.php");
            } //otherwise they are shown the admin area 
            else {
                echo "Welcome $username<p>";
                echo "Admin Area<p>";
                echo "Your Content<p>";
                echo "<a href=logout.php>Logout</a>";
                foreach($info as $key)
            }
    } 
    else //if the cookie does not exist, they are taken to the login screen 
    {
        header("Location: login.php");
    }
?>

In regards to your form, I suggest you define a field in the database to indicate whether the user has submitted the complete form or not or just check against those values to make sure the are not null. Then enclose the HTML form in a conditional statement. Also I hope you are using at least MD5 to protect the login data.

ricksteruk2005

ok, so before i start to make a form, you mention about a database table check the form etc.

How would you recommend. I hate to keep asking questions but as i mentioned i can only do very basic php and html.

also what would be the best schema for the database.

The main thing i need to acheieve is that each user can only submit each species once and then a points value is past to the database.

I need to make the user side as simple and easy to use as possible. the users will have varying differences in disabilities.

YAOMK

Typically you'd have a table for login and one for the fish caught. I didn't test this code, but it is a skeleton to give you pointers on how this could be done.

<?php
// Connects to your Database 
mysql_connect("localhost", "xxxxx", "") or die(mysql_error());
mysql_select_db("comm") or die(mysql_error());
    //checks cookies to make sure they are logged in 
    if ($_COOKIE['ID_my_site'])
    {
        $username = $_COOKIE['ID_my_site'];
        $pass = $_COOKIE['Key_my_site'];
        $check = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());
        while ($info = mysql_fetch_array($check, MYSQL_ASSOC))
        {
            $logInfo[] = $info;
        }
        $check = mysql_query("SELECT * FROM fish WHERE username = '$logInfo['username']'") or die(mysql_error());
        while ($info = mysql_fetch_array($check, MYSQL_ASSOC))
        {
            $fishInfo[] = $info;
        }
            //if the cookie has the wrong password, they are taken to the login page 
            if ($pass != $logInfo['password']) {
                header("Location: login.php");
            } //otherwise they are shown the admin area 
            else {
                echo "Welcome $username<p>";
                echo "Admin Area<p>";
                echo "Your Content<p>";
                echo "<a href=logout.php>Logout</a>";
                if(!empty($fishInfo))
                {
                   echo '<form ....>';
                   foreach($fishInfo as $key)
                   {
                       echo '<INPUT TYPE=CHECKBOX NAME="'.$key.'" VALUE="'.$key.'"><br>";
                   }
                   echo '</form>';
                }
            }
    } 
    else //if the cookie does not exist, they are taken to the login screen 
    {
        header("Location: login.php");
    }
?>

ricksteruk2005

Sorry to be a pain, i have tried the code example you put above and i get the following error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp5\htdocs\matchpoolcomp\members.php on line 15

As soon as i have the basic bit working i will be able to figure it out for myself, its just getting it started.

djjjozsi

http://www.phpcode.hu/teszt/your.txt

YAOMK

Remember this is code is not meant to work and do everything you want it to, I'm just presenting you with an idea. That said, to fix the error on line 15, replace with the following:

$check = mysql_query("SELECT * FROM fish WHERE username = '".$logInfo['elementName']."'") or die(mysql_error());