Update data with a form

Harlugo

hello everyone i have another question i m doing a form to update data in the database.

The update form is working great but when i update the information if i leave blank field then the information is then show as like there is no data is my database field, i dont want to do that.

Is there a way when i update the information in the form that when it call the form it put all the old information in the form so i could update them. (like echo in the form)

i will then save important information and not face the consequence of leaving no information in the field .

if someone can show me and example code of that that would be really good for me

Let me know.

insectis

Sure, do something like this:

<form method=post>
<input type=text name=firstName value=$_POST['firstName']>
<input type=submit name=submit value=Submit>
</form>

HTH,

insectis

Harlugo

in your point of view my technique of putting the information in the form like this is it the best way? or shoud i take another avenue.

If i should chose another way let me know.

and if you have and example this would be great

insectis

This will work. If the variable is NULL (as in when the form loads the first time), then nothing will appear in the text field. If the variable has a value, then that value will be put into the text field, therefore saving the user from retyping all of his information.

insectis

Harlugo

Thanks for that . Also do you think that if i have menu selection for country and tec tec.. thoose menu will show the value of my database i m curious to know.

i think it s important that it does.

insectis

For a drop-down menu, you'll have to use an if-else statement to check if the value of $_POST['yourVariable'] is equal to that of the option. If it is, then you can insert "selected" into your <option> tag.

insectis

Harlugo

this one seems more tricky i think this will take more time to do