 |
|

นี่เป็นตัวอย่างโค้ดค่ะ หนูก็ไม่รู้อะไรมากค่ะ เพราะเอาตัวอย่างในเว็บมาค่ะ
Code (PHP)
<?php
//============== Function 㹡ÒÃá·Ã¡¢éÍÁÙÅ ==============
function insert($field,$value,$table)
{
$sql = "INSERT INTO $table ($field) VaLUES ($value)";
//echo $sql;
$result= mysql_query($sql);
return $result;
}
//============== Function 㹡ÒÃź¢éÍÁÙÅ ==============
function delete($table,$condition)
{
$sql ="delete from $table $condition";
$result = mysql_query($sql);
return $result;
}
//=============== Function 㹡ÒÃá¡é䢢éÍÁÙÅ ==================
function update($table,$command,$condition)
{
$sql = "UPDaTE $table SET $command $condition";
$result = mysql_query($sql);
return $result;
}
//=============== Function 㹡ÒÃàÅ×Í¡¢éÍÁÙÅ ==================
function select($table,$condition)
{
$sql = "select * from quiz where id_question='" . $id_question . "' ";
$sql = "select * from $table $condition";
//echo $sql;
$dbquery = mysql_query($sql);
$result= mysql_fetch_array($dbquery);
return $result;
}
//=============== Function 㹡ÒÃàÅ×Í¡¢éÍÁÙÅ·Ñé§ËÁ´ ==================
function selectalldate($table,$condition,$listby)
{
$sql = "select * from $table $condition $listby";
//echo $sql;
$dbquery = mysql_query($sql);
return $dbquery;
}
//=============== select Reccord Max or Min================== // ÍÒ¨¨Ðãªé㹡Òà ´Ö§ ੾ÒпÔÇÊì ËÃ×ÍÃÇÁ¤èÒ ¹Ñº¤èÒ
function selectMaxOrMin($maxormin,$field,$table,$condition)
{
$sql = "select $maxormin($field) as $field from $table $condition";
$dbquery = mysql_query($sql);
$result= mysql_fetch_array($dbquery);
return $result;
}
//=============== Function 㹡ÒÃàÅ×Í¡¢éÍÁÙÅ==================
function selectFistOrLast($table,$condition,$fieldlist,$bylist)
{
$sql = "select * from $table $condition order by $fieldlist $bylist";
$dbquery = mysql_query($sql);
$result= mysql_fetch_array($dbquery);
return $result;
}
//=============== Function 㹡ҵÃǨÊͺµÑÇÍÑ¡ÉâéÍÁÙÅ ==================
function checkcharector($temp)
{
$temp=Trim(eregi_replace ( "'" , "" , $temp));
$temp=Trim(eregi_replace ( "\"" , """ , $temp));
return $temp;
}
//=============== Function 㹡ÒùѺ¨Ó¹Ç¹á¶Ç ==================
function num_record($table,$condition)
{
$sql = "select * from $table $condition";
$dbquery = mysql_query($sql);
$num_rows = mysql_num_rows($dbquery);
return $num_rows;
}
//=============== Function 㹡ÒùѺµÃǨÊͺ¤èÒÇèÒ§ ==================
function JscheckValueNull($form,$field,$msg)
{
echo"\nif(trim(document.$form.$field.value)=='')\n";
echo"{\n";
echo"alert('$msg');\n";
echo"document.$form.$field.focus();\n";
echo"return false;\n";
echo"}\n\n";
}
?>
Tag : PHP, MySQL, CakePHP
|
ประวัติการแก้ไข 2012-03-24 23:05:39 2012-03-24 23:07:26
|
 |
 |
 |
 |
Date :
2012-03-24 23:02:18 |
By :
taman442 |
View :
1077 |
Reply :
5 |
|
 |
 |
 |
 |
|
|
|
 |