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

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 18-02-2003, 12:42 AM
New kid on the block
 
Join Date: Feb 2003
Location: malaysia > johor
Posts: 2
Rep Power: 0
lanxc_7 is on a distinguished road
Question database in website..!!

isk.. wey kengkawan... aku tak paham.. arr.. pasal... database dalam website..nei.. ceman arr eks?... buleh terangkan ark?...
cam ms access.. tuh kan kite leh create database kan.. macam.. maklumat sesuatu komuniti... so... cemana nak kombinde kan jadik .html .............. ntah ar, aku pening nie!!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 18-02-2003, 01:58 PM
kpyew's Avatar
Senior Webmaster
 
Join Date: Jul 2001
Location: KL, Malaysia
Posts: 277
Rep Power: 95
kpyew is on a distinguished road
Send a message via ICQ to kpyew
This is a little tough to explain... maybe you should look up for more info on the net...
__________________
webmaster @ http://kongtechnology.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 05-04-2003, 07:22 PM
geekrawk's Avatar
Moderator
 
Join Date: Jul 2001
Location: a state of mind
Posts: 98
Rep Power: 91
geekrawk is on a distinguished road
Send a message via Yahoo to geekrawk
what exactly do you need? it would be nice if you could point out a website does what you want and maybe we could explain how its done.
__________________
geekrawk

{wt} - angry middle finger
http://geekrawk.wordpress.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 06-04-2003, 11:02 AM
mysticmind's Avatar
Super Moderator
 
Join Date: Jun 2001
Location: Mystic Kingdoms
Posts: 2,687
Rep Power: 145
mysticmind will become famous soon enough mysticmind will become famous soon enough
Send a message via Yahoo to mysticmind
firstly... learn and mastering the HTML code..
then.. after you master it..
slowly move to database driven OK?..
without any basic .. you cannot going anywhere..

database mean interactive.. programing..
you cant understand without mastering html or related..

thanks..

// dont forget the 'root'
__________________
Personal's Blog! - Malaysian Artist!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 07-04-2003, 08:23 AM
AbgCooL's Avatar
Senior Webmaster
 
Join Date: Jun 2002
Location: In a house...
Posts: 208
Rep Power: 83
AbgCooL is on a distinguished road
alo... utk buat database.. salah satu cara... ko leh guna CGI programming.. tak pon PHP pon bole gak... kalau pure HTML or XML ke tu aku tak pasti la... ASP pon bole interact ngan database.. tapi.. as adviced by others.. learn and master HTML.. .camne? Guna google, pastu ko search guna keyword: HTML tutorial .. or any other keyword yang related.. mastering tak maksud ko master semua code.. tu gila POWER hehehe.. maksud mastering tu ko tahu ape maksud code HTML dan bole 'spit out' the code dgn hanya guna Notepad contohnya.. See ya and good luck!!


Ciaaawwzzz.........bzzt!
__________________
<b>A</b>bg<b>C</b>ooL<br><i>Cool as you can be</i>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 09-07-2003, 03:49 PM
spicy_girl's Avatar
Novice Webmaster
 
Join Date: Jul 2003
Location: aku org malaysia...
Posts: 45
Rep Power: 0
spicy_girl is on a distinguished road
ada yg tau camana nak buat search function??
nak carik maklumat yg ada dlm database guna php coding???
aku dah blur ni...
__________________
aku seadanya...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 14-08-2003, 11:59 PM
Novice Webmaster
 
Join Date: Aug 2003
Location: Perak
Posts: 21
Rep Power: 0
myravens is on a distinguished road
ape tu database haa . Boleh korang terangkan kat aku tak ???
Aku ni masih lagi belajar buat web site..
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 17-08-2003, 09:48 PM
DingDang's Avatar
Normal User
 
Join Date: Jul 2001
Location: eRakan.Net
Posts: 118
Rep Power: 92
DingDang is on a distinguished road
Send a message via ICQ to DingDang Send a message via Yahoo to DingDang
database : pangkalan data.

ia merupakan satu kaedah untuk menyimpan dan menyusun data secara berstruktur dengan tujuan untuk menghasilkan satu gedung data yang bergantung di antara satu dengan lain bagi mengelakkan pengulangan data pada setiap maklumat.

masalah
contohnya dalam data pelajar, terdapat tiga maklumat (andaian) dalam tiga fail yang berlainan:

1) nama : mengandungi - nama penuh, nombor matrik, alamat
2) kursus : mengandungi - nama kursus, kod kursus
3) pelajar yang mengambil kursus - mengandungi nama penuh pelajar, nombor matrik pelajar, nama kursus dan kod kursus.

fail 1) dan fail 2) memegang data berlainan. tetapi fail 3) memegang data yang terkandung dalam 1) dan 2). apa akan berlaku jika nama kursus atau nombor matrik bertukar? pengguna harus menyemak semula fail 3) dan menukarkannya secara manual. apa akan terjadi jika terdapat 1000 data yang perlu ditukar? Juga terdapat pengulangan nilai yang sama dalam fail 3) yang mana ianya telah wujud dalam 1) dan 2).

penyelesaian
bina tiga jenis table dalam pangkalan data.

4) pelajar - pelajar_no_matrik (unik), nama_penuh, alamat
5) kursus - kursus_kod (unik), kursus_nama
6) subjek_diambil - pelajar_no_matrik, kursus_kod

dengan menggunakan pangkalan data, kita telah mengelakkan pengulangan data pada item 6). ini kerana item 6) hanya memegang nilai unik yang terdapat pada item 4) dan item 5).

oleh itu, untuk mendapatkan kembali nilai yang diperlukan oleh item 3) sebentar tadi, dengan menggunakan SQL (Structured Query Language / Simple Query Language - bahasa untuk pangkalan data), kita boleh menulis begini :

Code:
SELECT pelajar.nama_penuh, pelajar.pelajar_no_matrik, kursus.kursus_nama, kursus.kursus_kod
FROM pelajar, kursus, subjek_diambil
WHERE subjek_diambil.pelajar_no_matrik = pelajar.pelajar_no_matrik
AND subjek_diambil.kursus_kod = kursus.kursus_kod
dan anda akan mendapat nilai yang diinginkan dengan segera!

oleh kerana item 6) hanya bergantung kepada id unik item 4) dan item 5), maka anda tidak perlu mengubah apa2 data dalam item 6) jika item 4) dan 5) terdapat perubahan data (contohnya perubahan alamat pelajar ataupun perubahan nama kursus)!

good luck!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 18-08-2003, 12:05 AM
analyzer`'s Avatar
Novice Webmaster
 
Join Date: Jul 2003
Location: Sarawak, Malaysia
Posts: 33
Rep Power: 0
analyzer` is on a distinguished road
Send a message via AIM to analyzer` Send a message via Yahoo to analyzer`
cam pernah tengok coding SQL tu..?? maaahahahahahaa.... gurau je la.... Actually kalau nak senang buat database guna je ASP lagi senang coz tak cam CGI perlu upload pergi folder sendiri.... example ( cgi_bin/perl ) emmm, aku dulu pun pening kepala nak cari cammane nak upload CGI tu.... tapi karang dah faham... semuanya bermula dari mastering HTML la... pas tu pergi SQL... pas tu pindah gi ASP baru la dapat master CGI.... coz CGI nie susah sikit... kalau nak senang guna je ASP lagi senang.... macam HTML je coding die..... cuma beza sikit je....
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
Quran Database infeeneetee Website Programming 25 27-01-2005 05:08 PM
universe database bayam04 Website Programming 2 06-11-2004 12:30 AM
ASP & Topspeed database Rizalnet Website Programming 1 07-08-2004 07:24 PM
ASP Access Database alvinhan Website Programming 1 25-11-2002 10:01 AM
OOP dan Database kidino Website Programming 0 07-10-2002 06:25 PM


All times are GMT +8. The time now is 04:17 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