CODEWITHSUNDEEP
phpmysqlformsinputinsert
Sohal 07
Sohal 07

Reputation: 15

How to insert extra text in mysql?

I just want to add some extra text on top of input posted from a form as per the example below:

$username = $_POST['username'];

$sql = mysql_query("INSERT INTO customers (Username) VALUES('$username')");

But I want the value into the table as:'username*text' That is if user input a username as 'john', I want to get it entered into the table as 'john*text'.

Thanx in advance.

Upvotes: 0

Views: 111

Answers (2)

Harshal
Harshal

Reputation: 3622

USE:

$username = $_POST['username'].'*text';//hence you get *text postfix to every value

$sql = mysql_query("INSERT INTO customers (Username) VALUES('$username')");

now check your result,it will definitely work.

Upvotes: 0

Tikkes
Tikkes

Reputation: 4689

try:

$username = mysql_real_escape_string($_POST['username']) ."*text";

Do escape the user's input to avoid sql injection

Upvotes: 3

Related Questions