[RESOLVED] select a specific form in PHP /Mysql?

Pinkmischief

Hi i was wondering if anyone would be able to help me with this.

I have a registration form which submits to a database but i want it so that php detects that a user has entered less that required amount of figures to register this is the code i have of current

<?php if (isset($usereg));
$register = "INSERT INTO users (username) VALUES ('$userregistration')";
if (!mysql_db_query($db,$register))echo "Successfully Registered!";?>
<?php if ($userreg < 8){echo "please enter more than 8 digits";}?>

If someone can see what is wrong with this code please guide me in the right direction i am quite new to PHP , MYSQL programming (like about 3 weeks lol 😃)

Also does anyone know how i can select a specific form example 3 forms on a page named
1. userreg
2adminlogin
3userlogin

for people to login using the admin or standard user do i need to declare variables for each form i havent done user login before well i have but not in hard code i always used dreamweaver pre-generated code (im a cheater! lol)

Kind Regards Pinky

rincewind456

Well if this code is in the correct order

<?php if (isset($usereg));
$register = "INSERT INTO users (username) VALUES ('$userregistration')";
if (!mysql_db_query($db,$register))echo "Successfully Registered!";?>
<?php if ($userreg < 8){echo "please enter more than 8 digits";}?>

then you are carrying out the check after the Insert!

The check itself doesn't do anything this howeber

<?php if (strlen(trim($userreg)) < 8){echo "please enter at least 8 digits";}?>

checks to see if the user input is 8 or more characters, not including spaces at either end of the string.

Pinkmischief

THX for the mega quick response 🙂

My code now looks like this
<?php if (strlen(trim($userreg)) < 8){echo "please enter at least 8 digits";}?>
<?php if (isset($usereg));
$register = "INSERT INTO users (username) VALUES ('$userregistration')";
if (!mysql_db_query($db,$register))echo "Successfully Registered!";?>

It does work now tyvm 😃 but... it is showing please use at least 8 digits before even submitting form does it have to be this way if so i dont mind but it would be good if it could be like if someone enters test into the field and then submits it ,php says must be longer than 8 digits. as opposed to showing it instantly.

Am happy to know i was along the right lines sort of lol

Many Thanks Pinky

rincewind456

try seperating your validation from your form, like this

<?php

if (isset($_POST['submit'])){ //check to see if Submit button has been pressed

$userreg = $_POST['userreg']; // change post variable to $userreg

if (strlen(trim($userreg)) < 8){
	echo "please enter at least 8 digits";  // check for field length
} else {
//then your insert statement here
}
} else {
?>
<form action="" method="post">
<p>Enter username<input type="text" size="40" name="userreg"></p>
<input type="submit" name="submit" value="Submit">
</form>
<?php
}
?>

Pinkmischief

your a genius! 😃 Many Thanks!

rincewind456

Pinkmischief wrote:
your a genius!

No definately Not!