PHP Submission form into MySQL db formatting

Question

I have created a blog using PHP that submits a form into a MySQL databse. It works perfectly. What i want to know is how to get it to recognise when i've pressed enter to create a new line or to record a ' without getting a MySQL error. Basically i want to turn a normal submission form into a submission form like is used on this website.

<tr>
 <td>Blog Title:</td>
 <td><input type="text" id="edt" name="BlogTitle"></td>
</tr>
<tr>
 <td>Blog Content:</td>
 <td><textarea name="BlogCont" cols="50" rows="10" id="edt"></textarea></td>
</tr>
<tr>
 <td><input type="hidden" name="Name" value="<?=$_SESSION['Name']?>"></td>
 <td><input type="submit" id="but" value="Post"></td>
</tr>

Any help would be appreciated.

Try nl2br. As for the other thing, are you escaping your inputs properly before inserting them? — TiiJ7
– TiiJ7, Commented Jan 13, 2014 at 12:56

Pavel Štěrba · Accepted Answer · 2014-01-13 12:59:09Z

1

For new lines with enter use nl2br (manual), for apostrophe you have to escape it with mysql_real_escape_string (manual).

answered Jan 13, 2014 at 12:59

Pavel Štěrba

2,9222 gold badges31 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

PHP Submission form into MySQL db formatting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related