Registering Members

Registering Members

am 15.11.2007 15:21:16 von sebby.001

if any one out there can help me with this problem I would be very
greatful.

I have created a database to store new registered members to my
website but when data is sent to my database table, the entire row is
blank except for the automated id number.

I have searched in many places and have not been able to resolve this
problem.

Below is a copy of my page, the database connection is from another
page for security.





Members

require('dbConn.php');
?>



if ($_GET['mode'] == "add")
{
//////////////////////////////////Register Members to
DB//////////////////////////////////////////
$sql = "INSERT INTO members
(member_id,name,address,city,county,postcode,telephone,mobil e,email,username,password)
VALUES ( '', '$name', '$address', '$city', '$county', '$postcode',
'$telephone', '$mobile', '$email', '$username', '$password' )";
if ( @mysql_query($sql) )
{
echo "

face=verdana size=2>Your have succesfully registered color=black>".$username." as your account! size=1>";
?>
exit;
}else
{
echo mysql_error();
}
}
?>

echo "

".$msg."

";
?>


Register

Name: size="20">


Address: id="address" size="20">


City: size="20">


County: id="county" size="20">


Postcode: id="postcode" size="20">


Telephone: id="telephone" size="20">


Mobile: id="mobile" size="20">


Email: id="email" size="20">


Username: id="username" size="20">


Password: id="password" size="20">


type="reset" value="Reset" name="reset">







Can someone tell me what I have done wrong, please!

Re: Registering Members

am 15.11.2007 16:30:45 von Captain Paralytic

On Nov 15, 2:21 pm, sebby....@gmail.com wrote:
> if any one out there can help me with this problem I would be very
> greatful.
>
> I have created a database to store new registered members to my
> website but when data is sent to my database table, the entire row is
> blank except for the automated id number.
>
> I have searched in many places and have not been able to resolve this
> problem.
>
> Below is a copy of my page, the database connection is from another
> page for security.
>
>
>
>
>
> Members
>
> > require('dbConn.php');
> ?>
>
>
>
> > if ($_GET['mode'] == "add")
> {
> //////////////////////////////////Register Members to
> DB//////////////////////////////////////////
> $sql = "INSERT INTO members
> (member_id,name,address,city,county,postcode,telephone,mobil e,email,username,password)
> VALUES ( '', '$name', '$address', '$city', '$county', '$postcode',
> '$telephone', '$mobile', '$email', '$username', '$password' )";
> if ( @mysql_query($sql) )
> {
> echo "

> face=verdana size=2>Your have succesfully registered > color=black>".$username." as your account! > size=1>";
> ?>
> > exit;
> }else
> {
> echo mysql_error();
> }
> }
> ?>
>
> > echo "

".$msg."

";
> ?>
>
>

> Register
>

>

Name: > size="20">


>

Address: > id="address" size="20">


>

City: > size="20">


>

County: > id="county" size="20">


>

Postcode: > id="postcode" size="20">


>

Telephone: > id="telephone" size="20">


>

Mobile: > id="mobile" size="20">


>

Email: > id="email" size="20">


>

Username: > id="username" size="20">


>

Password: > id="password" size="20">


>

> type="reset" value="Reset" name="reset">


>

>

>
>
>
> Can someone tell me what I have done wrong, please!

You don't appear to be assiging the submitted values to the variables
that you are using in your insert statement.

Try changing $name
to $_POST['name']
and so on.

Re: Registering Members

am 15.11.2007 19:29:56 von sebby.001

On Nov 15, 4:30 pm, Captain Paralytic wrote:
> On Nov 15, 2:21 pm, sebby....@gmail.com wrote:
>
>
>
> > if any one out there can help me with this problem I would be very
> > greatful.
>
> > I have created a database to store new registered members to my
> > website but when data is sent to my database table, the entire row is
> > blank except for the automated id number.
>
> > I have searched in many places and have not been able to resolve this
> > problem.
>
> > Below is a copy of my page, the database connection is from another
> > page for security.
>
> >
>
> >
> >
> > Members
> >
> > > > require('dbConn.php');
> > ?>
> >
>
> >
> > > > if ($_GET['mode'] == "add")
> > {
> > //////////////////////////////////Register Members to
> > DB//////////////////////////////////////////
> > $sql = "INSERT INTO members
> > (member_id,name,address,city,county,postcode,telephone,mobil e,email,username,password)
> > VALUES ( '', '$name', '$address', '$city', '$county', '$postcode',
> > '$telephone', '$mobile', '$email', '$username', '$password' )";
> > if ( @mysql_query($sql) )
> > {
> > echo "

> > face=verdana size=2>Your have succesfully registered > > color=black>".$username." as your account! > > size=1>";
> > ?>
> > > > exit;
> > }else
> > {
> > echo mysql_error();
> > }
> > }
> > ?>
> >
> > > > echo "

".$msg."

";
> > ?>
>
> >

> > Register
> >

> >

Name: > > size="20">


> >

Address: > > id="address" size="20">


> >

City: > > size="20">


> >

County: > > id="county" size="20">


> >

Postcode: > > id="postcode" size="20">


> >

Telephone: > > id="telephone" size="20">


> >

Mobile: > > id="mobile" size="20">


> >

Email: > > id="email" size="20">


> >

Username: > > id="username" size="20">


> >

Password: > > id="password" size="20">


> >

> > type="reset" value="Reset" name="reset">


> >

> >

>
> >
>
> > Can someone tell me what I have done wrong, please!
>
> You don't appear to be assiging the submitted values to the variables
> that you are using in your insert statement.
>
> Try changing $name
> to $_POST['name']
> and so on.

On Nov 15, 4:30 pm, Captain Paralytic wrote:
> On Nov 15, 2:21 pm, sebby....@gmail.com wrote:
>
>
>
> > if any one out there can help me with this problem I would be very
> > greatful.
>
> > I have created a database to store new registered members to my
> > website but when data is sent to my database table, the entire row is
> > blank except for the automated id number.
>
> > I have searched in many places and have not been able to resolve this
> > problem.
>
> > Below is a copy of my page, the database connection is from another
> > page for security.
>
> >
>
> >
> >
> > Members
> >
> > > > require('dbConn.php');
> > ?>
> >
>
> >
> > > > if ($_GET['mode'] == "add")
> > {
> > //////////////////////////////////Register Members to
> > DB//////////////////////////////////////////
> > $sql = "INSERT INTO members
> > (member_id,name,address,city,county,postcode,telephone,mobil e,email,username,password)
> > VALUES ( '', '$name', '$address', '$city', '$county', '$postcode',
> > '$telephone', '$mobile', '$email', '$username', '$password' )";
> > if ( @mysql_query($sql) )
> > {
> > echo "
> > face=verdana size=2>Your have succesfully registered > > color=black>".$username." as your account! > > size=1>";
> > ?>
> > > > exit;
> > }else
> > {
> > echo mysql_error();
> > }
> > }
> > ?>
> >
> > > > echo "

".$msg."

";
> > ?>
>
> >

> > Register
> >

> >

Name: > > size="20">


> >

Address: > > id="address" size="20">


> >

City: > > size="20">


> >

County: > > id="county" size="20">


> >

Postcode: > > id="postcode" size="20">


> >

Telephone: > > id="telephone" size="20">


> >

Mobile: > > id="mobile" size="20">


> >

Email: > > id="email" size="20">


> >

Username: > > id="username" size="20">


> >

Password: > > id="password" size="20">


> >

> > type="reset" value="Reset" name="reset">


> >

> >

>
> >
>
> > Can someone tell me what I have done wrong, please!
>
> You don't appear to be assiging the submitted values to the variables
> that you are using in your insert statement.
>
> Try changing $name
> to $_POST['name']
> and so on.


I have not been successful in replacing but i did try something else.
I changed 'add' to send and added the following:-

if ($_GET['mode'] == "send")
{
$name = $_POST['name'];
$address = $_POST['address'];
$city = $_POST['city'];
$county = $_POST['county'];
$postcode = $_POST['postcode'];
$telephone = $_POST['telephone'];
$mobile = $_POST['mobile'];
$email = $_POST['email'];
$username = $_POST['username'];
$password = $_POST['password'];

This then sent the information to the database. The database now has
actual information stored in the tables.
I thank you for your help.

Could you also help me in expanding the function of my form. I want to
be able to send an automated email to the user who filled in the form
to say that you have registered to SITE. I do not know how to begin.

Re: Registering Members

am 15.11.2007 21:55:42 von Paul Lautman

sebby.001@gmail.com wrote:
> On Nov 15, 4:30 pm, Captain Paralytic wrote:
>> On Nov 15, 2:21 pm, sebby....@gmail.com wrote:
>>
>>
>>
>>> if any one out there can help me with this problem I would be very
>>> greatful.
>>
>>> I have created a database to store new registered members to my
>>> website but when data is sent to my database table, the entire row
>>> is
>>> blank except for the automated id number.
>>
>>> I have searched in many places and have not been able to resolve
>>> this
>>> problem.
>>
>>> Below is a copy of my page, the database connection is from another
>>> page for security.
>>
>>>
>>
>>>
>>>
>>> Members
>>>
>>> >>> require('dbConn.php');
>>>>
>>>
>>
>>>
>>> >>> if ($_GET['mode'] == "add")
>>> {
>>> //////////////////////////////////Register Members to
>>> DB//////////////////////////////////////////
>>> $sql = "INSERT INTO members
>>> (member_id,name,address,city,county,postcode,telephone,mobil e,email,username,password)
>>> VALUES ( '', '$name', '$address', '$city', '$county', '$postcode',
>>> '$telephone', '$mobile', '$email', '$username', '$password' )";
>>> if ( @mysql_query($sql) )
>>> {
>>> echo "


>>> Your have succesfully
>>> registered ".$username." as your
>>> account! >>> size=1>";
>>>>
>>> >>> exit;
>>> }else
>>> {
>>> echo mysql_error();
>>> }
>>> }
>>>>
>>>
>>> >>> echo "

".$msg."

";
>>>>
>>
>>>

>>> Register
>>>

>>>

Name: >>> id="name" size="20">


>>>

Address: >>> class="textfield" id="address" size="20">


>>>

City: >>> id="city" size="20">


>>>

County: >>> class="textfield"
>>> id="county" size="20">


>>>

Postcode: >>> class="textfield" id="postcode" size="20">


>>>

Telephone: >>> class="numberfield" id="telephone" size="20">


>>>

Mobile: >>> class="numberfield"
>>> id="mobile" size="20">


>>>

Email: >>> id="email" size="20">


>>>

Username: >>> class="textfield" id="username" size="20">


>>>

Password: >>> class="textfield" id="password" size="20">


>>>

>>> class="form_button"> >>> name="reset">


>>>

>>
>>>
>>
>>> Can someone tell me what I have done wrong, please!
>>
>> You don't appear to be assiging the submitted values to the variables
>> that you are using in your insert statement.
>>
>> Try changing $name
>> to $_POST['name']
>> and so on.
>
> On Nov 15, 4:30 pm, Captain Paralytic wrote:
>> On Nov 15, 2:21 pm, sebby....@gmail.com wrote:
>>
>>
>>
>>> if any one out there can help me with this problem I would be very
>>> greatful.
>>
>>> I have created a database to store new registered members to my
>>> website but when data is sent to my database table, the entire row
>>> is
>>> blank except for the automated id number.
>>
>>> I have searched in many places and have not been able to resolve
>>> this
>>> problem.
>>
>>> Below is a copy of my page, the database connection is from another
>>> page for security.
>>
>>>
>>
>>>
>>>
>>> Members
>>>
>>> >>> require('dbConn.php');
>>>>
>>>
>>
>>>
>>> >>> if ($_GET['mode'] == "add")
>>> {
>>> //////////////////////////////////Register Members to
>>> DB//////////////////////////////////////////
>>> $sql = "INSERT INTO members
>>> (member_id,name,address,city,county,postcode,telephone,mobil e,email,username,password)
>>> VALUES ( '', '$name', '$address', '$city', '$county', '$postcode',
>>> '$telephone', '$mobile', '$email', '$username', '$password' )";
>>> if ( @mysql_query($sql) )
>>> {
>>> echo "

>>> Your have succesfully
>>> registered ".$username." as your
>>> account! >>> size=1>";
>>>>
>>> >>> exit;
>>> }else
>>> {
>>> echo mysql_error();
>>> }
>>> }
>>>>
>>>
>>> >>> echo "

".$msg."

";
>>>>
>>
>>>

>>> Register
>>>

>>>

Name: >>> id="name" size="20">


>>>

Address: >>> class="textfield" id="address" size="20">


>>>

City: >>> id="city" size="20">


>>>

County: >>> class="textfield"
>>> id="county" size="20">


>>>

Postcode: >>> class="textfield" id="postcode" size="20">


>>>

Telephone: >>> class="numberfield" id="telephone" size="20">


>>>

Mobile: >>> class="numberfield"
>>> id="mobile" size="20">


>>>

Email: >>> id="email" size="20">


>>>

Username: >>> class="textfield" id="username" size="20">


>>>

Password: >>> class="textfield" id="password" size="20">


>>>

>>> class="form_button"> >>> name="reset">


>>>

>>
>>>
>>
>>> Can someone tell me what I have done wrong, please!
>>
>> You don't appear to be assiging the submitted values to the variables
>> that you are using in your insert statement.
>>
>> Try changing $name
>> to $_POST['name']
>> and so on.
>
>
> I have not been successful in replacing but i did try something else.
> I changed 'add' to send and added the following:-
>
> > if ($_GET['mode'] == "send")
> {
> $name = $_POST['name'];
> $address = $_POST['address'];
> $city = $_POST['city'];
> $county = $_POST['county'];
> $postcode = $_POST['postcode'];
> $telephone = $_POST['telephone'];
> $mobile = $_POST['mobile'];
> $email = $_POST['email'];
> $username = $_POST['username'];
> $password = $_POST['password'];
>
> This then sent the information to the database. The database now has
> actual information stored in the tables.
> I thank you for your help.
>
> Could you also help me in expanding the function of my form. I want to
> be able to send an automated email to the user who filled in the form
> to say that you have registered to SITE. I do not know how to begin.

I use
http://www.boaddrink.com/sites/www.boaddrink.com/files/issue s/formmail_2.php_.txt

Re: Registering Members

am 15.11.2007 21:56:42 von zeldorblat

On Nov 15, 1:29 pm, sebby....@gmail.com wrote:
>
> Could you also help me in expanding the function of my form. I want to
> be able to send an automated email to the user who filled in the form
> to say that you have registered to SITE. I do not know how to begin.

Begin here:

Re: Registering Members

am 16.11.2007 13:14:33 von sebby.001

On Nov 15, 9:56 pm, ZeldorBlat wrote:
> On Nov 15, 1:29 pm, sebby....@gmail.com wrote:
>
>
>
> > Could you also help me in expanding the function of my form. I want to
> > be able to send an automated email to the user who filled in the form
> > to say that you have registered to SITE. I do not know how to begin.
>
> Begin here:
>
>


How do i setup my form to check availability for usernames and also
password strength confirmation?

Re: Registering Members

am 16.11.2007 14:26:26 von Captain Paralytic

On 16 Nov, 12:14, sebby....@gmail.com wrote:
> On Nov 15, 9:56 pm, ZeldorBlat wrote:
>
> > On Nov 15, 1:29 pm, sebby....@gmail.com wrote:
>
> > > Could you also help me in expanding the function of my form. I want to
> > > be able to send an automated email to the user who filled in the form
> > > to say that you have registered to SITE. I do not know how to begin.
>
> > Begin here:
>
> >
>
> How do i setup my form to check availability for usernames and also
> password strength confirmation?

You search using google and you find a lot of articles. You read them
and learn.
As I did, you will also find lots of ready written code such as the
php formmail script.
These you look at and alter and learn more.