|
 |
| |
ใครมีโค๊ต class connect db mysql mssql ใครมีโค๊ต class connect db mysql mssql บางครับ ถ้าจะให้ดีช่วยอธิบายคำสั่งใน class |
| |
 |
|
|
 |
 |
|
ฝึกเขียน ถ้าติดปัญหาค่อยถามดีกว่าไม๊
|
 |
 |
 |
 |
| Date :
3 ก.พ. 2551 21:57:22 |
By :
ฟหกดฟหก |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
function OpenConnectDB($host, $login, $passwd, $db) {
$dbconnection = mysql_connect($host, $login, $passwd);
if (!mysql_select_db($db)) {
echo "Unable to select mydbname: " . mysql_error();
exit;
}
//if(!$dbconnection) { echo("Database Connection Error"); break;}
return $dbconnection;
}
function exeSQL($sqlstatement) {
$result = mysql_query($sqlstatement) or die("Invalid query: " . mysql_error());
//echo($sqlstatement . "<br>");
if(!$result) {
echo($sqlstatement . "<br>");
var_dump($result);
exit();
}
return $result;
}
function CloseConnectDB($connect) {
mysql_close($connect);
}
function getQueryColumnsName($sqlResult) {
$iCoumns = mysql_num_fields($sqlResult);
$sReturn = "";
for($i = 0; $i < $iCoumns; $i++) {
$sReturn .= mysql_field_name($sqlResult, $i) . ",";
}
return substr($sReturn, 0 , -1);
}
function ValueList($sqlResult, $delimit) {
$iCoumns = mysql_num_fields($sqlResult);
$sReturn = "";
while ($row = mysql_fetch_assoc($sqlResult)) {
for($i = 0; $i < $iCoumns; $i++) {
$sReturn .= $row[mysql_field_name($sqlResult, $i)] . ",";
}
$sReturn .= $delimit;
}
return substr($sReturn, 0 , -1);
}
function ListOnlyField($sqlResult, $field, $delimit) {
$iCoumns = mysql_num_fields($sqlResult);
$sReturn = "";
while ($row = mysql_fetch_assoc($sqlResult)) {
$sReturn .= $row[$field] . $delimit;
}
return substr($sReturn, 0 , -1);
}
//เรียกฟังก์ชัน การติดต่อดาต้าเบส//
$con_db = OpenConnectDB("localhost", "root", "mysql","qualifilesdb");
//การกำหนดชนิดของตัวอักษรว่าต้องการให้เป็นอะไร ในที่นี้คือ tis620
$charset = "SET character_set_client=tis620";
mysql_query($charset, $con_db) or die('Invalid query: ' . mysql_error());
$charset = "SET character_set_connection=tis620";
mysql_query($charset, $con_db) or die('Invalid query: ' . mysql_error());
$charset = "SET character_set_database=tis620";
mysql_query($charset, $con_db) or die('Invalid query: ' . mysql_error());
$charset = "SET character_set_server=tis620";
mysql_query($charset, $con_db) or die('Invalid query: ' . mysql_error());
$charset = "SET character_set_results=tis620";
mysql_query($charset, $con_db) or die('Invalid query: ' . mysql_error());
|
| |
|
|
| |
| Date :
4 ก.พ. 2551 09:33:19 |
By :
tong911 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
จะเอาไปลองศึกษาดูน๊ะครับ ขอบคุณมากครับ
|
| |
|
|
| |
| Date :
4 ก.พ. 2551 14:10:20 |
By :
เด็กน้อย |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 04
|
