 |
|
Code (PHP)
<?php @session_start();
////////////////////////////////////////////////////////////////////////
define('DBHost', 'localhost');
define('DBUser', 'xxxxxxxxx');
define('DBPassword', 'yyyyyyy');
define('DBName', 'zzzzzzzzzzz');
define('my_db_link', mysql_connect( DBHost, DBUser, DBPassword));
if(my_db_link===false)
{ echo 'Connection failer<BR><a href="'.$PHP_SELF.'?'.$QUERY_STRING.'">Refresh</a>'; exit; }
$chk=false;
mysql_select_db( DBName, my_db_link) or die( 'ยังไม่เปิดให้ใช้บริการ');
mysql_query('SET CHARACTER SET utf8', hk_db_link);
mysql_query("SET collation_connection = 'utf8_unicode_ci' ", hk_db_link);
mysql_query('SET chracter_set_results=utf8',hk_db_link);
////////////////////////////////////////////////////////////////////////
function pageLogin(){
return '
<form method="post" >
<table border="0" cellpadding="0" cellspacing="0">
<tr><th colspan="2" bgcolor="#999999">Login Page</th></tr>
<tr><td width="80" align="right">User Name </td><td width="120"><input type="text" name="UserName" style="width: 98%" /></td></tr>
<tr><td width="80" align="right">Password </td><td width="120"><input type="password" name="Password" style="width: 98%" /></td></tr>
<tr><td></td><td><input type="submit" name="run" value="Login" /></td></tr>
</table>
</form>';
}
function pageData(){
$rs= mysql_query("select * from data where dataID = '$_SESSION[Profile][dataID]' ");
$tr='<table border="1" cellspacing="2" cellpadding="2" style="width:600px" >
<tr><th width="80">DataID</th><th width="80">Serial Number</th><th width="120">Name</th><th width="120">Sur-Name</th><th>Identification</th></tr>';
while($ro = mysql_fetch_array($result) ){
$tr .= '<tr>'.
"<td>$ro[dataID]</td>".
"<td>$ro[serialnumber]</td>".
"<td>$o[name]</td>".
"<td>$ro[surname]</td>".
"<td>$ro[indentification]</td>".
'</tr>';
}
mysql_free_result($rs);
return $tr.'</table>';
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>TEST LOGIN</title>
</head>
<body>
<?php
if(isset($_REQUEST['run'])){
switch($_REQUEST['run']){
case 'Login':
$qr='Select * from login '.
' where user=\''.addslashes($_REQUEST['UserName']).'\' '.
' and password=\''.addslashes($_REQUEST['Password']).'\' '.
' limit 1';
$rs=mysql_query($qr, my_db_link);
if(!rs || mysql_num_rows($rs)==0) echo pageLogin();
else{
$_SESSION['Profile']=mysql_fetch_assoc($rs); mysql_free_result($rs);
echo pageData();
}
break;
case 'Logout':
// do U want
break;
}
}else{
echo pageLogin();
}
?>
</body>
</html>
|
 |
 |
 |
 |
| Date :
2014-07-10 06:32:13 |
By :
Chaidhanan |
|
 |
 |
 |
 |
|
|
 |
