[/SIZE][/B][/COLOR][CENTER][COLOR=red][B][SIZE=4] [/SIZE][/B][/COLOR][SIZE=4][COLOR=Blue] أول ترجمة لي لدروس باللغة PHP الجميلة في منتدانا المشاغب[/COLOR][/SIZE]
[SIZE=4][COLOR=Blue] [/COLOR][/SIZE]
[SIZE=4][COLOR=Blue] سيتم أنشاء 3 ملفات يتم تسميتهم بـ[/COLOR][/SIZE]
- [SIZE=4][COLOR=Blue]main_login.php[/COLOR][/SIZE]
- [SIZE=4][COLOR=Blue]checklogin.php[/COLOR][/SIZE]
- [SIZE=4][COLOR=Blue]login_success.php[/COLOR][/SIZE]
- [SIZE=4][COLOR=Blue]logout.php[/COLOR][/SIZE]
- [SIZE=4][COLOR=Blue]أنشاء قاعدة بيانات بأسم test[/COLOR][/SIZE]
- [SIZE=4][COLOR=Blue]أنشاء جدول في القاعدة بأسم members[/COLOR][/SIZE]
[SIZE=4][COLOR=Blue]خطوات العمل [/COLOR][/SIZE]
[SIZE=4][COLOR=Blue] [/COLOR][/SIZE]
[SIZE=4][COLOR=Blue] 1- أنشاء جدول [/COLOR][/SIZE][B][SIZE=4][COLOR=Blue]members قم بزرع الكود التالي[/COLOR][/SIZE][/B]
[B][SIZE=4][COLOR=Blue] [/COLOR][/SIZE][/B] كود PHP:
[/CENTER]
[CENTER] [COLOR=#000000] [COLOR=#0000BB]CREATE TABLE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000BB]members[/COLOR][COLOR=#007700]` ( `[/COLOR][COLOR=#0000BB]id[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]int[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]4[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL auto_increment[/COLOR][COLOR=#007700], `[/COLOR][COLOR=#0000BB]username[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]varchar[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]65[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700], `[/COLOR][COLOR=#0000BB]password[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]varchar[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]65[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]PRIMARY KEY [/COLOR][COLOR=#007700](`[/COLOR][COLOR=#0000BB]id[/COLOR][COLOR=#007700]`) ) [/COLOR][COLOR=#0000BB]TYPE[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]MyISAM AUTO_INCREMENT[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]2 [/COLOR][COLOR=#007700]; -- -- [/COLOR][COLOR=#0000BB]Dumping data [/COLOR][COLOR=#007700]for [/COLOR][COLOR=#0000BB]table [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000BB]members[/COLOR][COLOR=#007700]` -- [/COLOR][COLOR=#0000BB]INSERT INTO [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000BB]members[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]VALUES [/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]1[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]'admin'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]'1234'[/COLOR][COLOR=#007700]);
[/COLOR] [/COLOR] [/CENTER]
[CENTER]
[SIZE=3][COLOR=Blue]بيانات الدخول راح تكون [/COLOR][/SIZE]
[SIZE=3][COLOR=Blue] اسم المستخدم : admin[/COLOR][/SIZE]
[SIZE=3][COLOR=Blue] كلمة المرور : 1234[/COLOR][/SIZE]
[SIZE=3][COLOR=Blue] [/COLOR][/SIZE]
[SIZE=3][COLOR=Blue] راح يكون الصورة كالتالي[/COLOR][/SIZE]
[SIZE=3][COLOR=Blue] 2- أنشاء ملف [/COLOR][/SIZE][B][SIZE=3][COLOR=Blue]main_login.php[/COLOR][/SIZE][/B]
[B]
[/B][B][SIZE=3][COLOR=Blue]ضع الكود التالي في الملف :-[/COLOR][/SIZE][/B]
كود بلغة HTML:
[COLOR=#008080]<table width=[COLOR=#0000FF]"300"[/COLOR] border=[COLOR=#0000FF]"0"[/COLOR] align=[COLOR=#0000FF]"center"[/COLOR] cellpadding=[COLOR=#0000FF]"0"[/COLOR] cellspacing=[COLOR=#0000FF]"1"[/COLOR] bgcolor=[COLOR=#0000FF]"#CCCCCC"[/COLOR]>[/COLOR][COLOR=#008080]<tr>[/COLOR][COLOR=#FF8000]<form name=[COLOR=#0000FF]"form1"[/COLOR] method=[COLOR=#0000FF]"post"[/COLOR] action=[COLOR=#0000FF]"checklogin.php"[/COLOR]>[/COLOR][COLOR=#008080]<td>[/COLOR][COLOR=#008080]<table width=[COLOR=#0000FF]"100%"[/COLOR] border=[COLOR=#0000FF]"0"[/COLOR] cellpadding=[COLOR=#0000FF]"3"[/COLOR] cellspacing=[COLOR=#0000FF]"1"[/COLOR] bgcolor=[COLOR=#0000FF]"#FFFFFF"[/COLOR]>[/COLOR][COLOR=#008080]<tr>[/COLOR][COLOR=#008080]<td colspan=[COLOR=#0000FF]"3"[/COLOR]>[/COLOR][COLOR=#000080]<strong>[/COLOR]Member Login [COLOR=#000080]</strong>[/COLOR][COLOR=#008080]</td>[/COLOR][COLOR=#008080]</tr>[/COLOR][COLOR=#008080]<tr>[/COLOR][COLOR=#008080]<td width=[COLOR=#0000FF]"78"[/COLOR]>[/COLOR]Username[COLOR=#008080]</td>[/COLOR][COLOR=#008080]<td width=[COLOR=#0000FF]"6"[/COLOR]>[/COLOR]:[COLOR=#008080]</td>[/COLOR][COLOR=#008080]<td width=[COLOR=#0000FF]"294"[/COLOR]>[/COLOR][COLOR=#FF8000]<input name=[COLOR=#0000FF]"myusername"[/COLOR] type=[COLOR=#0000FF]"text"[/COLOR] id=[COLOR=#0000FF]"myusername"[/COLOR]>[/COLOR][COLOR=#008080]</td>[/COLOR][COLOR=#008080]</tr>[/COLOR][COLOR=#008080]<tr>[/COLOR][COLOR=#008080]<td>[/COLOR]Password[COLOR=#008080]</td>[/COLOR][COLOR=#008080]<td>[/COLOR]:[COLOR=#008080]</td>[/COLOR][COLOR=#008080]<td>[/COLOR][COLOR=#FF8000]<input name=[COLOR=#0000FF]"mypassword"[/COLOR] type=[COLOR=#0000FF]"text"[/COLOR] id=[COLOR=#0000FF]"mypassword"[/COLOR]>[/COLOR][COLOR=#008080]</td>[/COLOR][COLOR=#008080]</tr>[/COLOR][COLOR=#008080]<tr>[/COLOR][COLOR=#008080]<td>[/COLOR][B][I] [/I][/B][COLOR=#008080]</td>[/COLOR][COLOR=#008080]<td>[/COLOR][B][I] [/I][/B][COLOR=#008080]</td>[/COLOR][COLOR=#008080]<td>[/COLOR][COLOR=#FF8000]<input type=[COLOR=#0000FF]"submit"[/COLOR] name=[COLOR=#0000FF]"Submit"[/COLOR] value=[COLOR=#0000FF]"Login"[/COLOR]>[/COLOR][COLOR=#008080]</td>[/COLOR][COLOR=#008080]</tr>[/COLOR][COLOR=#008080]</table>[/COLOR][COLOR=#008080]</td>[/COLOR][COLOR=#FF8000]</form>[/COLOR][COLOR=#008080]</tr>[/COLOR][COLOR=#008080]</table>[/COLOR]
[SIZE=3][COLOR=Blue]3- أنشاء ملف [/COLOR][/SIZE][B][SIZE=3][COLOR=Blue]checklogin.php[/COLOR][/SIZE][/B]
كود PHP:
[/CENTER]
[CENTER] [COLOR=#000000] [COLOR=#0000BB]<?php
$host[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"localhost"[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Host name
[/COLOR][COLOR=#0000BB]$username[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Mysql username
[/COLOR][COLOR=#0000BB]$password[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Mysql password
[/COLOR][COLOR=#0000BB]$db_name[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"test"[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Database name
[/COLOR][COLOR=#0000BB]$tbl_name[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"members"[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Table name
// Connect to server and select databse.
[/COLOR][COLOR=#0000BB]mysql_connect[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"$host"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]"$username"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]"$password"[/COLOR][COLOR=#007700])or die([/COLOR][COLOR=#DD0000]"cannot connect"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]mysql_select_db[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"$db_name"[/COLOR][COLOR=#007700])or die([/COLOR][COLOR=#DD0000]"cannot select DB"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#FF8000]// username and password sent from form
[/COLOR][COLOR=#0000BB]$myusername[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]$_POST[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'myusername'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#0000BB]$mypassword[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]$_POST[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'mypassword'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#FF8000]// To protect MySQL injection (more detail about MySQL injection)
[/COLOR][COLOR=#0000BB]$myusername [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]stripslashes[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$myusername[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$mypassword [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]stripslashes[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$mypassword[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$myusername [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_real_escape_string[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$myusername[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$mypassword [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_real_escape_string[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$mypassword[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$sql[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]$result[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$sql[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#FF8000]// Mysql_num_row is counting table row
[/COLOR][COLOR=#0000BB]$count[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]mysql_num_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$result[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#FF8000]// If result matched $myusername and $mypassword, table row must be 1 row
[/COLOR][COLOR=#007700]if([/COLOR][COLOR=#0000BB]$count[/COLOR][COLOR=#007700]==[/COLOR][COLOR=#0000BB]1[/COLOR][COLOR=#007700]){
[/COLOR][COLOR=#FF8000]// Register $myusername, $mypassword and redirect to file "login_success.php"
[/COLOR][COLOR=#0000BB]session_register[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"myusername"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]session_register[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"mypassword"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]header[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"location:login_success.php"[/COLOR][COLOR=#007700]);
}
else {
echo [/COLOR][COLOR=#DD0000]"Wrong Username or Password"[/COLOR][COLOR=#007700];
}
[/COLOR][COLOR=#0000BB]?>[/COLOR] [/COLOR] [/CENTER]
[CENTER]
4- أنشاء ملف [B]login_success.php[/B]
كود PHP:
[COLOR=#000000] [COLOR=#0000BB]<?
session_start[/COLOR][COLOR=#007700]();
if(![/COLOR][COLOR=#0000BB]session_is_registered[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]myusername[/COLOR][COLOR=#007700])){
[/COLOR][COLOR=#0000BB]header[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"location:main_login.php"[/COLOR][COLOR=#007700]);
}
[/COLOR][COLOR=#0000BB]?>
[/COLOR]
<html>
<body>
Login Successful
<br /><div style="z-index:3" class="smallfont" align="center">Search Engine Optimization by <a rel="nofollow" href="http://www.crawlability.com/vbseo/">vBSEO</a> 3.1.0</div></body>
</html>[/COLOR] [/CENTER]
[CENTER]
[SIZE=3][COLOR=Blue]5- أنشاء ملف [/COLOR][/SIZE][B][SIZE=3][COLOR=Blue]Logout.php[/COLOR][/SIZE][/B]
كود PHP:
[/CENTER]
[CENTER] [COLOR=#000000] [COLOR=#0000BB]<?
session_start[/COLOR][COLOR=#007700]();
[/COLOR][COLOR=#0000BB]session_destroy[/COLOR][COLOR=#007700]();
[/COLOR][COLOR=#0000BB]?>[/COLOR] [/COLOR] [/CENTER]
[CENTER]
[IMG]file:///D:/%D9%84%D8%AA%D8%B9%D9%84%D9%8A%D9%85%20%D8%A7%D9%8 6%D8%B4%D8%A7%D8%A1%20%D9%85%D9%88%D8%A7%D9%82%D8% B9%20%D8%A7%D9%84%D9%88%D9%8A%D8%A8/%D8%A8%D8%B9%D8%B6%20%D8%B5%D9%81%D8%AD%D8%A7%D8%A A%20%D8%A7%D9%84%D9%88%D9%8A%D8%A8%20%D8%A7%D9%84% D9%85%D9%87%D9%85%D8%A9/%D8%AF%D8%B1%D8%B3%20-%20%D8%B9%D9%85%D9%84%20%D8%B5%D9%81%D8%AD%D8%A9%2 0%D8%AA%D8%B3%D8%AC%D9%8A%D9%84%20%D8%AF%D8%AE%D9% 88%D9%84%20login%20-%20%D8%B3%D9%88%D8%A7%D9%84%D9%81%20%D8%B3%D9%88%D 9%81%D8%AA_files/db_members.gif[/IMG]
6- أنشاء ملف [B]checklogin.php في حال اصدار PHP 5 وطبعا هو الافضل [/B]
كود PHP:
[/CENTER]
[CENTER] [COLOR=#000000] [COLOR=#0000BB]<?php
ob_start[/COLOR][COLOR=#007700]();
[/COLOR][COLOR=#0000BB]$host[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"localhost"[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Host name
[/COLOR][COLOR=#0000BB]$username[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Mysql username
[/COLOR][COLOR=#0000BB]$password[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]""[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Mysql password
[/COLOR][COLOR=#0000BB]$db_name[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"test"[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Database name
[/COLOR][COLOR=#0000BB]$tbl_name[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"members"[/COLOR][COLOR=#007700]; [/COLOR][COLOR=#FF8000]// Table name
// Connect to server and select databse.
[/COLOR][COLOR=#0000BB]mysql_connect[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"$host"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]"$username"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]"$password"[/COLOR][COLOR=#007700])or die([/COLOR][COLOR=#DD0000]"cannot connect"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]mysql_select_db[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"$db_name"[/COLOR][COLOR=#007700])or die([/COLOR][COLOR=#DD0000]"cannot select DB"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#FF8000]// Define $myusername and $mypassword
[/COLOR][COLOR=#0000BB]$myusername[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]$_POST[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'myusername'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#0000BB]$mypassword[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]$_POST[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'mypassword'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#FF8000]// To protect MySQL injection (more detail about MySQL injection)
[/COLOR][COLOR=#0000BB]$myusername [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]stripslashes[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$myusername[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$mypassword [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]stripslashes[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$mypassword[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$myusername [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_real_escape_string[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$myusername[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$mypassword [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_real_escape_string[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$mypassword[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$sql[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#DD0000]"SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]$result[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$sql[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#FF8000]// Mysql_num_row is counting table row
[/COLOR][COLOR=#0000BB]$count[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]mysql_num_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$result[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#FF8000]// If result matched $myusername and $mypassword, table row must be 1 row
[/COLOR][COLOR=#007700]if([/COLOR][COLOR=#0000BB]$count[/COLOR][COLOR=#007700]==[/COLOR][COLOR=#0000BB]1[/COLOR][COLOR=#007700]){
[/COLOR][COLOR=#FF8000]// Register $myusername, $mypassword and redirect to file "login_success.php"
[/COLOR][COLOR=#0000BB]session_register[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"myusername"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]session_register[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"mypassword"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]header[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"location:login_success.php"[/COLOR][COLOR=#007700]);
}
else {
echo [/COLOR][COLOR=#DD0000]"خطأ في اسم المستخدم او كلمة المرور"[/COLOR][COLOR=#007700];}
[/COLOR][COLOR=#0000BB]ob_end_flush[/COLOR][COLOR=#007700]();
[/COLOR][COLOR=#0000BB]?>[/COLOR] [/COLOR] [/CENTER]
[CENTER]
[/CENTER]
[/CENTER]