/    Sign up×
Community /Pin to ProfileBookmark

[ASK PHP & JS]Database, Dropdown, & Text in 1 form

Sir can u help me

I have a web form, I am trying to call database with dropdown then text input will do an autofill
[ATTACH=CONFIG]16561[/ATTACH]

so the problem when I input the data from dropdown :
[ATTACH=CONFIG]16563[/ATTACH]
data only shows from last dropdown, and then I deleted my last dropdown and the input :
[ATTACH=CONFIG]16565[/ATTACH]
still same, data only shows from last dropdown

this is my script :
[url]http://pastebin.com/3bsCt6th[/url]

and database :

[CODE]/*
SQLyog Enterprise – MySQL GUI v6.13
MySQL – 5.5.32 : Database – realisasi_lelang
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=”*/;

create database if not exists `realisasi_lelang`;

USE `realisasi_lelang`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;

/*Table structure for table `barang` */

DROP TABLE IF EXISTS `barang`;

CREATE TABLE `barang` (
`id_brg` varchar(4) NOT NULL,
`n_brg` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `barang` */

insert into `barang`(`id_brg`,`n_brg`) values (’02’,’Barang Tetap’),(’01’,’Barang Bergerak’);

/*Table structure for table `jenis` */

DROP TABLE IF EXISTS `jenis`;

CREATE TABLE `jenis` (
`id_jns` varchar(4) NOT NULL,
`n_jns` varchar(255) NOT NULL,
`t_jns` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `jenis` */

insert into `jenis`(`id_jns`,`n_jns`,`t_jns`) values (‘1.1′,’Barang Milik Negara’,’Lelang Non Eksekusi Wajib’),(‘1.2′,’Barang Milik Daerah’,’Lelang Non Eksekusi Wajib’),(‘1.3′,’Barang DImiliki Negara DJBC’,’Lelang Non Eksekusi Wajib’),(‘1.4′,’BUMN’,’Lelang Non Eksekusi Wajib’),(‘1.5′,’BUMD’,’Lelang Non Eksekusi Wajib’),(‘1.6′,’Kayu dan Hasil Hutan Lainnya dari tangan pertama’,’Lelang Non Eksekusi Wajib’),(‘1.7′,’Lain – lain’,’Lelang Non Eksekusi Wajib’),(‘2.1′,’PUPN’,’Lelang Eksekusi’),(‘2.2′,’Pengadilan’,’Lelang Eksekusi’),(‘2.3′,’Pajak’,’Lelang Eksekusi’),(‘2.4′,’Harta Pailit’,’Lelang Eksekusi’),(‘2.5′,’Pasal 6 UUHT’,’Lelang Eksekusi’),(‘2.6′,’Barang Tidak Dikuasai / Dikuasai Negara DJBC’,’Lelang Eksekusi’),(‘2.7′,’Barang Sitaan Berdasarkan Pasa 45 KUHP’,’Lelang Eksekusi’),(‘2.8′,’Barang Rampasan’,’Lelang Eksekusi’),(‘2.9′,’Barang Temuan’,’Lelang Eksekusi’),(‘2.10′,’Fidusia’,’Lelang Eksekusi’),(‘2.11′,’Gadai’,’Lelang Eksekusi’),(‘2.12′,’Sitaan Berdasarkan Ps. 18 ayat(2) UU Nomor 31 Tahun 1999′,’Lelang Eksekusi’),(‘2.13′,’Lain – lain’,’Lelang Eksekusi’),(‘3.1′,’PL Kelas I dari BL’,’Lelang Non Eksekusi Sukarela’),(‘3.2′,’PL Kelas I dari Umum’,’Lelang Non Eksekusi Sukarela’),(‘3.3′,’PL Kelas II dari BL’,’Lelang Non Eksekusi Sukarela’);

/*Table structure for table `lokasi` */

DROP TABLE IF EXISTS `lokasi`;

CREATE TABLE `lokasi` (
`id_lok` varchar(4) NOT NULL,
`n_lok` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `lokasi` */

insert into `lokasi`(`id_lok`,`n_lok`) values (’02’,’Luar Semarang’),(’01’,’Semarang’);

/*Table structure for table `pejabat` */

DROP TABLE IF EXISTS `pejabat`;

CREATE TABLE `pejabat` (
`id_jab` varchar(50) NOT NULL,
`n_jab` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `pejabat` */

insert into `pejabat`(`id_jab`,`n_jab`) values (‘11111111 2222222 3 4444′,’Hajar Susena’);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;[/CODE]

please help fix my script

[canned-message]attachments-removed-during-migration[/canned-message]

to post a comment
PHP

0Be the first to comment 😎

×

Success!

Help @snowh1te spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.15,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...