如何在mysql中使用php将两个表单字段插入一列[duplicate]

Question

This question already has an answer here:

• How to combine two strings together in PHP? 17 answers

I want to take two variables from two different fields of a form and insert into one column... but can't understand how to do?? here is what i've tried..

$name= $_GET['name'];
$age = $_GET['age'];
$sex = $_GET['sex'];
$wpm = $_GET['wpm'];   
$query = "INSERT INTO ajax_example (name,age,sex,wpm) values ('$name','$age','$sex','$wpm.$age')";

I want the combination of age and wpm to be stored in wpm

</div>

Answer 1

You can just join the strings first:

$col = $wpm.$age;
$query = "INSERT INTO ajax_example (name,age,sex,wpm) values ('$name','$age','$sex','$col')";

Notice that using the code like this is very dangerous - SQL injection.