a PHP question - Page 2 - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

O~Snapple · 09-15-2006, 05:27 PM

Well for every form you have an action for example...

[html]<FORM METHOD="POST" ACTION="register.php" onSubmit="return Form1_Validator(this)" name="Form1">


First Name: 

<INPUT NAME="firstname" SIZE=25 MAXLENGTH=50>
Last Name: 

<INPUT NAME="lastname" SIZE=25 MAXLENGTH=50> 


Company: 

<INPUT NAME="company" SIZE=25 MAXLENGTH=50> 
Username:
 
<INPUT NAME="username" SIZE=25 MAXLENGTH=50>
 
Password: 

<INPUT TYPE="password" NAME="password" SIZE=25 MAXLENGTH=25>
 

Confirm Password: 
<INPUT TYPE="password" NAME="confirm" SIZE=25 MAXLENGTH=25>


E-Mail Address: 

<INPUT TYPE="text" NAME="email" SIZE=25 MAXLENGTH=100> 
Requested Access Level: 
<label>
<select name="access">
<option>Access Level Request</option>
<option>Employee</option>
<option>Patient</option>
<option>Referral</option>
</select>
</label>


<INPUT TYPE="submit" NAME="submit" VALUE="Submit" style="font-family: Tahoma">
</FORM>[/html]

You notice on the top my Action is register.php which looks like this

PHP Code:


		
			
<?php



//prevents caching

header("Expires: Sat, 01 Jan 2000 00:00:00 GMT");

header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");

header("Cache-Control: post-check=0, pre-check=0",false);

session_cache_limiter();



session_start();



//require the config file

require ("config.php");

require ("functions.php");



//checks password length

if (password_check($min_pass, $max_pass, $_POST[password]) == "no")

{

?>

<html>



<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

<meta http-equiv="refresh" content="0; url=javascript:history.go(-1)">

<title>Registration</title>

<script language="JavaScript">

<!--

function FP_popUpMsg(msg) {//v1.0

 alert(msg);

}

// -->

</script>

</head>



<body onLoad="FP_popUpMsg('Your password must be between <? echo $min_pass; ?> & <? echo $max_pass; ?> characters.')">



</body>



</html>

<?

exit;

}



//make the connection to the database

$connection = @mysql_connect($server, $dbusername, $dbpassword) or die(mysql_error());

$db = @mysql_select_db($db_name,$connection)or die(mysql_error());



//make query to database

$sql ="SELECT * FROM $table_name WHERE username= '$_POST[username]'";

$result = @mysql_query($sql,$connection) or die(mysql_error());



//get the number of rows in the result set

$num = mysql_num_rows($result);



//checks it see if that username already exists

if ($num != 0){



echo "<P>Sorry, that username already exists.</P>";

echo "<P><a href=\"#\" onClick=\"history.go(-1)\">Try Another Username.</a></p>";

exit;



}

else

{

$sql = "INSERT INTO $table_name VALUES ('$_POST[firstname]', '$_POST[lastname]', '$_POST[company]', '$_POST[username]', password('$_POST[password]'), 'Users', '', '', '$pchange', '$_POST[email]', '$_POST[access]', '$default_url', '$verify', '')";



$result = @mysql_query($sql,$connection) or die(mysql_error());

}



//checks to see if the user needs to verify their email address before accessing the site

if ($verify == "0")

{

    $mailheaders = "From: www$domain\n";

    $mailheaders .= "Your account has been created.\n";

    $mailheaders .= "Please activate your account now by visiting this page:\n";

    $mailheaders .= "$base_dir/activate.html\n";





    $to = "$_POST[email]";

    $subject = "Please activate your account";



mail($to, $subject, $mailheaders, "From: No Reply <$adminemail>\n");



}else{

    header('Location:login.html');

}







?>



<HTML>

<HEAD>

<TITLE>Add a User</TITLE>

</HEAD>

<BODY>

<H1>Please check your email to activate your account.</H1>

</BODY>

</HTML>

So when the form is filled out and the user clicks teh button at the bottom, register.php loads and preforms the operations which checks password length and opens up a connection with the Database and whatever you decide to have it do.

This is where you would want to have the checks to see if the form has been filled out correctly. IE password length, not a e-mail that has already been used etc...

Make Sense???

~Snapple

BrotherBear · 09-15-2006, 05:49 PM

yes it makes sense but where in phpMyAdmin should I put "form1.php"

I already have a table the name is Customers the ID is form_ID and the other fields are fname lname email and age and comments or just by putting form1.php in the HTML it's enough?

BB

alwaysinit · 09-15-2006, 10:42 PM

heehee, snapple,s quick, he answered while I was typing an answer. now I most post this retarded message

alwaysinit · 09-15-2006, 10:50 PM

***POST EDITED BY O~SNAPPLE PLEASE USE CORRECT TAGS WHEN POSTING CODE***
Do it like this in your form.html:[html]
<form action="form1.php" method="post">[/html]
then just put the php page and html page in the same folder on your server
That line of code calls the php page into performing it's functions(when user clicks submit)

And "form1.php" goes in your folder that has your form.html page( Does'nt go inside phpmyadmin)
Just make sure the two pages are together and it will work the way O-snap said

alwaysinit · 09-15-2006, 11:00 PM

Hey Snap, Can I recommend brother bear to a tutorial that's on another site, it really helped me understand fast.

O~Snapple · 09-16-2006, 02:49 AM

For sure, make sure that you post the link rather than copy whats on their page its a fine line regarding copyright issues so always link to their page if necessary.

and Brothr Bear:
The Action is what happens when someone clicks the submit button. in the Action script you would want to call the MySQL database and make changes to the data base or querys, theres really endless possibilities. Im a huge fan of PHP. i learn more about it every day and i started learning it by just examining code.

~Snapple

alwaysinit · 09-16-2006, 03:15 AM

Check out this link Brother BearPHP Help: Creating a Membership System with PHP and MySQL
It is a tutorial for creating a membership system. If you take the time to go through it you will find actual working code for all those things you want to do. Plus you will then have a much better understanding of how PHP scripts(pages) interact with your forms and html pages.
Oh and it's easier to follow the tutorial if you set everything up the way he has it set up. Create a new database in phpMyAdmin and set up the table with fields just like he does.

BrotherBear · 09-18-2006, 03:48 PM

thank you alwaysinit and snap I'll read carefully the tutorials and if I have any other questions well I'll come here, thanks

BB

BrotherBear · 09-19-2006, 07:03 PM

so to resume in the page of the form you have to put the text areas and form object and when you press the submit button in the next page you hav to put the mysql stuff so the info can be stored right?

BB

alwaysinit · 09-19-2006, 07:07 PM

Sounds exactly right to me