dynamic form ->r0kawa tolonnnnnn...

nuha · #1 (**permalink**) 24-04-2002, 09:20 AM

akum, firstly saya nak minta kengkawang xpcially r0kawa tolong nengok & settle kan masalah saya kat bawah nih:

a'kum wbt,
sameon, leh tak awak tolong saya bg cth coding utk masukkan input >1 sekaligus dlm 1 masa.So, input nih kener gunakan array.saya bg cth coding form yg saya dah wat.Leh tak awak tolon bg coding camner nak masukkan dlm db nyer.sbb saya dah wat gak utk coding input ke db, tp masalahnye camni, kotak input saya tu ader 10 kotak.Dlm masa yg sama saya ader hantar input hidden utk tiap2 KOD_JENIS skali, so biler saya nak masukkan 3 input jer, dia akan masukkan nilai input hidden tu sampai 10 x.so camner yek.Saya bg kat awak view table , coding tuk form & coding input yg tak jadik tuh.TOLONN....harap dpt bantu...

->cth table:PRM_KOD1 field->spt dbwh

KOD_JENIS KOD1_ KOD KOD1_NAMA
--- ----- ------------------------------
KAW 1 IBU PEJABAT
KAW 2 KUALA TERENGGANU/MARANG
KAW 3 HULU TERENGGANU
KAW 4 DUNGUN
KAW 5 BESUT
KAW 6 KEMAMAN
KAW 7 SETIU
KAW 8 KETENGAH
JAB 01 SATU HQ
JAW 01 PENGURUS
JAW 02 EKSEKUTIF
KJW 01 EKSEKUTIF
KJW 02 BUKAN EKSEKUTIF
BAN 1 MELAYU
BAN 2 CINA
BAN 3 INDIA
AGM 1 ISLAM
AGM 2 BUDHA
AGM 3 KRISTIAN
WAR 1 MALAYSIA
WAR 2 THAILAND

dalam table nih, saya kene input bangsa, agama, kaw, jab etc gunakan borang yg berlainan.So dtiap 2 borang tuh s/thing like this lah:

<html>



<head>

<title>Daftar Agama</title>

</head>

<body>

<?php $bil=10;?>

<form action="insert_cuber.php" method="post">

<blockquote>

<div align="center">

<center>

<br>

<br>

</center>

</div>

</blockquote>

<div align="center">

<center>

<table border="0" width="40%" height="250">

<tr bgcolor="#006699">

<td width="77%" height="19" colspan="2"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif" size="2">Daftar

Agama</font></td>

</tr>

<tr bgcolor="#BFD9FF">

<td width="11%" height="19"><font face="Arial, Helvetica, sans-serif" size="2">Kod</font></td>

<td width="66%" height="19"><font face="Arial, Helvetica, sans-serif" size="2">Keterangan</font></td>

</tr>

<?php for($i = 1; $i <= $bil; $i++ ): ?>

<tr>

<td width="11%" height="19">

<input type="text" name="agama_kod[]" size="5" style="text-transform: uppercase>

</td>

<td width="66%" height="23">

<input type="text" name="agama_ktrgn[]" size="35"style="text-transform: uppercase>

</td>

</tr>

<?endfor?>

<tr>

<td width="103%" height="19" colspan="2">

<input type="hidden" value="AGM" name="agama_kodjenis">

<input type="submit" value="Submit" name="B1">

<input type="reset" value="Reset" name="B2">

</td>

</tr>

</table>

</center>

</div>

</form>

</body>

</html>

pastu kat bawah ni lak cth coding tuk masukkan dlm db.Tapi gunakan oracle lah.samer jer behavior dia ngan SQl, cume sintak dia jer yg laing.Mu tolon yek.

<HTML>



<HEAD>

<TITLE>Insert Portfolio</TITLE>

</HEAD>

<BODY BGCOLOR="#FF99CC">

<CENTER><B>Insert Status</B>

<BR><BR>

<?php

include("common.php");

$num_rows = count($agama_kod);

$i=0;

while( $i=< $num_rows){

$username="PAYROLL";

$password="PAYROLL";

$database="DEMODB";

$connection = OCIlogon($username, $password, $database);

$stmt = OCIParse($connection, "INSERT INTO PRM_KOD1 VALUES ('00','" . $agama_jeniskod . "','" . strtoupper($agama_kod[$i]) . "','"

. strtoupper($agama_ktrg[$i]) . "','')");

$ret = OCIExecute($stmt);

if ($ret == "1") {

echo("Insert was successful.Dah berjaya");

} else {

echo("Insert failed. Error code: OCIExecute = " . $ret);

}

OCIFreeStatement($stmt);

OCILogoff($connection);

++$i;

}

?>

</CENTER>

</BODY>

</HTML>

Awak bagi la saya cth coding gunakan sql pung tak per.Nanti insyaAllah saya implement lam oracl.Tapi letak comment banyok sket la.Saya ni baby baru merangkak.Harap dpt bantu..

r0kawa · #2 (**permalink**) 26-04-2002, 10:23 AM

err.. kena r0kawa jer ke yang jawab? orang lain tak boleh jawab? :P . Ahhh.. kan dah balas kat emel dulu, sian orang lain takboleh jawab soalan ni.. lain kali tanya soalan general jer, jangan letak nama2, tak sesuaiiii... tau

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Static or Dynamic?	azren	Website Design	10	03-12-2004 10:36 PM
How to develop dynamic database websites	ubsacc2004	Websites Review and Suggestion	16	26-11-2004 09:11 PM
Apa tu Dynamic Domain Name System ????	Tekno-daei	Domain Names	2	25-03-2004 04:17 PM
make ur site dynamic, up to date and informative	zumaidi	Other Internet Marketing Methods	1	04-05-2003 01:11 AM
r0kawa->php	nuha	Website Programming	1	03-04-2002 12:20 PM

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