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

Select and Insertion

P: 4
I dont know how to go about this

i have a form that i want to retrieve data, i mean some of the textfields.

on the top frame, i would i have 1 textfield
ID

and a retrieve button

user will insert the id of the data and click on the retrieve button to retrieve the data on the bottom frame.
/////////////////////////////////////////////////////////////////////////

on the botton frame, i would 5 textfields. 3 are readonly from database after retrival and 2 others are not readonly, data would be inserted into those

ID
Name (readonly)
Age (readonly)
Sex
Weight



then a button in the bottom to submit all into the database...

i tot of this and this is the solution to a small form i am creating, but i dont know how to create the script...

Please anyone that can help me write this one script, or if you have a better solution to this, i would be very grateful
Aug 14 '08 #1
Share this Question
Share on Google+
7 Replies


Markus
Expert 5K+
P: 6,050
You can apply in the jobs section for freelance writes for this.
Aug 14 '08 #2

nathj
Expert 100+
P: 938
what code do you have at present? There are many articles on this site and others that will get you started.

You need to have a go and then ask specific code related questions or hire someone as suggested previously.

If you have a go and get stuck post back I will be happy to help then

nathj
Aug 14 '08 #3

P: 4
ok do you know of any article where a textfield can retrieve search result after clicking the search button
Aug 15 '08 #4

nathj
Expert 100+
P: 938
ok do you know of any article where a textfield can retrieve search result after clicking the search button
What do you have so far?

I'm assuming you have a web page with the text field on and a submit button. You then want the user to be able to enter information into the text field and click the button to search your site - is that correct?

The next question I have, beore i can make any suggestions or recommendations is how is the site built? Is it all static HTML files or is it built form a database, or some combination of the two. What I'm getting at here is 'where is the content that is to be searched?'

If you are searching a DB for the string entered then I can help you out, I've just don this my self and I can point you ion the right direction.

If, however, your pages are static then I suggest you look at the free stuff from Google before we attpemt any in file searching ourselves.

Cheers
nathj
Aug 15 '08 #5

P: 4
What do you have so far?

I'm assuming you have a web page with the text field on and a submit button. You then want the user to be able to enter information into the text field and click the button to search your site - is that correct?

The next question I have, beore i can make any suggestions or recommendations is how is the site built? Is it all static HTML files or is it built form a database, or some combination of the two. What I'm getting at here is 'where is the content that is to be searched?'

If you are searching a DB for the string entered then I can help you out, I've just don this my self and I can point you ion the right direction.

If, however, your pages are static then I suggest you look at the free stuff from Google before we attpemt any in file searching ourselves.

Cheers
nathj

exactly a DB...
the user will input the id and the result will display in textfields, not on the plain page,
like 3 other textfields will show on the bottom frame with results, so that i can insert them into another table..

hope u undastand this
Aug 15 '08 #6

nathj
Expert 100+
P: 938
exactly a DB...
the user will input the id and the result will display in textfields, not on the plain page,
like 3 other textfields will show on the bottom frame with results, so that i can insert them into another table..

hope u undastand this
Right, this is getting clearer by the post.

The user enters a number and then you retrieve the info from the DB using that number and display the results on the page.

I would tackle this as follows:

1. A page with the the text box and button, not necessarily in a form.
2. Button calls some JS that uses AJAX to pass the number entered to a PHP script.
3. PHP script checks that it is a number, if it is NOT it returns a message to that effect. If it IS a number then the SQL is executed and the results returned as the output.

I recommend you read the following:
PHP DataObject
AJAX Data Querying

This should get you started with some code. If you get stuck with the specifics then post your code here and I'll take a look for you. I've done this sort of thing a lot, but I don't want to simply give away the code - you will learn more by doing it yourself.

Cheers
nathj
Aug 15 '08 #7

P: 4
thanks , i will read it...
Aug 15 '08 #8

Post your reply

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