| تبليغات | X |
 |
|
- |
|
|
|
وب سایت ما در حال حاظر بنابر دلایلی غیر قابل دسترس است ! |
|
www.persianhackers.ir : تا راه اندازی مجدد وب سایت میتوانید برای ورود به وبلاگ از این دامین هم استفاده کنید |
|
|
|
: لينک هاي ثابت |
|
خريد فيلم هري پاتر و محفل ققنوس با زيرنويس فارسي قابل اجرا در ويدئو سي دي ! |
|
در این مقاله شما طرز ساختن یک سیستم عضویت ساده (Membership Sytem) برای وب سایتتان بوسیله PHP و MySQL را یاد خواهید گرفت.
در طی این مقاله شما استفاده آسان از موارد زیر و همچنین به کاربردن آنها در برنامههای دیگر را یاد خواهید گرفت:
CREATE TABLE users (
userid int(25) NOT NULL auto_increment,
first_name varchar(25) NOT NULL default '',
last_name varchar(25) NOT NULL default '',
email_address varchar(25) NOT NULL default '',
username varchar(25) NOT NULL default '',
password varchar(255) NOT NULL default '',
info text NOT NULL,
user_level enum('0','1','2','3') NOT NULL default '0',
signup_date datetime NOT NULL default '0000−00−00 00:00:00',
last_login datetime NOT NULL default '0000−00−00 00:00:00',
activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (userid) ) TYPE=MyISAM COMMENT='Membership Information';
sql.txt <?php include 'db.php'; ?>
<?php
$dbhost = "localhost"; // database host
$dbuser = "db_username"; // database username
$dbpassword = "db_password"; // database password
$db2use = "db_name"; // name of database
$conn = @mysql_pconnect($dbhost,$dbuser,$dbpassword)
or die("Connection failed: Please try later.");
$db = @mysql_select_db ($db2use,$conn) or die(Error:.mysql_error());
?>
// Define post fields into simple variables $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $email_address = $_POST['email_address']; $username = $_POST['username']; $info = $_POST['info']; // Let's strip some slashes in case the user entered any escaped characters $first_name = stripslashes($first_name); $last_name = stripslashes($last_name); $email_address = stripslashes($email_address); $username = stripslashes($username); $info = stripslashes($info);
// Do some error checking on the form posted fields
if((!$first_name) || (!$last_name) || (!$email_address) || (!$username)) {
echo 'You did not submit the following required information! <br />';
if (!$first_name) {
echo "First Name is a required field. Please enter it below.<br />";
}
if (!$last_name) {
echo "Last Name is a required field. Please enter it below.<br />";
}
if (!$email_address) {
echo "Email Address is a required field. Please enter it below.<br />";
}
if (!$username) {
echo "Desired Username is a required field. Please enter it below.<br />";
}
include 'join_form.html'; // Show the form again!
/* End the error checking and if everything is ok, we'll move on to
creating the user account */
exit(); // if the error checking has failed, we'll exit the script!
}
$sql_email_check = mysql_query("SELECT email_address FROM users WHERE
email_address='$email_address'");
$sql_username_check = mysql_query("SELECT username FROM users WHERE
username='$username'");
$email_check = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check);
if (($email_check > 0) || ($username_check > 0)) {
echo "Please fix the following errors: <br />";
if ($email_check > 0) {
echo "<strong>Your email address has already been used by
another member in our database. Please submit a different
Email address!<br />";
unset($email_address);
}
if ($username_check > 0) {
echo "The username you have selected has already been used by
another member in our database. Please choose a different
Username!<br />";
unset($username);
}
include 'join_form.html'; // Show the form again!
exit(); // exit the script so that we do not create this account!
}
function makeRandomPassword() {
$salt = "abchefghjkmnpqrstuvwxyz0123456789";
srand((double)microtime()*1000000);
$i = 0;
while ($i <= 7) {
$num = rand() % 33;
$tmp = substr($salt, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}
$random_password = makeRandomPassword();
$db_password = md5($random_password);
// Enter info into the Database.
$info2 = htmlspecialchars($info);
$sql = mysql_query("INSERT INTO users (first_name, last_name,
email_address, username, password, info, signup_date)
VALUES('$first_name', '$last_name', '$email_address',
'$username', '$db_password', '$info2', now())") or die (mysql_error());
if (!$sql) {
echo 'There has been an error creating your account. Please
contact the webmaster.';
}
else {
$userid = mysql_insert_id();
// Let's mail the user!
$subject = "Your Membership at MyWebsite!";
$message = "Dear $first_name $last_name,
Thank you for registering at our website, http://www.mydomain.com!
You are two steps away from logging in and accessing our exclusive members
area. To activate your membership, please click here:
http://www.mydomain.com/activate.php?id=$userid&code=$db_password
Once you activate your memebership, you will be able to login with the
following information:
Username: $username
Password: $random_password
Thanks!
The Webmaster
This is an automated response, please do not reply!";
mail($email_address, $subject, $message,
"From: MyDomain Webmaster< admin@mydomain.com>");
echo 'Your membership information has been mailed to your email address!
Please check it and follow the directions!';
}
?>
$new = htmlspecialchars("<a href='test'>Test</a>", ENT_QUOTES);
echo $new; // <a href='test'>Test</a>
From: MyDomain Webmaster To: you@email.com Subject: Your Membership at MyWebsite! Dear boy from sun, Thank you for registering at our website, http://www.mydomain.com! You are two steps away from logging in and accessing our exclusive members area. To activate your membership, please click here: http://www.mydomain.com/activate.php?id=3&cod=37ec82769e837c2f853450 Once you activate your memebership, you will be able to login with the following information: Username: myusername Password: msxsag4h Thanks! The Webmaster This is an automated response, please do not reply!
<?
/* Account activation script */
include 'db.php';
$userid = $_REQUEST['id'];
$code = $_REQUEST['code'];
$sql = mysql_query("UPDATE users SET activated='1' WHERE userid='$userid'
AND password='$code'");
$sql_doublecheck = mysql_query("SELECT * FROM users WHERE userid='$userid'
AND password='$code' AND activated='1'");
$doublecheck = mysql_num_rows($sql_doublecheck);
if ($doublecheck == 0) {
echo "<font color=red>Your account could not be activated!</font>";
} elseif ($doublecheck > 0) {
echo "Your account has been activated! You may login below!<br />";
include 'login_form.html';
}
?>
|
 |
نوشته شده توسط آرشام هکر در دسته : خدمات ارشام بلاگ 2
| |
|
لينک دوستان |
|||||
|
Iran Pc TeaM |
