php + mysql problem

NetHosted Customer Joined: 06 Jan 2007 Posts: 4

Hello,

I've got a php script which will pull data from a mysql database. This works fine but when I try to populate a html input box with the data not all the data is displayed, e.g. for the name: John Smith, will only display John in the textbox (anything after a space is not shown), does anyone know the reason for it doing that?

The code used to ouput the data is simply just (in between php):

<input name=first_name size=20 value=$new1>

Hope someone can help,Cheers,

Mitch

Posted: Wed Mar 07, 2007 8:07 pm Post subject:

Mitch,

You'll need to put quotes round the variable in the <input> tag. (Escaping if necessary.)

Regards,

Pete

Posted: Wed Mar 07, 2007 11:33 pm Post subject:

And since you're using PHP, you'll want to escape the quotes, with \ before them:
echo "<input name=\"first_name\" size=\"20\" value=\"$new1\"/>";

Alternatively, you can switch to singles quotes for the PHP bit, and then don't need to scape the HTML quotes:
echo '<input name="first_name" size="20" value="'.$new1.'"/>';

Posted: Thu Mar 08, 2007 6:52 am Post subject:

NetHosted Customer Joined: 06 Jan 2007 Posts: 4

Thanks guys, have sorted it out now!!

Mitch

Client Support	Community	Server Status	Contact Us	Client Login
Email Hosting	Website Hosting	Reseller Hosting	VPS Hosting	Dedicated Servers