�����������֡��
A little text to describe your forum 
¤ÍÁ¾ÔÇàµÍÃìÈÖ¡ÉÒ  
 ÊÁѤÃÊÁÒªÔ¡(Register)��Ѥ���Ҫԡ(Register) 
 ªèÇÂàËÅ×Í���������   ¤é¹ËÒ����   ÃÒª×èÍÊÁҪԡ��ª�����Ҫԡ   ¡ÅØèÁ¼Ùéãªé���������� 
 ¢éÍÁÙÅÊèǹµÑÇ(Profile)��������ǹ���(Profile)   à¢éÒÊÙèÃкºà¾×èÍàªç¤¢éͤÇÒÁÊèǹµÑÇ�������к������礢�ͤ�����ǹ���   à¢éÒÊÙèÃкº(Log in)�������к�(Log in) 
php ��Ͱҹ������

 
Forum ¹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöµÍº ËÃ×Íá¡éä¢ä´é   ËÑÇ¢é͹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöá¡éä¢ ËÃ×͵ͺä´é    ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ö¡ï¿½ï¿½ -> +�+WEB+�+
��ҹ��Ǣ�͡�͹˹�� :: ��ҹ��Ǣ�ͶѴ�  
����� ��ͤ���
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Thu Jul 12, 2007 3:27 am    ï¿½ï¿½ï¿½ï¿½Í§: php ��Ͱҹ������ µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

appser 5.10
Dreamwaever �ҹ������

�١���ٹ
�ѹ ��͹ ��
http://www.thaimisc.com/r/view.php?id=507&category=
http://www.webthaidd.com/php/
http://webboard.plaloma3d.com/forumdisplay.php?fid=38

http://www.dwthai.com/dreamweaver/click_webboard_02.htm

�͹ Dreamwaever
http://www.funwhan.com/learn/
ICT-WEB
Com-IT
PHP MySQL Connect

���觤�������������


�������ش�� ryuozero ����� Fri Feb 19, 2010 8:50 am, ������ 16 ����
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Thu Oct 18, 2007 8:18 am    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

��� uploads �ٻ�Ҿŧ�ҹ������ Mysql



�ǻᨡʤ�Ի���
http://www.hotscripts.com/category/php/script-programs/
http://php.deeserver.net/phpbb/
http://www.thai-programmer.com

pdf
http://www.mindphp.com/modules.php?name=News&file=article&sid=22
http://www.thaicreate.com/php/php-export-pdf.html
http://www.tcpdf.org/
http://th.php.net/pdf
http://www.fpdf.org


���ҧ��� PDF ���� PHP
�դ�����ѹ�����������Ѻ������ҧ PDF ��� ���͡���ʴ� PDF ����� �¡�ô֧�ҡ�ҹ������ �����鴹���Ҩҡ http://www.thai-programmer.com/?DPage=25 ��Ѻ ��ҹ��������´�������������

Font ������
Font ���������������� Font ��� �س���ѵԷ���բͧ Font ���� ��ǻ��� ���˹� ������§ ���˹����§ ����� 4 �س���ѵ� ����Ѻ �ҧ Font ����դس���ѵ����ú��� 4 ���ҧ �ѧ��� Font ���е�� �դس���ѵԴѧ����Ѻ

CordiaNew �� ��ǻ��� ���˹� ������§ ���˹����§
AngsanaNew �� ��ǻ��� ���˹� ������§ ���˹����§
Tahoma �� ��ǻ��� ���˹�
BrowalliaNew �� ��ǻ��� ���˹� ������§ ���˹����§
KoHmu �� ��ǻ���
KoHmu2 �� ��ǻ���
KoHmu3 �� ��ǻ���
MicrosoftSansSerif �� ��ǻ���
PLE_Cara �� ��ǻ���
PLE_Care �� ��ǻ��� ���˹�
PLE_Joy �� ��ǻ���
PLE_Tom �� ��ǻ��� ���˹�
PLE_TomOutline �� ��ǻ���
PLE_TomWide �� ��ǻ���
DilleniaUPC �� ��ǻ��� ���˹� ������§ ���˹����§
EucrosiaUPC �� ��ǻ��� ���˹� ������§ ���˹����§
FreesiaUPC �� ��ǻ��� ���˹� ������§ ���˹����§
IrisUPC �� ��ǻ��� ���˹� ������§ ���˹����§
JasmineUPC �� ��ǻ��� ���˹� ������§ ���˹����§
KodchiangUPC �� ��ǻ��� ���˹� ������§ ���˹�����
LilyUPC �� ��ǻ��� ���˹� ������§ ���˹����§

������ҧ��á�˹� Font
$pdf->SetFont('LilyUPC','',16); //�繡�á�˹� Font LilyUPC ��ǻ��� ��Ҵ 16
$pdf->SetFont('LilyUPC','B',16); //�繡�á�˹� Font LilyUPC ���˹� ��Ҵ 16
$pdf->SetFont('LilyUPC','I',16); //�繡�á�˹� Font LilyUPC ������§ ��Ҵ 16
$pdf->SetFont('LilyUPC','IB',16); //�繡�á�˹� Font LilyUPC ���˹����§ ��Ҵ 16

��ǹ������ output ����ö��˹�������Ẻ��Ѻ ��
$pdf->Output(); //�繡�á�˹�����ʴ� PDF ��������������� (���͡�˹� flag �� 'I')
$pdf->Output('test.pdf','F'); //�繡�á�˹����ѹ�֡���������麹 server 㹪��� test.pdf (��˹� flag �� 'F')
$pdf->Output('test.pdf','D'); //�繡�á�˹����ʹ�ǹ���Ŵ��Ѻ (��˹� flag �� 'D')
echo $pdf->Output('','S'); //�繡�á�˹����ͤ׹����� string ��Ѻ (�� IE ����ö�ʴ��� PDF ������Ѻ)


(322)
�͢ͺ�س http://www.thai-programmer.com ��Ѻ����Ѻ�鴹��
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Tue Mar 24, 2009 11:55 am    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

INSERT


Code:
<?php

if(isset($_POST['submit']))
   process();
   else
   showform();

 

   function showform()
   {

print <<<_HTML_
<center><h1> INSERT  </h1></center>

<form name = "insertForm" method="post" action="$_SERVER[PHP_SELF]">
ID :  <input name="txtid" type="text" />
Name :  <input name="txtname" type="text" /><br/>
<input type="submit" name="submit" value="Insert" />
</form>
_HTML_;

   }


function process()
{


$host="localhost";
$dbname="studentdb";
$user="root";
$pass="root";


$db = new mysqli($host, $user, $pass, $dbname);


/* check connection */
if (mysqli_connect_errno()) {
    die("Unable to connect!");
}

$id=empty($_POST['txtid'])? die ("ERROR : Enter a ID"): $db->real_escape_string($_POST['txtid']);
$name=empty($_POST['txtname'])? die ("ERROR : Enter a Name"): $db->real_escape_string($_POST['txtname']);

$query = "INSERT INTO student VALUES('$id','$name')";
$result = $db->query($query)or die("Error in Query".$db->error);

echo "Insert ���º����";

$db->close();

 


}
?>





UPDATE


Code:
<?php

if($_POST['submit']=='Update')
   process();
   else
   showform();


   function showform()
   {

print <<<_HTML_
<center><h1>UPDATE </h1></center>

<form name = "UpdateForm" method="post" action="$_SERVER[PHP_SELF]">
Update ID :  <input name="txtid" type="text" />
Change Name :  <input name="txtname" type="text" /><br/>
<input type="submit" name="submit" value="Update" />
</form>
_HTML_;

   }


function process()
{


 
$host="localhost";
$dbname="studentdb";
$user="root";
$pass="root";


$db = new mysqli($host, $user, $pass, $dbname);


/* check connection */
if (mysqli_connect_errno()) {
    die("Unable to connect!");
}

$id=empty($_POST['txtid'])? die ("ERROR : Enter a ID"): $db->real_escape_string($_POST['txtid']);
$name=empty($_POST['txtname'])? die ("ERROR : Enter a Change Name"): $db->real_escape_string($_POST['txtname']);

$query = "UPDATE student SET name = '$name' where id ='$id'";
$result = $db->query($query)or die("Error in Query".$db->error);

echo "Update ���º����";

$db->close();

 

}
?>



DELETE
Code:
<?php

if(isset($_POST['submit']))
   process();
   else
   showform();


   function showform()
   {

print <<<_HTML_
<center><h1> DELETE </h1></center>

<form name = "DeleteForm" method="post" action="$_SERVER[PHP_SELF]">
Delete ID :  <input name="txtid" type="text" />

<input type="submit" name="submit" value="Delete" />
</form>
_HTML_;

   }


function process()
{

 

 

$host="localhost";
$dbname="studentdb";
$user="root";
$pass="root";


$db = new mysqli($host, $user, $pass, $dbname);


/* check connection */
if (mysqli_connect_errno()) {
    die("Unable to connect!");
}

$id=empty($_POST['txtid'])? die ("ERROR : Enter a ID"): $db->real_escape_string($_POST['txtid']);

$query = "Delete from student  where id ='$id'";
$result = $db->query($query)or die("Error in Query".$db->error);

echo "Delete ���º����";

$db->close();


}
?>





SELECT


Code:
<?php
   showform();


   
  function showform()
{


$host="localhost";
$dbname="studentdb";
$user="root";
$pass="root";


$db = new mysqli($host, $user, $pass, $dbname);


/* check connection */
if (mysqli_connect_errno()) {
    die("Unable to connect!");
}

$query = "select * from student";
if($result = $db->query($query))
{

 

 if($result->num_rows>0)
 {
  echo "<table><tr><th>ID</th><th>NAME</th></tr>";
  $i = 0;
  while ($row = $result->fetch_array())
   {
   
     if($i%2 ==0)
      echo "<tr bgcolor='#99CCFF'><td>".$row['id']."</td><td>".$row['name']."</td></tr>";
     else
       echo "<tr><td>".$row['id']."</td><td>".$row['name']."</td></tr>";
     $i++;
   }

 
  echo "</table>";
 }

 $result->close();
}
else
 echo "Error in query : $query. ".$db->error;

 

$db->close();

 

}
?>




SEARCH


Code:
<?php

 if(isset($_POST['submit']))
   process();
   else
   showform();


   function showform()
   {

print <<<_HTML_
<center><h1> SEARCH</h1></center>

<form name = "SearchForm" method="post" action="$_SERVER[PHP_SELF]">
ID :  <input name="txtid" type="text" />

<input type="submit" name="submit" value="Search" />
</form>
_HTML_;

   }


function process()

{

$host="localhost";
$dbname="studentdb";
$user="root";
$pass="root";


$db = new mysqli($host, $user, $pass, $dbname);


/* check connection */
if (mysqli_connect_errno()) {
    die("Unable to connect!");
}

$id=empty($_POST['txtid'])? die ("ERROR : Enter a ID"): $db->real_escape_string($_POST['txtid']);

$query = "select * from student where id like '%$id%'";
if($result = $db->query($query))
{

 

 if($result->num_rows>0)
 {
  echo "<table><tr><th>ID</th><th>NAME</th></tr>";
  $i = 0;
  while ($row = $result->fetch_array())
   {
   
     if($i%2 ==0)
      echo "<tr bgcolor='#99CCFF'><td>".$row['id']."</td><td>".$row['name']."</td></tr>";
     else
       echo "<tr><td>".$row['id']."</td><td>".$row['name']."</td></tr>";
     $i++;
   }

 
  echo "</table>";
 }
 else
  echo "Not Found Data";

 $result->close();
}
else
 echo "Error in query : $query. ".$db->error;

 

$db->close();

 

}
?>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Tue Mar 24, 2009 11:58 am    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

Search


��ҧ�ԧ�ҡ:
$sql = " SELECT * FROM ���͵��ҧ WHERE ���Ϳ�Ŵ� LIKE '%���͵����%' ";

���͵���ä�ͪ��ͧ͢ input ������͡ keyword �Ѻ ��

$sql = " SELECT * FROM db_member WHERE id LIKE '%$keyword%' ";
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Tue Mar 24, 2009 12:02 pm    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

�����¹����� Search

���ʴդ�Ѻ 㹺����¹�����Ҩ��Ҵ��Ըա�� 㹡����¹��������ҡѹ�ٹФ�Ѻ �������ѡ�������ç���ҧ���ҧ�� ��ä��Ң����Ź�����ٻẺ���ᵡ��ҧ�ѹ�͡� ��蹡�������Ѻ�����ҹ��Ѻ ��ҨФ������� ����Ẻ�˹

�����¹���������������Ըա�ä���Ẻ���������繾�鹰ҹ���ء����Ѳ�ҵ��� ���ͧ�֡�Ҵ� ��觨��繡�ä��Ҩҡ�ҹ�����ŹФ�Ѻ

�ͧ�ٵ�����ҧ��Ѻ

(�ҡ������ҧ��� ����ͧ�ͧ�ç���ҧ�ҹ������ ���ҧ ��п�Ŵ�Ẻ��ҧ�ж١��ҧ�ԧ�Ҩҡ�����¹����ͧ ��ش���������Ф�Ѻ �ѧ��鹵�����ҧ��� ���͡�ä��Ҩҡ�ҹ��������ش�������� �繵�����ҧ���س���ͧ��任���ء����� �������ѧ�������ç���ҧ���ͧ��͹��Ѻ仴��ç���ҧ��ҹФ�Ѻ)

��������繿����㹡�ä���

form_search.html

<form action="search.php" method="post">
��ͤ��������㹡�ä��� <input type="text" name="search">
<input type="submit">
</form>

��ͤ��������㹡�ä���
.....................................................................................................................

��������Ǩ�ͺ��л����Թ�š�ä���

search.php

<?php

if(isset($search)) { // �ҡ����յ���� search ����͡�Ҩҡ�����

// ������Դ��Ͱҹ������

$host = "localhost" ;
$user = "test" ;
$password = "1234" ;
$db = "guestbook" ;
$connect = mysql_connect($host,$user,$password) ; // �Դ��Ͱҹ������
mysql_select_db($db) ; // ���͡�ҹ������㹡����ҹ

//�ӡ�ä������� like ���º��º �¤��Ҩҡ��Ŵ� message
$sql = "select * from guestbook where message like '%$search%' " ;

// �ӡ�� query �����
$result = mysql_query($sql) or die ("�������ö query ��������Ѻ") ;

// ��Ǩ�ͺ��ä���
if($result) {

// ��Ҥ��Ҥӷ���ͧ�����辺
$num = mysql_num_rows($result) ; // ��Ǩ�ͺ�ӹǹ�Ƿ�����
if($num==0) {
echo "��辺�ӷ���ͧ��ä��Ҥ�Ѻ" ;
}
// �ҡ��Ҩӹǹ���ҡ���� 0 ��ͤ�����
else {

// ������ mysql_fetch_array() ; 㹡���纤�Ҩҡ��Ŵ�Ẻ array ŧ㹵���� $dbarr
while($dbarr = mysql_fetch_array($result)) {

$name = $dbarr['name'] ;
$email = $dbarr['email'] ;
$message = $dbarr['message'] ;

// �Ӣ����ŷ������������§���к�÷ѴẺ�����
echo "���ӷ����Ҩӹǹ������ $num ��ͤ���" ;
echo "<br>�����ŷ��鹾�" ;
echo "<br>���� $name" ;
echo "<br>email $email" ;
echo "<br>��ͤ��� $message" ;

} // �� while

} // �� Else

} // �� if($result)

}

�����ҧ�ú�ҧ��Ѻ ����ҡ�������Ѻ ���м��� comment (//) ���������Ǵ��� ������Т�鹵͹��� �ͧ������֡�Ҩҡ�Ըա�ç������ٹФ�Ѻ ���ǹ�任���ء����Ѻ���ҧ ���Ͱҹ������������� ������¹�Ըա�������ٻẺ�Դ˹���

�����ͧ�١�ä��ҵ���� 2 ��Ŵ���仹Ф�Ѻ

�ҡ����觡�� select Ẻ���͡���Ҩҡ��Ŵ����� �չ������ͧ�Ҵ�Ẻ������Ŵ� ����ҡ��¤�Ѻ ��§��������Ŵ���Ф������� �������������١��ͧ��ҹ���ͧ �ͧ�١ѹ��¹Ф�Ѻ

�ҡ�������� $sql = "select * from guestbook where message like '%$search%' " ;

������Ŵ��������ͧ��ä���

$sql = "select * from guestbook where((name like '%$search%') or (email like '%search%') or ($message like '%$search%')) " ;

�Ըա�á����Ẻ����Ѻ ** �������Ҥ�è��������ͧ����ǧ��� () ������������� �������ҧ������Ҥ����ѹ������ç������͹� �Ф����ѹ���� �ҡ���͹��ҡ���ҹ���Ф�Ѻ �蹡ó����� category ��з������ҼԴ��Ҵ�� �ѧ�����Ҥ����� () �����¹Ф�Ѻ

�����¹��ä��Ң����Ũҡ�ҹ���������ͧ�� ������ѡ���Ẻ����Ѻ �ͧ�Ѵ�ӡѹ�ٹФ�Ѻ ���ǡ��������ء���ԧ�����¤�Ѻ �ҡ�դ����ӹҭ����
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Fri Apr 03, 2009 3:07 am    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

�Ӷ��
��ͧ����ʴ��ѹ����������¤��

�� "�ء�� 30 �չҤ� 2550"

�е�ͧ�����ҧ�ä�





�ӵͺ�ҡ PHP Assistant
����ͧ���鴴ѧ���仹���Ѻ

<?php

//��˹��ѹ���
$date = date("l");
switch($date)
{
case "Monday":
$printdate = "�ѹ���";
break;
case "Tuesday":
$printdate = "�ѧ���";
break;
case "Wednesday":
$printdate = "�ظ";
break;
case "Thursday":
$printdate = "����ʺ��";
break;
case "Friday":
$printdate = "�ء��";
break;
case "Saturday":
$printdate = "�����";
break;
case "Sunday":
$printdate = "�ҷԵ��";
break;
}

//��˹���͹
$month = date("n");

switch($month)
{
case "1":
$printmonth = "���Ҥ�";
break;
case "2":
$printmonth = "����Ҿѹ��";
break;
case "3":
$printmonth = "�չҤ�";
break;
case "4":
$printmonth = "����¹";
break;
case "5":
$printmonth = "����Ҥ�";
break;
case "6":
$printmonth = "�Զع�¹";
break;
case "7":
$printmonth = "�á�Ҥ�";
break;
case "8":
$printmonth = "�ԧ�Ҥ�";
break;
case "9":
$printmonth = "�ѹ��¹";
break;
case "10":
$printmonth = "���Ҥ�";
break;
case "11":
$printmonth = "��Ȩԡ�¹";
break;
case "12":
$printmonth = "�ѹ�Ҥ�";
break;
}

//�ʴ����Ѿ��
echo "$printdate ".date("d")." $printmonth ".(date("Y")+543)."";

?>

���Ѿ���������� "�ء�� 30 �չҤ� 2550" ��Ѻ
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Fri Apr 17, 2009 11:56 am    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

��ҧ�ԧ�ҡ:

��躹�ش
Code:
<?php  if (!isset($_SESSION)) { session_start(); } $dir="" ?>




���ٵ���Է���
��ҧ�ԧ�ҡ:
<?php switch($_SESSION['MM_UserRight']){
case 'Admin' : ?>
<td height="40"><img src="images/bgtool_01.gif" alt="" width="99" height="40" /><img src="images/bgtool_02.gif" alt="" width="114" height="40" /><img src="images/bgtool_03.gif" alt="" width="114" height="40" /><img src="images/bgtool_04.gif" alt="" width="114" height="40" /><img src="images/bgtool_05.gif" alt="" width="114" height="40" /><img src="images/bgtool_06.gif" alt="" width="114" height="40" /><img src="images/bgtool_07.gif" alt="" width="114" height="40" /><img src="images/bgtool_08.gif" alt="" width="114" height="40" /><img src="images/bgtool_09.gif" alt="" width="114" height="40" /></td>
<?php break;
default : ?>
<td height="40" background="images/bgtool_09.gif">&nbsp;</td>
<?php break;
} ?>

</tr>
<TR>
<TD><table width="100%" border="0" cellspacing="0" cellpadding="0">
<!--DWLayoutTable-->

<tr>
<td colspan="3" rowspan="6" valign="top" bgcolor="#CCCCCC">
<table width="175" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/block_x01.jpg" width="175" height="12" /></td>
</tr>
<tr>
<td width="175" height="28" background="images/block_x02.jpg"><div align="center" class="sta_coment">����</div></td>
</tr>
<tr>
<td></td>
</tr>
<tr " background="images/block_x04.jpg">
<td align="left" background="images/block_x04.jpg"> <?php if(strstr($_SERVER['PHP_SELF'], "ryuozero.html") == ""){ $dir = "../"; }
if (!empty($_SESSION['MM_UserName']))
require_once($dir."Member/form_logout.php");
else
require_once($dir."Member/form_login.php"); ?>




����ʶҹ�(��ǹlogin)
Code:
<?php  if(strstr($_SERVER['PHP_SELF'], "ryuozero.html") == ""){ $dir = "../"; }
      if (!empty($_SESSION['MM_UserName']))
         require_once($dir."Member/form_logout.php"); 
        else
           require_once($dir."Member/form_login.php"); ?>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Fri Apr 17, 2009 3:01 pm    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

��������˹�����

��ҧ�ԧ�ҡ:
print("<meta http-equiv=refresh content=5;URL=index.html />");


���������ͧ�ѹ˹���ǻ
��ҧ�ԧ�ҡ:
<?php include ('protec.php'); ?>


����� login
��ҧ�ԧ�ҡ:
<form action="login_1.php" method="POST" name="fmLogin" id="fmLogin">
<table width="50%" border="1" cellspacing="1" cellpadding="3">
<tr>
<th align="center" scope="col">username</th>
<th width="77%" align="left" scope="col"><input type="text" name="u" id="u" /></th>
</tr>
<tr>
<td align="center">password</td>
<td align="left"><input type="text" name="p" id="p" /></td>
</tr>
<tr>
<td align="center"><input type="submit" name="button" id="button" value="login" /></td>
<td align="left"><input type="reset" name="button2" id="button2" value="cancel" /></td>
</tr>
</table>
</form>




protec.php
��ҧ�ԧ�ҡ:
<title>protect</title><?
if($active!="ok")
{
print("username ���� password �Դ��Ҵ!!");
exit();
}
?>



��Ǩ�ͺ������ҧ��ꡡ��
��ҧ�ԧ�ҡ:
<?
if ($u!="" && $p!="")
{
$link=mysql_connect("localhost","root","zeromaster");
mysql_select_db("kalasin",$link);
$sql="select * from tbluser where UserName='$u' and Password='$p'";
$result=mysql_query($sql,$link);
$row=mysql_num_rows($result);
if($row >= 1)
{
setcookie( "active" , "ok" );
setcookie( "username", "$u");
setcookie( "password", "$p");
print("Now 2 cookies has been created.");
print("<a href=display.php>����§ҹ</a><br>");
print("<a href=news.php>����������</a><br>");
}
else
print("Error login");
}
else
{
print("Error no any data!!<br>");
print("Please login first.<a href=login.php>��Ѻ�����</a><br>");
}
?>


�͡�ҡ�к�
Code:
<?
if ($active!="ok"){
print("you didn't login properly.");
exit();
}
else{
setcookie("active");
setcookie("username");
setcookie("password");
print("Log out Ok");
}
?>
<hr /><a href="login.html">Log in</a>
</body>
</html>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Tue Apr 21, 2009 5:54 am    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

��˹�������Ѻ�����

Code:
<?
$step_1=date("d/m/");
$step_2=date("Y")+543;
$_REQUEST['anyday']=$step_1.$step_2;
?>
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
ryuozero
Site Admin


�������: 13 Jul 2005
�ͺ: 1145

µÍºï¿½Íºï¿½ï¿½ï¿½ï¿½ï¿½: Sun May 31, 2009 1:12 pm    ï¿½ï¿½ï¿½ï¿½Í§: µÍºâ´ÂÍéÒ§¢éͤÇÒÁ

Code:
SELECT *
FROM data_form
WHERE data_form.`Group`='�ӹѡ��ҧ' AND data_form.data_dat LIKE '___05%' AND data_form.YES_NO='�������'
ORDER BY data_form.ID_IN DESC
���仢�ҧ��
´Ù¢éÍÁÙÅÊèǹµÑÇ Ê觢éͤÇÒÁÊèǹµÑÇ Êè§ Email
���§�ӴѺ��ͤ����ͺ�ҡ��͹˹��:   
Forum ¹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöµÍº ËÃ×Íá¡éä¢ä´é   ËÑÇ¢é͹Õé¶Ù¡ÅçÍ¡ ¤Ø³äÁèÊÒÁÒöá¡éä¢ ËÃ×͵ͺä´é    ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ö¡ï¿½ï¿½ -> +�+WEB+�+ ��Ѻ���� GMT
˹�� 1 �ҡ 1

 
价��:  
�س�������ö���ҧ��Ǣ������
�س�������ö�����ͺ
�س�������ö��䢢�ͤ����ͧ�س
�س�������öź��ͤ����ͧ�س
�س�������öŧ��ṹ


Powered by phpBB © 2001 phpBB Group
-- Template created by dav.bo=> PurpleStylus --


For Support - http://forums.BizHat.com

Free Web Hosting | Free Forum Hosting | FlashWebHost.com | Image Hosting | Photo Gallery | FreeMarriage.com

Powered by PhpBBweb.com, setup your forum now!