By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,851 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,851 IT Pros & Developers. It's quick & easy.

Database record in a form

P: 3
HI,

I am trying the following any help in getting to my target would be great.

My design is as follows I have a form (say formA) which has only one text field for account_id and then i have a search button, Now when the user enters a account number and presses search I want the record to be displayed as a form which will have all the fields in the database and also two buttons update and OK ,such taht if the user changes anythibng in the record and presses the update buttoon the record in the database should be updated.

Thaks for all the help in advance.
Mar 17 '08 #1
Share this Question
Share on Google+
5 Replies


KevinADC
Expert 2.5K+
P: 4,059
Look into the CGI module for form generation and form processing and the DBI module for your database interface. DBI is not a core module though so it may need to be installed.
Mar 17 '08 #2

P: 3
Look into the CGI module for form generation and form processing and the DBI module for your database interface. DBI is not a core module though so it may need to be installed.

HI thanks for the response but I have no DBI modules or anything i can install as i do not have access to the server but as far as I know this should be quite straight forward and may be i did not explain my question correctly I will try to reexplain here.

Basically I have a form which accepts curtomer_id and when submited displays the record as a single row in the HTML format. We will get only one record as custoemr_id is primary key.

I want exactly the same thing to happen except that i need the display as a HTML form instead of HTML table so taht the user can view the data and make changes if required.

I guess this is clear

Thanks
Mar 20 '08 #3

KevinADC
Expert 2.5K+
P: 4,059
HI thanks for the response but I have no DBI modules or anything i can install as i do not have access to the server but as far as I know this should be quite straight forward and may be i did not explain my question correctly I will try to reexplain here.

Basically I have a form which accepts curtomer_id and when submited displays the record as a single row in the HTML format. We will get only one record as custoemr_id is primary key.

I want exactly the same thing to happen except that i need the display as a HTML form instead of HTML table so taht the user can view the data and make changes if required.

I guess this is clear

Thanks

Not clear to me. But if you need to access a databse and you can't use the DBI module you will have to write it all out by hand I guess. I have never done that myself. As fas as the form goes, like I already said, look into the CGI module, it comes with perl so should be installed. You can read all the core perl module documentation on http://perldoc.perl.org
Mar 20 '08 #4

eWish
Expert 100+
P: 971
This should be easily achieved. It will just be a matter of writing your script to display the data in the form. Just populate value attribute of your texbox with the data you from your DB. Read up on the HTML portion of the CGI pm.

--Kevin
Mar 20 '08 #5

P: 3
This should be easily achieved. It will just be a matter of writing your script to display the data in the form. Just populate value attribute of your texbox with the data you from your DB. Read up on the HTML portion of the CGI pm.

--Kevin

I will go through teh doxcument and hopefully will succeed itf i come across issues i will post it thanks for the respponses
Mar 20 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.