Updating sql data through PHP

Question

Good day!

I am having a problem in showing the data that I need to Update.

For example: I have a field - NAME. And user input "John Travolta" on it and enter to save it in SQL. Then to update it, he will click the update and a textbox will appear with the name "John Travolta" with it.

The problem is I am only getting "John" and the "Travolta" does not appear on the text box.

My code is as follows:

<input name="event" type="text" id="event" size="69" value=<?php print stripslashes($row_array['event'])?>>

What can i do in order for the whole name to appear in the textbox? Thank you in advance.

Did you check the database to make sure that the data is correct? Could you provide the code on how you're inserting/getting your data? — Ali
– Ali, Commented Apr 23, 2011 at 16:18

Dr.J · Accepted Answer · 2011-04-23 16:17:35Z

5

You need to put quotes before and after the PHP line so HTML can parse it as a string. otherwise you will end with value=John Travolta when you want value="John Travolta"

answered Apr 23, 2011 at 16:17

Dr.J

1,2088 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

T4u · Accepted Answer · 2011-04-23 16:18:59Z

1

Use that code:

<input name="event" type="text" id="event" size="69" value="<?php print stripslashes($row_array['event']);?>">

answered Apr 23, 2011 at 16:18

T4u

2912 silver badges8 bronze badges

Collectives™ on Stack Overflow

Updating sql data through PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related