[Nadia F]

مستنيين باقي الشرح ياسيستم بس عندي اسثفسار هيفيد المنتدي في ايه

[ŞŸŞŤЁМ]

ده مجرد مثال مالوش علاقة بالمنتدي ده اسكربت عادي يفيد اي حد عايز يفهم ازاي يقدر يعمل ويب متكامل

[ŞŸŞŤЁМ]

كود PHP:

<table width="350" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form name="form1" method="post" action="signup_ac.php">
<table width="100%" border="0" cellspacing="4" cellpadding="0">
<tr>
<td colspan="3"><strong>Sign up</strong></td>
</tr>
<tr>
<td width="76">Name</td>
<td width="3">:</td>
<td width="305"><input name="name" type="text" id="name" size="30"></td>
</tr>
<tr>
<td>E-mail</td>
<td>:</td>
<td><input name="email" type="text" id="email" size="30"></td>
</tr>
<tr>
<td>password</td>
<td>:</td>
<td><input name="password" type="password" id="password" size="30"></td>
</tr>
<tr>
<td>Country</td>
<td>:</td>
<td><input name="country" type="text" id="country" size="30"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Submit"> &nbsp;
<input type="reset" name="Reset" value="Reset"></td>
</tr>
</table>
</form></td>
</tr>
</table>


نموذج التسجيل البسيط جدا مجرد HTML

ومن لم يعرف HTML يقوم بقراءة درس عن النماذج ويتابع الدرس

الصفحة باسم
signup.php

[ŞŸŞŤЁМ]

signup_ac.php
. عشوائي رمز التأكيد
2. ادخال البيانات ورمز التأكيد في قاعدة البيانات
3. إرسال رسالة بالبريد الإلكتروني إلى المستخدم مع تأكيد الارتباط

كود PHP:

<?
                                                  include('config.php');
                                                 // table name
                                                                                                     $tbl_name=temp_members_db;
                                                  
                                                  // Random confirmation code
                                                  $confirm_code=md5(uniqid(rand()));
                                                 // values sent from form
                                                  $name=$_POST['name'];
                                                  $email=$_POST['email'];
                                                  $country=$_POST['country'];
                                                 // Insert data into database
$sql="INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES('$confirm_code', '$name', '$email', '$password', '$country')";
                                                  $result=mysql_query($sql);
                                                  
                                                  // if suceesfully inserted data into database, send confirmation link to email
                                                  if($result){
                                                  // ---------------- SEND MAIL FORM ----------------
                                                 // send e-mail to ...
                                                  $to=$email;
                                                 // Your subject
  $subject="Your confirmation link here";
                                                 // From
  $header="from: your name <your email>";
                                                 // Your message
  $message="Your Comfirmation link \r\n";
  $message.="Click on this link to activate your account \r\n";
  $message.="http://www.yourweb.com/confirmation.php?passkey=$confirm_code";
                                                 // send email
                                                  $sentmail = mail($to,$subject,$message,$header);
                                                 }
                                                 // if not found
                                                  else {
                                                  echo "Not found your email in our database";
                                                  }
                                                 // if your email succesfully sent
                                                  if($sentmail){
                                                  echo "Your Confirmation link Has Been Sent To Your Email Address.";
                                                  }
                                                  else {
                                                  echo "Cannot send Confirmation link to your e-mail address";
                                                  }
                                                 ?>

[ŞŸŞŤЁМ]

صفحة confirmation.php

جاك عندما فتح بريده الالكتروني انه سوف ترى هذه الرسالة وصلة لملف "confirmation.php" بما في ذلك مفتاح المرور في رابط.

في هذه الخطوة
1. تحقق مفتاح المرور
2. إذا وجدت مفتاح المرور في قاعدة البيانات ، ونقل جميع البيانات في هذا الصف من الجدول "temp_members_db" على الطاولة "registered_members"
3. مفتاح المرور حذف من الجدول "temp_members_db

كود PHP:


<?
                                                include('config.php');
                                               // Passkey that got from link
                                                $passkey=$_GET['passkey'];
                                               $tbl_name1="temp_members_db";
                                               // Retrieve  data from table where row that match this passkey
                                                $sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";
                                                $result1=mysql_query($sql1);
                                               // If successfully queried
                                                if($result1){
                                                
                                                // Count how many row has this passkey
                                                $count=mysql_num_rows($result1);
                                               // if found this passkey in our database, retrieve data from table "temp_members_db"
                                                if($count==1){
                                                
                                                $rows=mysql_fetch_array($result1);
$name=$rows['name'];
$email=$rows['email'];
$password=$rows['password'];
$country=$rows['country'];                                              
                                               $tbl_name2="registered_members";
                                                
                                                // Insert data that retrieves from "temp_members_db" into table "registered_members"
  $sql2="INSERT INTO $tbl_name2(name, email, password, country)VALUES('$name', '$email', '$password', '$country')";
                                                $result2=mysql_query($sql2);
                                                }
                                                
                                                // if not found passkey, display message "Wrong Confirmation code"                                                
                                                else {
                                                echo "Wrong Confirmation code";
                                                }
                                               // if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"
                                                if($result2){
                                                
                                                echo "Your account has been activated";
                                                                                                 
                                                // Delete information of this user from table "temp_members_db" that has this passkey
  $sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";
                                                $result3=mysql_query($sql3);
                                                
                                                }
                                                
                                                }
                                                ?>