Combining 3 form fields into one record and dumping to database

[pioneerx01]

Hello everyone,

 

I would like to let you know that I am brand new to PHP. I had someone help me in the past with PHP forms but that person is no longer helping. Here is what I cannot figure out:

 

I have a registration from with 3 fields entered independently. Lets say they are "first name", "middle name", and "last name." Right now I have them being dumped into database into 3 different columns, with respective names. How do I get all of them combined and entered in one column like "full name"?

 

Thanks for your help

[.josh]

Basically you take the same code you already have setup, but concatenate the posted info...

 

$fullname = $_POST['firstname'] . ' ' . $_POST['middlename'] . ' ' . $_POST['lastname'];

 

... and put it into a single column...same was as how it's done individually ...

[CarbonCopy]

And don't forget to escape the string (For MySQL use mysql_real_escape_string). Wouldn't want some hackers breaking your site would we?

[pioneerx01]

I cannot seem to get it to work. Let's say my code looks like this:

 

mysql_query("INSERT INTO `test_test`.`Test_Registrations` (

`ID` ,

`first_name1`,

`mid_name1`,

`last_name1`

)

VALUES (

NULL ,

'$_POST[first_name1]' ,

'$_POST[mid_name1]' ,

'$_POST[last_name1]'

);")

or die(mysql_error()); 

//echo "Row inserted!";

?>

 

Where would I put the code?

[mrMarcus]

first, create a field with the name 'full_name' as you stated, then use CrayonViolent's code to concatenate the posted info, and change the SQL query as required, ie.

 

$fullname = $_POST['firstname'] . ' ' . $_POST['middlename'] . ' ' . $_POST['lastname'];

mysql_query("INSERT INTO `test_test`.`Test_Registrations` (
`ID` ,
`full_name`
)
VALUES (
NULL ,
`{$full_name}`
)")
or die(mysql_error());

[CarbonCopy]

mrMarcus you forgot to escape user input!

[pioneerx01]

Ohh, that makes it easier. I got as far as entering the code and creating extra column in my database.

 

Now, I am getting:

 

Unknown column 'Joe bob Smith' in 'field list'

 

After the submission. What did I do wrong?

[redarrow]

you didnt put the underscore in the varable did you? my_name _is_redarrow__only_guessing

[pioneerx01]

I have actually made it all one word. So, fullname is everywhere and not full_name.

 

Oh and I have accidentally used ` mark instead of '

 

Well, like I have said, I am new at this. But is works now. Thank you all...

--------------------------------------------------------------------------------

 

Now that I have that working how would I modify it so it graves me dash "-" followed by record number right after the full name?