I am storing form post data in MySQL data base in array format but when i fetch value its not array it is become string.
There are my fetch value:
Array ( [First_Name] => Rahul [Last_Name] => Singh [Street] => 210 Adhichini [City] => New Delhi [California_Automobile_Insurance_Quote] => California Automobile [ZIP_/_Postal_Code] => 110092 [E-Mail_Address] => rahulsingh4ut@gmail.com [Primary_Phone_Number] => 8470016156 [Alternate_Phone_Number] => 7503963073 [Date_of_Birth] => 25/05/1990 [Marital_Status] => Single [License_(State,_Number)] => DLI123 [Year] => 2012 [Make] => TVS [Model] => Apache 160 [VIN] => TVS123 [Cylinders] => CY000 [Do_you_rent_or_own_your_home?] => Rent [Do_you_currently_have_insurance?] => No [Current_Insurance_Provider] => No I. Prov [last_insurance] => No [Comprehensive_Deductible] => No [Collision_Deductible] => No [Bodily_Injury_Liability] => Bodily [Property_Damage_Liability] => Property Damage [Uninsured_Motorist_Bodily_Injury] => Uninsured [Uninsured_Motorist_Property_Damage] => Motorist Property Da [Underinsured_Motorist_-_Bodily_Injury_Limits] => Motorist - Bodily [Underinsured_Motorist_-_Property_Damage_Limits] => 05 [Medical_Pay_/_PIP] => 2016 [Towing] => Delhi [What_percentage_of_your_vehicles_total_use_time_is_driven_by_you?] => 45 [How_many_miles] => 15000 [accidents_or_minor_violations] => 5Yr )
I think you post data into database using serialize function and retrive data using unserialize function. this is best
$serialized_data = serialize(array('Math', 'Language', 'Science'));
echo $serialized_data . '<br>';
You can't really store Arrays in MySQL, however you have the option of converting your array either to JSON String or Serialized String. It would be difficult to visualize storing an Arrayin MySQL Database... You could do something like this (for example):
<?php
// THIS IS JUST AN EXAMPLE, IN REALITY, YOU HAVE TO CLEAN UP
// ALL THE DATA COMING FROM YOUR $_POST GLOBAL TO AVOID RISKS OF SQL INJECTION.
$postDataForDB = json_encode($_POST);
// NOW YOU CAN SAVE THE RESULTING JSON ENCODED DATA TO DATABASE...
Alternatively; you could use a Serialized version of the Data as well like so:
<?php
// AGAIN; THIS IS JUST AN EXAMPLE, IN REALITY, YOU HAVE TO CLEAN UP
// ALL THE DATA COMING FROM YOUR $_POST GLOBAL TO AVOID RISKS OF SQL INJECTION.
$postDataForDB = serialize($_POST);
// NOW YOU CAN SAVE THE RESULTING SERIALIZED DATA TO DATABASE...