Jump to content

Problem getting database data as form default value


magmazing

Recommended Posts

The issue I'm running into is sort of a mixture of a html form/php/mysql problem.

I'm trying to set up a "members" html form in php that will bring up each membership's info so that they can update/change addresses, passwords etc.

Here's the problem (I'll give examples of what's working and what's not)

In my form I've got a text input box for someone's first Name and am accessing my database to make the specific members first name as the default value as shown below:

[i]echo "<input name=FirstName type=text size=25 maxlength=25 value=" . $row['first_name'] . "> \n" ;[/i]

The output of that is let's say "Steve". Everything works fine,


But when I try to retrieve Steve's address (let's call it "123 Broadway Avenue") from my database to be the default value in the input box as coded below:

[i]echo "<input name=Address type=text size=35 maxlength=100 value=" . $row['address'] . ">" . $row['address'] . "\n" ;[/i]

The output on the form comes out as just "123"... The "Broadway Avenue" is missing.

Now I've tested simply echoing $row['address] by itself and the entire address is outputted. I've also changed the form code from "input" to "textarea" and it comes back with the full address. Why won't the whole address show up on the "input" box? Does it not like spaces?

I'm a bit of a rookie at working with php, databases and forms, but have managed to get most things to work, but this has confused me a bit.

Any advice if you can decifer what I'm talking about would be fantastic. Thanks.
Link to comment
Share on other sites

I think it's because of the spaces you will be using as your not using value="123 Broadway Avenue" your echoing as value=123 Broadway Avenue

therefore 'Broadway' and 'Avenue' are being looked at as an eliment of the input box not the actual value

Try this code mate

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]echo '<input name=Address type=text size=35 maxlength=100 value="' . $row['address'] . '">' . $row['address'] . "\n" ;[/quote]


see how i've used ' as the main string.. this lets us use " without having to put \" and then just before the . we have " to be the first of " in value="" and then ' to close the string and echo the variable..

See how that goes :)
Link to comment
Share on other sites

[!--quoteo(post=358172:date=Mar 24 2006, 11:55 PM:name=shocker-z)--][div class=\'quotetop\']QUOTE(shocker-z @ Mar 24 2006, 11:55 PM) [snapback]358172[/snapback][/div][div class=\'quotemain\'][!--quotec--]
I think it's because of the spaces you will be using as your not using value="123 Broadway Avenue" your echoing as value=123 Broadway Avenue

therefore 'Broadway' and 'Avenue' are being looked at as an eliment of the input box not the actual value

Try this code mate
see how i've used ' as the main string.. this lets us use " without having to put \" and then just before the . we have " to be the first of " in value="" and then ' to close the string and echo the variable..

See how that goes :)
[/quote]

Nice! It worked. Thanks so much! The wonders that are the use of single quotes and double quotation marks. I've been trying to learn this stuff without the help of books and just by literally trial and error and was getting by okay and then that issue popped up and I was like, "what the hell am I doing wrong?" So yeah, I've learned something today. If you were to see the rats nest that is the rest of the coding of what I'm doing, it's amazing how I got anything to work at all.

Thanks again.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.