Page 1 of 1

Create online registration?

Posted: Tue Jul 11, 2006 1:19 pm
by mak15
Hi! My department had annouced a educational program. I want them to register the program online and created username & password to edit/update their information later (Which will be a secure area for every applicants). Email notification for every submission and edited to the applicant. Is there such scripts out there ? Thanks for any advice!
My server specification:
-WIN2000AdvancedServer
-IIS 5.0
-MySQL

Posted: Tue Jul 11, 2006 3:07 pm
by tecktalkcm0391
Create a database and table for users. Have every piece of information as a coulmn have it add the username password ect. then email them (try SwiftMailer (google it)) then have them check there email and then when they open the link a column named accountactive would be set to 1 and then they can login and add there information.

Posted: Tue Jul 11, 2006 10:15 pm
by alexus
http://www.swish-db.com/tutorials/view.php/tid/601

This is a bit overhelming but describes everithing what u need...

Focus on recording data to MySQL

here is sample code from myself:

Code: Select all

<?
//Register New Profiel

$db_server="server.com";
$db_user="username_of_server";
$db_pass="password";

$db_name="database_name";

$db = mysql_connect($db_server, $db_user, $db_pass);
mysql_select_db($db_name, $db);

//Record data to db
if(isset($submit_registration)){

    $date=date("Y-m-d");

    $sql = "INSERT INTO user SET " .
    "user='$user',".
    "pass='$pass',". 
    "email='$email',".
    "fullname='$fullname',".
    "address='$address',".
    "city='$city',".
    "state='$state',".
    "zip='$zip',".
    "reg_date='$date'";
	if (mysql_query($sql)) {
	    //echo "<center><b>$name added<b></center><br>";
		//echo "Row ID:". mysql_insert_id();
        $reg_status="ok";
        session_register("username");	// register name
		session_register("password"); // register username and password as session variables.
	}else{
		if( mysql_errno() == 1062){
         	//echo "Username $username alredy exist!";
            $reg_status="username_error";
        }else{
        	 $reg_status="error";
        	//echo("<P><b>Error:</b> " .mysql_error() . "</P> Error#:". mysql_errno());	
			//exit();
        }
	}  
}
?>

Note: You gotta have your mysql table structure build first before you use this script. and im too lazy to do a ful tutorial here

Posted: Wed Jul 12, 2006 8:44 am
by mak15
Thank you so much! I will try it myself! :wink:
alexus wrote:http://www.swish-db.com/tutorials/view.php/tid/601

This is a bit overhelming but describes everithing what u need...

Focus on recording data to MySQL

here is sample code from myself:

Code: Select all

<?
//Register New Profiel

$db_server="server.com";
$db_user="username_of_server";
$db_pass="password";

$db_name="database_name";

$db = mysql_connect($db_server, $db_user, $db_pass);
mysql_select_db($db_name, $db);

//Record data to db
if(isset($submit_registration)){

    $date=date("Y-m-d");

    $sql = "INSERT INTO user SET " .
    "user='$user',".
    "pass='$pass',". 
    "email='$email',".
    "fullname='$fullname',".
    "address='$address',".
    "city='$city',".
    "state='$state',".
    "zip='$zip',".
    "reg_date='$date'";
	if (mysql_query($sql)) {
	    //echo "<center><b>$name added<b></center><br>";
		//echo "Row ID:". mysql_insert_id();
        $reg_status="ok";
        session_register("username");	// register name
		session_register("password"); // register username and password as session variables.
	}else{
		if( mysql_errno() == 1062){
         	//echo "Username $username alredy exist!";
            $reg_status="username_error";
        }else{
        	 $reg_status="error";
        	//echo("<P><b>Error:</b> " .mysql_error() . "</P> Error#:". mysql_errno());	
			//exit();
        }
	}  
}
?>

Note: You gotta have your mysql table structure build first before you use this script. and im too lazy to do a ful tutorial here