0% found this document useful (0 votes)

53 views

Perak B Soalan 2023

The document discusses code segments and output displays for a member cooperative website. Figure 10(a) shows code for displaying a list of members on the senarai.php page. Figure 10(b) shows the output of the kemaskini.php page for updating member records. Figures 10(c) and 10(d) show the code process for updating a member's record. Figure 11(i) shows client-side script code to retrieve and display all fields from the Biodata.txt file shown in Figure 11(ii). Figure 11(iii) asks to draw the output interface of the web page program. Figure 12 shows two design proposals for a login interface. Respon

Uploaded by

mohd asmail

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

53 views

Perak B Soalan 2023

Uploaded by

mohd asmail

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 10

SULIT 1 PPC 3770/1

BAHAGIAN B
[50 markah]

1. Rajah 10(a) menunjukkan kod segmen atur cara dalam laman web senarai.php manakala
Rajah 10(b) menunjukkan paparan output laman web kemaskini.php. Kod segmen atur cara
Rajah 10(c) dan 10(d) pula menunjukkan proses pengemaskinian rekod ahli koperasi.

<h2>Senarai Maklumat Ahli Koperasi ABC</h2>

<?php
$sambungDB = mysqli_connect("localhost","root","","dbkoperasi");
print "<table border='1'>";
print "<tr>";
print"<th>No Ahli</th>";
print"<th>Nama Ahli</th>";
print"<th>Email</th>"; A
print"<th>Tindakan</th>";
print "</tr>";

$hasil = mysqli_query($sambungDB,"SELECT * FROM ahli ORDER BY namaAhli

ASC");

while($rekod = mysqli_fetch_array($hasil))
{ B
print "<tr>";

print "<td>".$rekod['noAhli']."</td>";
print "<td>".$rekod['namaAhli']."</td>";
print "<td>".$rekod['email']."</td>";
print "<td><a
href='kemaskini.php?noAhli=$rekod[noAhli]'>Kemaskini</a></td>";

print "</tr>";
}

Rajah 10(a)

3770/1@PanitiaSKPerak2023 SULIT
SULIT 2 PPC 3770/1

Rajah 10(b)

<h2>Kemaskini Maklumat Ahli Koperasi ABC</h2>

<?php
$sambungDB = mysqli_connect ("localhost","root","",”dbkoperasi”);
if (isset($_GET['noAhli']))

$no_Ahli=$_GET[' X '];
// contoh $hasil = "SELECT * FROM ahli WHERE noAhli = 'A003'";
$hasil = "SELECT * FROM ahli WHERE noAhli = ' Y ' ";
$result = mysqli_query($sambungDB, $hasil);
$rekod = mysqli_fetch_array($result);
$nama_Ahli = $rekod['namaAhli'] ;
$email_Ahli = $rekod['email'];
?>
<form action = "prosesKemaskini.php" method = " Z ">
<p>No Ahli : <b><?php print $no_Ahli;?></b></p>
<p><input type = "hidden" name = "noAhli" value = '<?php print $no_Ahli;?>'></p>
<p>Nama Ahli :
<input name = "namaAhli" type = "text" value = '<?php print $nama_Ahli;?>'></p>
<p>Email :<input name = "email" type = "email" value = '<?php print $email_Ahli;?>'>
</p>
<p><input type = "submit" value = "Kemaskini"></p>
</form>

Rajah 10(c)

3770/1@PanitiaSKPerak2023 SULIT
SULIT 3 PPC 3770/1

<?php
$sambungDB = mysqli_connect ("localhost","root","",”dbkoperasi”);
$no_Ahli = $_POST['noAhli'];
$nama_Ahli = $_POST['namaAhli'];
$email_Ahli= $_POST['email'];
//mengemaskini rekod No Ahli yang terlibat.
C
$result = mysqli_query($sambungDB, $hasil);
header('location:senarai.php');
?>

Rajah 10(d)

(a) Berdasarkan Rajah 10(a) , terangkan tujuan kod segmen atur cara :
A : ….…………………………………………………………………………………………
………………………………………………………………………….…………………
B: ….…………………………………………………………………………………………
.………………………………………………………………………….…………………
[4 markah]

(b) Berdasarkan Rajah 10(c) , kenal pasti :

(i) X : …………………………………………………………………………………………
(ii) Y : …………………………………………………………………………………………
(ii) Z : …………………………………………………………………………………………
[3 markah]
(c) Berdasarkan Rajah 10(d), tuliskan arahan SQL pada C.
.………………………………………………………………………….…………………
.………………………………………………………………………….…………………
.………………………………………………………………………….…………………
[3 markah]

3770/1@PanitiaSKPerak2023 SULIT
SULIT 4 PPC 3770/1

2. Rajah 11(i) menunjukkan kod segmen atur cara penskripan klien untuk mencapai data dan
memaparkan semua medan daripada Rajah 11(ii) iaitu fail Biodata.txt

Rajah 11(i)

3770/1@PanitiaSKPerak2023 SULIT
SULIT 5 PPC 3770/1

Rajah 11(ii)

Rajah 11(iii)

Berdasarkan Rajah 11(i) lengkapkan P.

P :.......………………………………………………………………………………………………...

...………………………………………………………………………………………………………

………………………………………………………………………………………………………...

[4 Markah]

3770/1@PanitiaSKPerak2023 SULIT
SULIT 6 PPC 3770/1

Berdasarkan rajah 11(iii) lakarkan antara muka output bagi atur cara laman web di atas.

[6 Markah]

3770/1@PanitiaSKPerak2023 SULIT
SULIT 7 PPC 3770/1

3. Rajah 12 menunjukkan cadangan-cadangan antara muka bagi log masuk pengguna.

Cadangan A

Cadangan B

a) Berdasarkan Rajah 12, pilih cadangan antara muka yang terbaik dan berikan justifikasi
pilihan anda berdasarkan prinsip reka bentuk laman web.
……………………………………………………………………………………………………..

……………………………………………………………………………………………………..

3770/1@PanitiaSKPerak2023 SULIT
SULIT 8 PPC 3770/1

……………………………………………………………………………………………………..

……………………………………………………………………………………………………..
[11 markah]
a) Berdasarkan jawapan di (a) , berikan dua cadangan penambahbaikan dan justifikasinya.

……………………………………………………………………………………………………..

[4 markah]

3770/1@PanitiaSKPerak2023 SULIT
SULIT 9 PPC 3770/1

4.
Rajah 13 menunjukkan jadual hubungan sebuah pangkalan data Soalan Peperiksaan.

Rajah 13
Berdasarkan rajah, tulis arahan Bahasa Pertanyaan Berstruktur (SQL).