Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143
This is the forum to discuss the Wrox book Beginning PHP 6, Apache, MySQL 6 Web Development by Timothy Boronczyk, Elizabeth Naramore, Jason Gerner, Yann Le Scouarnec, Jeremy Stolz; ISBN: 9780470391143
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP 6, Apache, MySQL 6 Web Development ISBN: 9780470391143 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 14th, 2012, 11:55 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Question <select><option> Date of Birth</option></select>

any1 familiar with the selection option


database code

Code:
<?php
$db= mysql_connect('localhost', 'bp6am', 'bp6ampass') or
	die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exits
$query = 'CREATE DATABASE IF NOT EXISTS namelist';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created databse is the active one
mysql_select_db('namelist', $db) or die(mysql_error($db));

// create the user table
$query = 'CREATE TABLE IF NOT EXISTS palgo_user (
		user_id			INTEGER			NOT NULL AUTO_INCREMENT,
		username		VARCHAR(20)		NOT NULL,
		password		CHAR(41)		NOT NULL,
		
		PRIMARY KEY (user_id)
	)
	ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

// create the user infomation table
$query = 'CREATE TABLE IF NOT EXISTS palgo_info (
		user_id 		INTEGER			NOT NULL,
		first_name		VARCHAR(20) 	NOT NULL,
		last_name		VARCHAR(20)		NOT NULL,
		email			VARCHAR(50)		NOT NULL,
		country			VARCHAR(25),
		************				VARCHAR(20),
		d_o_b			CHAR(20),
		
		
		FOREIGN KEY (user_id) REFERENCES palgo_info(user_id)	
		)
		ENGINE=MyISAM';
mysql_query($query,	$db) or die (mysql_error($db));

// populate the user table

$query = 'INSERT IGNORE INTO palgo_user
		(user_id, username, password)
	VALUES
		(1, "john",  PASSWORD("secret")),
		(2, "sally", PASSWORD("password"))';
mysql_query($query, $db) or die (mysql_error($db));

// populate the user infomation table
$query = 'INSERT IGNORE INTO palgo_info
		(user_id, first_name, last_name, email, ************, d_o_b, country)
	VALUES
		(1, "john", "Doe", "jdoe@example.com", NULL, NULL, NULL), 
		(2, "sally", "Smith", "ssmith@example.com", NULL, NULL, NULL)';
mysql_query($query, $db) or die (mysql_error($db));

echo 'Success!';					 		
?>

code for form:-

Code:
<?php
session_start();


$db = mysql_connect('localhost', 'bp6am', 'bp6ampass') or
	die ('Unable to connect. Check your parameters.');
mysql_select_db('palgo', $db) or die (mysql_error($db));

$country_list = array('kk', 'yy', 'mm');
$************_list = array('male', 'female');
$d_o_b_list = array('wats to b added here ? ');
 
	
// filter incoming values
$username = (isset($_POST['username'])) ? trim($_POST['username']) : '';
$password = (isset($_POST['password'])) ? $_POST['password'] : '';
$first_name = (isset($_POST['first_name'])) ? trim($_POST['first_name']) : '';
$last_name = (isset($_POST['last_name'])) ? trim($_POST['last_name']) : '';
$email = (isset($_POST['email'])) ? trim($_POST['email']) : '';
$country = (isset($_POST['country']) && is_array($_POST['country'])) ? $_POST['country'] : array();
$************ = (isset($_POST['************']) && is_array($_POST['************'])) ? $_POST['************'] : array();
$d_o_b = (isset($_POST['d_o_b']) && is_array($_POST['d_o_b'])) ? $_POST['d_o_b'] : array();


if (isset($_POST['submit']) && $_POST['submit'] == 'Register') {

	$errors = array();
	
	// make sure manditory fields have been entered
	if (empty($username)) {
		$errors[] = 'Username cannot be blank.';
		}
		
	// check if username already is registered
	$query = 'SELECT username FROM mem_info WHERE username = "' . 
		$username . '"';
	$result = mysql_query($query, $db) or die (mysql_error());
	if (mysql_num_rows($result) > 0) {
		$errors[] = 'Username ' . $username . ' is already registered.';
		$username = '';
	// check if email already is registered	
	$query = 'SELECT username FROM palgo_info WHERE username = "' . 
		$email . '"';
	$result = mysql_query($query, $db) or die (mysql_error());
	if (mysql_num_rows($result) > 0) {
		$errors[] = 'Username ' . $email . ' is already registered.';
		$email = '';
	}
	mysql_free_result($result);
	
	if (empty($password)) {
		$errors[] = 'Password cannot be blank.';
	}
	if (empty($first_name)) {
		$errors[] = 'First name cannot be blank.';		
	}
	if (empty($last_name)) {
		$errors[] = 'Last name cannot be blank.';
	}
	if (empty($email)) {
		$errors[] = 'Email address cannot be blank.';
	}
	if (empty($country)) {
		$errors[] = 'Email address cannot be blank.';
	}
	if (empty($d_o_b)) {
		$errors[] = 'Email address cannot be blank.';
	}
	if (empty($************)) {
		$errors[] = 'Email address cannot be blank.';
	}	
	if (count($errors) > 0) {
		echo '<p><strong style="color:#FF000;">Unable to process your ' .
			'registration.</strong></p>';
		echo '<p>Please fix the following:</p>';
		echo '<ul>';
		foreach ($errors as $error) {
			echo '<li>' . $error . '</li>';
		}
		echo '</ul>';
	} else {
		// No errors so enter the information into the database.
		
		$query = 'INSERT INTO palgo_user
				(user_id, username, password)
			VALUES
				(NULL, "' . mysql_real_escape_string($username, $db) . '", ' .
				 'PASSWORD("' . mysql_real_escape_string($password,   
				 	$db) . '"))';	
	$result = mysql_query($query, $db) or die(mysql_error());
		
	$user_id = mysql_insert_id($db);
	
	$query = 'INSERT INTO palgo_info
			(user_id, first_name, last_name, email, country, ************, d_o_b)
		VALUES
			(' . $user_id . ', ' .
			'"' . mysql_real_escape_string($first_name, $db) . '", ' .
			'"' . mysql_real_escape_string($last_name, $db) . '", ' .
			'"' . mysql_real_escape_string($email, $db) . '", ' .
			'"' . mysql_real_escape_string(join(', ', $country), $db)  . '")';
			'"' . mysql_real_escape_string(join(', ', $************), $db)  . '")';
			'"' . mysql_real_escape_string(join(', ', $d_o_b), $db)  . '")';
			
	$result = mysql_query($query, $db) or die(mysql_error());
	
	$_SESSION['logged'] = 1;
	$_SESSION['username'] = $username;
	
	header('Refresh: 5; URL=login.php');						
?>

<?php
		die();
	}
}
?>		


<head>


<title>Registration</title>
</head>

<body>

	<form action="sign_up.php" method="post">
 	 <table>
	  <tr>
	   <td ><label for="first_name">First Name:</label></td>
	   <br />
	     <td><input type="text" name="text" maxlength="20" size="20"value="<?php echo $first_name; ?>" /></td>
	  </tr>
	  <tr>
	   <td><label for="last_name">Last Name:</label></td>
	     <td><input type="text" name="text" maxlength="20" size="20"  value="<?php echo $last_name; ?>"/></td>
	  </tr>
	  <tr>
	   <td ><label for="username">User Name:</label></td>
	     <td><input type="text" name="text" maxlength="20" size="20"  value="<?php echo $username; ?>"/></td>
		
	  </tr>
	  <tr>
	   <td ><label for="email">Email:</label></td>
	     <td><input type="text" name="text" maxlength="20" size="20"  value="<?php echo $email; ?>"/></td>
	  </tr>
	  <tr>
	   <td><label for="password">Password:</label></td>
	     <td><input type="password" name="password" maxlength="20"  value="<?php echo $password; ?>"/></td>
	  </tr>
	  <tr>
	   <td ><label for="counrty">Counrty:</label></td>
	     <td><select name="counrty[]" id="counrty" >
  <option>--select country--</option>
  <option value="yy">YY</option>
<option value="kk">KK</option>
<option value="mm">MM</option>
  
</select></td>
	  </tr>
	  <tr>
	   <td ><label for="************">************:</label></td>
	     <td><select name="************[]" id="************"  >
  <option>Select</option>
  <option value="male">Male</option>
  <option value="female">Female</option>

</select></td>
		
	  </tr>
	  <tr>
	   <td ><label for="d_o_b">Date of birth:</label></td>
	     <td><select name="d_o_b[]" id="d_o_b" >
  <option >Month</option>
  <option value="jan">January</option>
  <option value="feb">February</option>
  <option value="mar">March</option>
  
 
</select>

<select name="d_o_b[]" id="d_o_b" >
  <option>Day</option>
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
 

</select>

<select name="d_o_b[]" id="d_o_b" >
  <option>Year</option>
  <option value="1997">1997</option>
  <option value="1996">1996</option>
  <option value="1995">1995</option>

</select>
</td>
	  </tr>
	  
	   <tr>
	   <td><input type="reset" value="reset" /></td>
	     <td><input type="submit" name="" value="Register"/></td>
	  </tr>
	 </table>
	</form>

</div>
</body>
</html>
Reply With Quote
  #2 (permalink)  
Old March 14th, 2012, 12:26 PM
Friend of Wrox
Points: 651, Level: 9
Points: 651, Level: 9 Points: 651, Level: 9 Points: 651, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Location: North East UK
Posts: 125
Thanks: 0
Thanked 24 Times in 24 Posts
Default

Greetings,

As you failed to specify exactly what the problem is I am guessing it's a problem with the date of birth selects... you should name them;

dob_year
dob_month
dob_day

as each select will only return a single value there is no need to use the array (d_o_b[]) you are using and the fact that you have 3 items with the same name would mean you only get the value of the last one on the form, which would be an array.

Like so;
Code:
<select name="dob_month" id="dob_month" >
  <option value="0">Month</option>
  <option value="jan">January</option>
  <option value="feb">February</option>
  <option value="mar">March</option>
</select>

<select name="dob_day" id="dob_day" >
  <option value="0">Day</option>
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
</select>

<select name="dob_year" id="dob_year" >
  <option value="0">Year</option>
  <option value="1997">1997</option>
  <option value="1996">1996</option>
  <option value="1995">1995</option>
</select>
You would then check each item to see if it's not zero (nothing selected) and process as normal, if the value passed is zero then display a message informing the user to select something.

Last edited by UseLess; March 14th, 2012 at 12:29 PM..
Reply With Quote
  #3 (permalink)  
Old March 15th, 2012, 12:18 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Default

hi @useless

thankz for the reply, i'm sorry that i din't specify in da earlier post
can u plz check this line for me

Code:
$country_list = array('kk', 'yy', 'mm');
$s*x_list = array('male', 'female');
$dob_list = array('wats to b added here ? ');
and i'm getting error in dis line for the 'country'
Code:
$country = (isset($_POST['country']) && is_array($_POST['country'])) ? $_POST['country'] : array();
$s*x = (isset($_POST['s*x]) && is_array($_POST['s*x'])) ? $_POST['s*x'] : array();
$d_o_b = (isset($_POST['dob']) && is_array($_POST['dob'])) ? $_POST['dob'] : array();
weather this line will work ?
Code:
<select name="************[]" id="************"  >
  <option value="0">Select</option>
  <option value="male">Male</option>
  <option value="female">Female</option>
Reply With Quote
  #4 (permalink)  
Old March 15th, 2012, 04:19 AM
Friend of Wrox
Points: 651, Level: 9
Points: 651, Level: 9 Points: 651, Level: 9 Points: 651, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Location: North East UK
Posts: 125
Thanks: 0
Thanked 24 Times in 24 Posts
Default

Greetings,

You do not need to use an array, so this (name changed due to the word filter);
Code:
<select name="gender[]" id="gender"  >
  <option value="0">Select</option>
  <option value="male">Male</option>
  <option value="female">Female</option>
</select>
could be written as;
Code:
<select name="gender" id="gender"  >
  <option value="0">Select</option>
  <option value="male">Male</option>
  <option value="female">Female</option>
</select>
as you will only ever expect a single value to be returned.

You would use an array if you expect more than one item, for example
Code:
<select name="numbers[]" id="numbers" multiple="multiple" size="10">
  <option value="0">Select 6 numbers</option>
  <option value="1">One</option>
  <option value="2">Two</option>
  <option value="3">Three</option>
  <option value="4">Four</option>
  <option value="5">Five</option>
In the above example you can select multiple items and when submitted it would be an array with those items in it.
Reply With Quote
  #5 (permalink)  
Old March 15th, 2012, 11:35 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Post

i have made the change

i fill the form n submit

it does nt show any errors but
no enrty are made into the database
or directed to the login page...

i dont know where to start agian
seem from beginning will do best...

@useless , can u update the whole code when u are free ?

thnks to u.
Reply With Quote
  #6 (permalink)  
Old March 15th, 2012, 02:45 PM
Friend of Wrox
Points: 651, Level: 9
Points: 651, Level: 9 Points: 651, Level: 9 Points: 651, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Location: North East UK
Posts: 125
Thanks: 0
Thanked 24 Times in 24 Posts
Default

Greetings,

So have you corrected all the other errors in the 2nd file you posted above?

If not then no wonder it's not working.

Errors I found in no particular order:

- you have 2 ) and the end of a query when there should be 1
- you are missing a closing }
- you are selecting the username from the db but you're doing it based on the users email
- you are using an array for the country when there is no need to

In the file below the db connection has been commented out as I don't have my db server on at the moment, and I have added a debug flag, currently set to true, so the POST array can be output to see the values passed from the form.

There are still some things to fix, which I'll leave for you to solve after all if I do it all for you then you won't learn anything ;)

PHP Code:
<?php

// enable debug mode?
$debug true;

/*
session_start();

$db= mysql_connect('localhost', 'bp6am', 'bp6ampass')
if( !$db )
{
    die ('Unable to connect. Check your connection parameters.');
}

// make sure our databse is the active one
if( !mysql_select_db('namelist', $db) )
{
    die('Error Selecting db: ' . mysql_error($db));
}
*/

$country_list = array('kk''yy''mm');
$gender_list = array('male''female');
$dob_list = array('January''February''March''April''May''June''July''August''September''October''November''December');
 
if( 
$debug & (isset($_POST['submit']) && ($_POST['submit'] == 'Register')) )
{
    echo 
'<pre>';
    
print_r($_POST);
    echo 
'</pre>';
    
    unset(
$_POST['submit']);
}
    
// filter incoming values
$username = (isset($_POST['username'])) ? trim($_POST['username']) : '';
$password = (isset($_POST['password'])) ? $_POST['password'] : '';
$first_name = (isset($_POST['first_name'])) ? trim($_POST['first_name']) : '';
$last_name = (isset($_POST['last_name'])) ? trim($_POST['last_name']) : '';
$email = (isset($_POST['email'])) ? trim($_POST['email']) : '';

$country = (isset($_POST['country']) && !empty($_POST['country'])) ? $_POST['country'] : '';
$gender = (isset($_POST['gender']) && !empty($_POST['gender'])) ? $_POST['gender'] : '';

$dob = (isset($_POST['dob']) && is_array($_POST['dob']) && (sizeof($_POST['dob']) == 3)) ? $_POST['dob'] : array();

if (isset(
$_POST['submit']) && $_POST['submit'] == 'Register')
{
    
$errors = array();
    
    
// make sure manditory fields have been entered
    
if (empty($username))
    {
        
$errors[] = 'Username cannot be blank.';
    }
        
    
// check if username already is registered
    
$query 'SELECT username FROM palgo_info WHERE username = "' $username '"';
    
$result mysql_query($query$db) or die (mysql_error());
    if (
mysql_num_rows($result) > 0)
    {
        
$errors[] = 'Username: <em>' $username '</em> is already registered.';
        
$username '';
    }
        
    
// check if email already is registered    
    
$query 'SELECT email FROM palgo_info WHERE email = "' $email '"';
    
$result mysql_query($query$db) or die (mysql_error());
    if (
mysql_num_rows($result) > 0)
    {
        
$errors[] = 'Email Address: <em>' $email '</em> is already in use by a registered user.';
        
$email '';
    }
    
mysql_free_result($result);
    
    if (empty(
$password))
    {
        
$errors[] = 'Password cannot be blank.';
    }
    if (empty(
$first_name))
    {
        
$errors[] = 'First name cannot be blank.';        
    }
    if (empty(
$last_name))
    {
        
$errors[] = 'Last name cannot be blank.';
    }
    if (empty(
$email))
    {
        
$errors[] = 'Email address cannot be blank.';
    }

    if (
count($errors) > 0)
    {
        echo 
'<p><strong style="color:#FF000;">Unable to process your registration.</strong></p>';
        echo 
'<p>Please fix the following:</p>';
        echo 
'<ul>';
        foreach (
$errors as $error)
        {
            echo 
'<li>' $error '</li>';
        }
        echo 
'</ul>';
    }
    else
    {
        
// No errors so enter the information into the database.

        
$query 'INSERT INTO palgo_user (username, password)
                    VALUES ("' 
mysql_real_escape_string($username$db) . '", PASSWORD("' mysql_real_escape_string($password$db) . '")';    
        
$result mysql_query($query$db) or die(mysql_error());

        
$user_id mysql_insert_id($db);

        
$query 'INSERT INTO palgo_info (user_id, first_name, last_name, email, country, gender, d_o_b)
                    VALUES (' 
$user_id ', ' .
                            
'"' mysql_real_escape_string($first_name$db) . '", ' .
                            
'"' mysql_real_escape_string($last_name$db) . '", ' .
                            
'"' mysql_real_escape_string($email$db) . '", ' .
                            
'"' mysql_real_escape_string(join(', '$country), $db)  . '")';
                            
'"' mysql_real_escape_string(join(', '$gender), $db)  . '")';
                            
'"' mysql_real_escape_string(join(', '$dob), $db)  . '")';
        
$result mysql_query($query$db) or die(mysql_error());

        
$_SESSION['logged'] = 1;
        
$_SESSION['username'] = $username;

        
header('Refresh: 5; URL=login.php');                        

//        die();
    
}
}
?>        


<html>
<head>
<title>Registration</title>
</head>

<body>
    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    <table>
    <tr>
        <td ><label for="first_name">First Name:</label></td>
        <td><input type="text" name="text" maxlength="20" size="20"value="<?php echo $first_name?>" /></td>
    </tr>
    <tr>
        <td><label for="last_name">Last Name:</label></td>
        <td><input type="text" name="text" maxlength="20" size="20"  value="<?php echo $last_name?>"/></td>
    </tr>
    <tr>
        <td ><label for="username">User Name:</label></td>
        <td><input type="text" name="text" maxlength="20" size="20"  value="<?php echo $username?>"/></td>
    </tr>
    <tr>
        <td ><label for="email">Email:</label></td>
        <td><input type="text" name="text" maxlength="20" size="20"  value="<?php echo $email?>"/></td>
    </tr>
    <tr>
        <td><label for="password">Password:</label></td>
        <td><input type="password" name="password" maxlength="20"  value="<?php echo $password?>"/></td>
    </tr>
    <tr>
        <td><label for="counrty">Counrty:</label></td>
        <td>
            <select name="country" id="country" >
                <option>--select country--</option>
                <option value="yy">YY</option>
                <option value="kk">KK</option>
                <option value="mm">MM</option>
            </select>
        </td>
    </tr>
    <tr>
        <td><label for="gender">Gender:</label></td>
        <td>
            <select name="gender" id="gender">
                <option value="0">Select</option>
                <?php
                $option 
'';
                foreach(
$gender_list as $value)
                {
                    
$selected = ( ($value == $gender) ? ' selected="selected"' '');
                    
$option .= '<option value="' $value '"' $selected '>' .ucfirst($value) . '</option>' "\n";
                }
                
                echo 
$option;
                
?>
            </select>
        </td>
    </tr>
    <tr>
        <td><label for="dob">Date of birth:</label></td>
        <td>
            <select name="dob[]" id="dob" >
                <option >Month</option>
                <?php
                $option 
'';
                foreach(
$dob_list as $key => $value)
                {
                    
$selected = ( (($key 1) == $dob[0]) ? ' selected="selected"' '');
                    
$option .= '<option value="' . ($key 1) . '"' $selected '>' .$value '</option>' "\n";
                }
                
                echo 
$option;
                
?>
            </select>

            <select name="dob[]" id="dob" >
                <option value="0">Day</option>
                <?php
                $option 
'';
                
$range range(1,31);
                foreach(
$range as $value)
                {
                    
$selected = ( ($value == $dob[1]) ? ' selected="selected"' '');
                    
$option .= '<option value="' $value '"' $selected '>' .$value '</option>' "\n";
                }
                
                echo 
$option;
                
?>
            </select>

            <select name="dob[]" id="dob" >
                <option>Year</option>
                <?php
                $option 
'';
                
$range range(20001950);
                foreach(
$range as $value)
                {
                    
$selected = ( ($value == $dob[2]) ? ' selected="selected"' '');
                    
$option .= '<option value="' $value '"' $selected '>' .$value '</option>' "\n";
                }
                
                echo 
$option;
                
?>
            </select>
        </td>
    </tr>
    <tr>
        <td><input type="reset" value="reset" /></td>
        <td><input type="submit" name="submit" value="Register"/></td>
    </tr>
    </table>
    </form>

</body>
</html>

Last edited by UseLess; March 15th, 2012 at 02:48 PM..
Reply With Quote
The Following User Says Thank You to UseLess For This Useful Post:
aery (March 16th, 2012)
  #7 (permalink)  
Old March 16th, 2012, 05:34 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Default

hi thnkz for the code

when i open in my browser
with debug mode i works fine just that the inputs
gives with an array as

Code:
Array
(
    [text] => hghg
    [password] => ghghg
    [country] => kk
    [gender] => male
    [dob] => Array
        (
            [0] => 2
            [1] => 3
            [2] => 1998
        )

    [submit] => Register
)

and without a debug mode
it give a error as
Code:
Unknown column 'username' in 'field list'
Reply With Quote
  #8 (permalink)  
Old March 16th, 2012, 08:52 AM
Friend of Wrox
Points: 651, Level: 9
Points: 651, Level: 9 Points: 651, Level: 9 Points: 651, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Location: North East UK
Posts: 125
Thanks: 0
Thanked 24 Times in 24 Posts
Default

Greetings,

Change this;
Code:
    // check if username already is registered
    $query = 'SELECT username FROM palgo_info WHERE username = "' . $username . '"';
to this;
Code:
    // check if username already is registered
    $query = 'SELECT username FROM palgo_user WHERE username = "' . $username . '"';
Reply With Quote
  #9 (permalink)  
Old March 16th, 2012, 11:42 AM
Authorized User
Points: 54, Level: 1
Points: 54, Level: 1 Points: 54, Level: 1 Points: 54, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 13
Thanks: 2
Thanked 0 Times in 0 Posts
Default

hi,
even though i fill all the fields i still got thes message below:
i ve gone through many time could nt fig. wats wrong with the codes

Code:
Unable to process your registration.

Please fix the following:

    Username cannot be blank.
    First name cannot be blank.
    Last name cannot be blank.
    Email address cannot be blank.
Reply With Quote
  #10 (permalink)  
Old March 16th, 2012, 03:20 PM
Friend of Wrox
Points: 651, Level: 9
Points: 651, Level: 9 Points: 651, Level: 9 Points: 651, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Location: North East UK
Posts: 125
Thanks: 0
Thanked 24 Times in 24 Posts
Default

Greetings,

Simple.

You copied the code and have not changed the names of the textboxes, they are all called 'text'. Therefore none of the following are passed;

- username
- first name
- last name
- email address

and as they are not in the POST array they are set to empty strings.
Reply With Quote
The Following User Says Thank You to UseLess For This Useful Post:
aery (March 16th, 2012)
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch 8: <asp:image> inside <a> & ext.CSS (pg. 274) epc BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 1 July 12th, 2008 04:37 AM
Remove <select a value> option roy_mm Reporting Services 0 February 25th, 2007 02:26 AM
<style> tags in a <body> vs. <div> bcat BOOK: Beginning CSS: Cascading Style Sheets for Web Design ISBN: 978-0-7645-7642-3 1 March 27th, 2005 08:50 AM
<marquee><b>About CHAT App. in PHP4</b></marquee> Ramkrishna PHP How-To 1 September 11th, 2004 07:01 AM
<STRONG> vs <B> and <EM> vs <I> anshul HTML Code Clinic 12 September 1st, 2004 05:22 PM



All times are GMT -4. The time now is 04:28 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.