Go Back   Webmaster Malaysia Forum » Website Design & Development » Website Programming

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 02-09-2002, 11:20 AM
Senior Webmaster
 
Join Date: Oct 2001
Location: Kuala Lumpur, Malaysia
Posts: 294
Rep Power: 93
kidino is on a distinguished road
Send a message via Yahoo to kidino
Tips MySQL-PHP 2

Ni lagi satu tips kalau nak baca. OK ... andaikan kita ada satu table yang mana kita set jenis2 status perkahwinan. Kemudian ada lagi satu table yang mana kita ada senarai ahli dengan id dari status perkahwinan. Kelebihan buat table macam ni adalah sebab nanti senang nak tambah jenis status perkahwinan. Table dia mungkin lebih kurang macam ni
Code:
TABLE : SET_STATUS
+-----------+--------------+
| STATUS_ID | JENIS_STATUS |
+-----------+--------------+
|         1 | Bujang       |
|         2 | Berkahwin    |
|         3 | Janda        |
|         4 | Duda         |
+-----------+--------------+

TABLE : AHLI
+----------------+--------+
| NAME           | STATUS |
+----------------+--------+
| Ali            |      4 |
| Abu            |      1 |
| Minah          |      2 |
| Ah Chong       |      1 |
| Lai Meng       | NULL   |
| Minachi        |      1 |
| Hasnah         |      3 |
+----------------+--------+
Untuk table yang macam ni, ada beberapa cara yang kita boleh buat untuk keluarkan data. Tapi aku nak cerita beberapa cara yang tak best sebelum aku cerita cara yang best untuk keluarkan data dengan table yang macam ni.
PHP Code:
// CARA YANG TAK BEST

$sql "SELECT nama, status FROM ahli";
$result mysql_query($sql);

echo 
"<table>\n";
echo 
"<tr><td>NAME</td><td>STATUS</td></tr>\n";
while(
$data mysql_fetch_array($result))
{
    
$sql2  "SELECT jenis_status FROM set_status ";
    
$sql2 .= "WHERE where status_id = $data[status]";
    
$result2 mysql_query($sql2);
    
$data2 mysq_fetch_array($result2);
    echo 
"<tr><td>$data[nama]</td><td>$data2[jenis_status]</td></tr>";
}
echo 
"</table>\n"
Tak best sebab apa? Sebab nanti kita query database banyak kali. Ni boleh makan resources gak.
PHP Code:
// CARA KE-2 YANG TAK BEST

$sql  "SELECT ahli.nama, set_status.jenis_status FROM ahli, set_status";
$sql .= "WHERE ahli.status = set_status.status_id";
$result mysql_query($sql);

echo 
"<table>\n";
echo 
"<tr><td>NAME</td><td>STATUS</td></tr>\n";
while(
$data mysql_fetch_array($result))
{
    echo 
"<tr><td>$data[nama]</td><td>$data[jenis_status]</td></tr>";
}
echo 
"</table>\n"
Tak best sebab apa? Sebab kalau ada yang NULL, macam Lai Meng tu, dia terus tak keluar langsung nama Lai Meng tu. Nanti kiranya macam jumlah ahli tak tepat.
PHP Code:
// CARA YANG BEST

$sql    "SELECT status_id, jenis_status FROM set_status";
$result mysql_query($sql2);
while(
$data mysql_fetch_array($result))
$jenis_status[$data['status_id']] = $data['jenis_status']; }

$sql "SELECT nama, status FROM ahli";
$result mysql_query($sql);

echo 
"<table>\n";
echo 
"<tr><td>NAME</td><td>STATUS</td></tr>\n";
while(
$data mysql_fetch_array($result))
{
    
$status $jenis_status[$data['status']];
    echo 
"<tr><td>$data[nama]</td><td>$status</td></tr>";
}
echo 
"</table>\n"
Ni cara aku yang bagi aku cara yang paling best. Kalau ada yang tak setuju, terpulang. Selamat mencuba.
__________________
--------------------------------------------
Khairil Iszuddin Ismail
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 22-09-2002, 03:24 AM
hymns's Avatar
Senior Webmaster
 
Join Date: Nov 2001
Location: Johor
Posts: 769
Rep Power: 101
hymns is on a distinguished road
Send a message via ICQ to hymns Send a message via Yahoo to hymns
kidino buat le yg simple skit... pening aku... pastu tepi dia letak le comment cam ne dia jln mungkin aku dpt tangkap skit...
__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
new tips portal -> www.tips.com.my beyondsunn Websites Review and Suggestion 5 27-07-2005 04:20 PM
tips-travel.com alang Websites Review and Suggestion 3 11-07-2004 05:27 PM
Tips nurulmajdi Website Programming 5 17-05-2004 06:19 PM
Tips PHP-MySQL kidino Website Programming 2 22-09-2002 03:10 AM
Tips : Embedded PHP bazet Website Programming 2 22-09-2002 03:01 AM


All times are GMT +8. The time now is 03:27 AM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.


WebmasterMalaysia.com is Proudly Hosted by Exabytes Semi Dedicated Server.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61