AmirJusoh@Copyright . Powered by Blogger.
RSS

Week 7 : 13 April 2014

Assalamualaikum wbt
 

Pada minggu ke 7, saya telah belajar mengenai cara untuk membuat borang soal selidik menggunakan dreamweaver. Saya juga mempelajari tentang cara membina laman forum.

Antara langkah membina brang soal-selidik adalah:

Membina databased (telah ditunjukkan dalam tutorial yang lepas)
Membina page untuk borang soal-selidik

-          Create new page (blank pages)
-          Bina tajuk atau mukadimah untuk boring soal selidik anda.
-          Buat soalan, contoh soalan “berapa umur anda”
-          Unutk jawapan soalan, Insert form, select radio group and then fill up the pop up.
-          Untuk soalan yang mempunyai pilihan jawapan yang banyak, contohnya likert scale answer, buat table soalan dengan 5 column pilihan jawapan.
-          Click insert, select form and select radio group. Then fill up the radio group setting.
-          Selepas itu, drag radio button ke dalam column jawapan.
-          Buat langkah di atas untuk soalan2 berikutnya.

Jangan lupa, click server behaviour then select insert record then fill up the pop up.

Settle.


Ok ni untuk buat analisis soal selidik tadi.

Kita boleh gunakan table untuk buat paparan analisis soal selidik. Lagi mudah la.
Buat table, tuliskan setiap soalan di setiap baris table yang dibuat.
Pada column sebelah setiap soalan, sila kosong dahulu
Setiap soalan yang hendak dianalisis perlu “recordset”
Pastikan anda memilih table databased yang betul.
Letakkan cursor pada column di sebelah soalan pertama, add display record count, then display total records.
Buat juga langkah yang sama pada soalan yang lain.
Settle.


Langkah nak buat forum:

Buat page untuk paparan forum (forum.php)
Pastikan ada nama dan comment dan button send comment
Click server behaviour
Insert record then fill up the pop up
Aster inserting, go to…. Tuliskan nama page yang sama (forum.php)
Untuk paparan comment dari user lain, perlu buat table di bawah ruangkan komen td
Insert server behaviour, select recordset
Click binding, drag the name and comment to table
Settle.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

week 6 : 17 March 2014

Assalamualaikum wbt
 
assalamualaikum wbt

Week 6 : 17 March 2014

waaaa...tak sedar pun dah masuk week ke 6.. begitu cepat masa berlalu..
Hari nie Dr Syikin yang masuk kelas, Prof Dr Zaida tak de...ada tugas di luar UTM yang perlu diselesaikan..

Kelas dimulakan dengan pertanyaan Dr Syikin tentang kelas week ke-6..
rasanya tiada masalah week 5 tu..semua dapat melaksanakan kerja dengan baik.
selepas itu, vicky (pelajar senior) mohon untuk install app ke 4 dalam smart phone masing-masing..ia amat penting untuk kelas yang dijalankan pada hari ini.

Pada kali ini, Dr Syikin mengajar tentang bagaimana menggunakan fungsi view user, delete user dan update user bagi admin page. 

Sila rujuk di Sini untuk melihat : 


______________
Kat bawah ni plak paparan page yang saya buat tu la


 Login page
Admin akan "login" la



 After admin login, dia akan dibawa ke page diatas
admin akan view semua member dalam page
admin boleh la click > view user, delete user, atau update user <
 
 nie kalau admin click pada nama user, dia akan nampak detail maklumat user


ni plak kalau admin click update user, akan keluar page seperti diatas.



Itu sahaja la untuk kali ini.

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS

PHP: Admin page - view user, delete user and update user

Assalamualaikum wbt
 
assalamualaikum wbt

PHP : Admin page ; view user, delete user and update user

thank to vicky
semua video youtube datang dari vicky

PHP : Check name username behaviour
#  Open dreamweaver
#  Open register.php page
#  Go to panel server behaviour, click on plus ( + ) sign button and go to user authentication and choose check new username
#  Pop up check new username > Username field : username and direct page if username already exist (example ; page go to readyuser.php
Then click ok and save your file
#  Then open new file, create readyuser.php file.
#  In readyuser.php page, type whatever you want to display when new user key in the right username

Admin databased

_______________________________________________
Admin1 login

#  Open Dreamweaver > go to file > click new > click blank page > click PHP > click create
#  Create login page for admin (loginadmin.php)
#  Go to panel server behaviour > click plus button ( + )
#  Go to user authentication > choose login user
#  Pop up login user > validate using connection (choose your connection) > choose table (admin table) # username column is username > password column is password
#  If login succeeds, go to : admin1.php
#  if login fail, go to :  loginadmin.php
#  Restrict access based on > choose username, password and access level
#  And get level from > level
#  Click OK
#  Click file and save

_______________________________
 Admin view (admin 1)

#  Open Dreamweaver > go to file > click new > click blank page > click PHP > click create
#  Create admin1 page for admin 1 view : (admin1.php)

For view user

#   Open fail admin1.php
#  Go to panel server behaviour > click recordset > fill form recordset
#   Go to panel binding > drag item “name” in the table column view user (second row)
#   Highlight wording “{Recordset1.name}”
#   Go to panel server behaviour > click to detail page.


#   Pop up detail page: detail page = detailuser.php (create new fail for detailuser.php)
#   Pass url parameters : id
#   Pass existing parameters : tick at url parameters
#   Then click OK.
#   Open new fail (blank page)
#   Create new fail for detailuser.php (in the below)

#   Go to panel server behaviour > click recordset (if already have, click cancel) > fill in the form > click ok.
#   Click panel binding > drag item beside the item in the table. (name, username, password, age, email, phone, address and remarks).
#   In the bottom of your table, please write wording “back”
#   Wording “back” is function to go back to admin1.php when user click it.
#   Save your fail as detailuser.php
#   Settle.

______________________________
For delete user

#   Go to column delete user > second row please write word "delete".
#   Highlight wording “delete” and go to panel server behaviour and click “go to detail page”
#   Pop up go to detail page: detail page > write ; delete.php (you can create later, look below)
#   Pass url parameters : id
#   Pass existing parameters : tick at url parameters
#   Then click OK
#   Create new file (blank page)
#   click panel server behaviour > click recordset > fill in the item > click ok.
#   Then, click panel server behaviour again > click delete record
#   Pop up delete record ; primary key column = id
#   Primary key value = url parameters : id
#   After deleting go to : admin1.php (page admin1 view)
#   Then click ok
#   Save your fail as delete.php
#   Settle.

_____________________________________


How to update user
#   Open fail admin1.php
#   Highlight wording “update”.
#   Go to panel server behaviour > click to detail page.
#   Pop up detail page: detail page = updateuser.php (create new fail for updateuser.php)
#  Pass url parameters : id
#   Pass existing parameters : tick at url parameters
#   Then click OK.
#   Open new fail (blank page)
#   Create new fail for updateuser.php (in the below)

#   Go to panel server behaviour > click recordset > fill in the form > click ok.
#   Click panel binding > drag item in form text field in the table. (id, username, password, age and etc)
#   In the bottom of your table, insert button


#   Put your cursor beside update button, click insert > form > hidden field
#  Fill in the properties of hidden field 


#  Click the flash symbol and you can see the pop up like below


#   Pop up dynamic data > select id > click ok
#   Save your fail as updateuser.php
#   Settle.


____________________________________


YouTube video from Vicky
Admin databased

Admin1 login

Admin view (admin 1)
Admin view (admin 2)

Restrict : PHP restrict access to page

PHP : Go to detail page
PHP: Create detailpage.php
https://www.youtube.com/watch?v=BQj32f5hays
PHP: update behaviour

PHP : Delete behaviour


 TamaT



SELAMAT BERAMAL

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • RSS