query

[chris_s_22]

this is part of my login i want to add a query that checks the registered feild if 1 allow to login anything else to be refused
im guessing it gonna be somthing like this

     $query = "select registered from user where username='$username' limit 1";
     $result = mysql_query($query);

this is my login function how/where do i add the query above obviously i need the proper finished query

function user_login($username, $password)
{
     // Try and get the salt from the database using the username
     $query = "select salt from user where username='$username' limit 1";
     $result = mysql_query($query);
     $user = mysql_fetch_array($result);

 // Using the salt, encrypt the given password to see if it 
 // matches the one in the database
 $encrypted_pass = md5(md5($password).$user['salt']);

 // Try and get the user using the username & encrypted pass
 $query = "select userid, username from user where username='$username' and password='$encrypted_pass'";
 $result = mysql_query($query);
 $user = mysql_fetch_array($result);
 $numrows = mysql_num_rows($result);

 // Now encrypt the data to be stored in the session
 $encrypted_id = md5($user['userid']);
 $encrypted_name = md5($user['username']);

 // Store the data in the session
 $_SESSION['userid'] = $userid;
 $_SESSION['username'] = $username;
 $_SESSION['encrypted_id'] = $encrypted_id;
 $_SESSION['encrypted_name'] = $encrypted_name;


if ($numrows == 1)
{
    return 'Correct';
}
else
{
    return false;
}
}

[Piranha]

Very nice of you to show us your query and your code. But I don't know what you expect us to do with it.

[chris_s_22]

this is my site http://www.pinkangel4u.com/truthdare/
you can login with ussername = "chris" password = "smith"
ive created a table in my database called "game"
the feilds are id, gameno, name, sex, score, finalscore
the form code can be viewed here http://pastebin.com/m21d43d73
that form then asks for creategame.php
code is here http://pastebin.com/m64deb482

this is my function.php page http://pastebin.com/m6b863ba8

what im stuggling is how i can have the data in the table
so i think what i am asking is how do i loop so each player is entered
so effectively for each gameno there will be 15 enteries

id autoincrement
gameno this will have to be the same for each player within the form
name what is entered in namebox 1
sex what is entered in sexbox 1
score default 0
final score what is entered in the bottom of form

this will then be repeated for each player entered

also each form submitted to have a different gameno

also

[djjjozsi]

hy,

in this post these are not full codes, just tips!
And not tested🙂 So please don't say parse errors here 🙂

use array in fieldnames

for example:

Player <input type='text' name='players[]' size='35' value=''>

Why do you need to add a default value to this field? i don't suggest that.

And you have to declare a variable name in the sex dropdown 🙂

<select name="sex[]"><option value='1'>Male</option><option value='2'>Female</option></select><br>

have you heard about for cycle?

<?php
	for($i=0;$i<15;$i=$i+1)
	{
		print "Player ".($i+1) . ": \r";
		print ' <input type="text" name="players[]" size="35" value="">
		<select name="sex[]">
		<option value="1">Male</option>
		<option value="2">Female</option>
		</select><br />';
	}

?>

on your process code you can use this for cycle to get the values,

<?php

/* arrays first element starts from 0 */

for($i=0;$i<15;$i=$i+1)
{

	if(!empty($_POST["players"][$i]))
	{
		print "Player ".($i+1) . ": \r";
		print $_POST["players"][$i] . "<br />";
		print $_POST["sex"][$i]. "<br />";
		print $_POST["finalscore"];
		$errors[]= add_new_sex_game($_POST["game_ID"],$_POST["players"][$i],$_POST["sex"][$i],$_POST["finalscore"]);
		/*and you can call the insert function to the database.
		   AND CALL THE mysql_real_escape_string  function while you insert
		   something into the database table...!

		   you can do that inside a function!
		   And chech all the required values inside that function, and gives back an error
		   message using return...!

		*/
	}
	else
		$errors[]="Player ".($i+1)." is empty...";   //lets create an error array
}

if(isset($errors))
{
	// lets inform the user that some players are missing
	foreach($errors AS $row)
		print "$row <br />";
	die();
}
?>

1 if male, 2 if female , and this value will get into the database.