��ҹ��Ǣ�͡�͹˹�� :: ��ҹ��Ǣ�ͶѴ� |
����� |
��ͤ��� |
ryuozero Site Admin
�������: 13 Jul 2005 �ͺ: 1145
|
|
���仢�ҧ�� |
|
|
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 ��Ѻ����Ѻ�鴹�� |
|
���仢�ҧ�� |
|
|
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();
}
?> |
|
|
���仢�ҧ�� |
|
|
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%' "; |
|
|
���仢�ҧ�� |
|
|
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 ��з������ҼԴ��Ҵ�� �ѧ�����Ҥ����� () �����¹Ф�Ѻ
�����¹��ä��Ң����Ũҡ�ҹ���������ͧ�� ������ѡ���Ẻ����Ѻ �ͧ�Ѵ�ӡѹ�ٹФ�Ѻ ���ǡ��������ء���ԧ�����¤�Ѻ �ҡ�դ����ӹÒ���� |
|
���仢�ҧ�� |
|
|
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" ��Ѻ |
|
���仢�ҧ�� |
|
|
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"> </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"); ?> |
|
|
���仢�ҧ�� |
|
|
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> |
|
|
���仢�ҧ�� |
|
|
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;
?> |
|
|
���仢�ҧ�� |
|
|
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 |
|
|
���仢�ҧ�� |
|
|
|