How To Echo Values Stored As Array in MYSQL?

Question

Hello Currently I have a MYSQL DB in which I post form data into. I then USE PHP to echo the data out and see the form info. Recently I added a check box and the values of the check box get stored as an ARRAY. When I go to echo my DB the output I get is

Name,Date,Array,Array

Instead of getting the word ARRAY I would like to get the value of the submission. I know you are supposed to use the implode command but I could not figure out a way to incorporate it into my code. The retrieval code looks like this. With field_10,field_11,field_12 returning just the word ARRAY.







  User Sign Ups ";



while($row = mysql_fetch_array($comments, MYSQL_ASSOC))
{

$company=$row['field_1'];
$name=$row['field_2'];
$contact_numb=$row['field_3'];
$email_adress=$row['field_4'];
$conf_yr=$row['field_5'];
$dt_arrival=$row['field_6'];
$arrival_tm=$row['field_7'];
$dt_depart=$row['field_8'];
$departure_tm=$row['field_9'];
$dnr_one=$row['field_10'];
$dnr_two=$row['field_11'];
$cmd_shw=$row['field_12'];


$company = htmlspecialchars($row['field_1'],ENT_QUOTES);
$name = htmlspecialchars($row['field_2'],ENT_QUOTES);
$contact_numb = htmlspecialchars($row['field_3'],ENT_QUOTES);
$email_adress = htmlspecialchars($row['field_4'],ENT_QUOTES);
$conf_yr = htmlspecialchars($row['field_5'],ENT_QUOTES);
$dt_arrival = htmlspecialchars($row['field_6'],ENT_QUOTES);
$arrival_tm = htmlspecialchars($row['field_7'],ENT_QUOTES);
$dt_depart= htmlspecialchars($row['field_8'],ENT_QUOTES);
$departure_tm = htmlspecialchars($row['field_9'],ENT_QUOTES);
$dnr_one= htmlspecialchars($row['field_10'],ENT_QUOTES);
$dnr_two= htmlspecialchars($row['field_11'],ENT_QUOTES);
$cmd_shw= htmlspecialchars($row['field_12'],ENT_QUOTES);


echo "  
    
  Name: $name

  Company: $company

  Contact Number: $contact_numb

   Email Adress: $email_adress

   Conference Year: $conf_yr

   Date of Arrival: $dt_arrival

   Arrival Time: $arrival_tm

   Date of Departure: $dt_depart

   Departure Time: $departure_tm

   Dinner on the 14th?: $dnr_one

   Dinner on the 15th?: $dnr_two

   Comedy Show?: $cmd_shw

  
   ";
    }


  mysql_close($con);

  ?>

The form processing code is this

The Form itself






        
        
                DEMO Conference Sign Up 
                DEMO 
        


        

        

                
                    Company Name  *

                
                    Guest Name  * Enter Guest Name here

                
                    Contact Number  * Enter Phone Number here 

                
                    Email Address * Enter Email Address 

                 

                
                    Date of Arrival * Please select your date of arrival 

                
                    Enter Your Arrival Time * Please Enter the Time you will be arriving to the airport 

                
                    Date of Departure  * Enter the date you will be leaving the conference

                
                    Time of Departure  * Please enter what time you will be departing the conference 

                
                    Dinner October 14th  * Would you like to attend dinner with INFORM applications staff? Yes No 

                
                    Dinner October 15th  * Would you like to attend dinner with members of the INFORM staff? Yes No 

                
                    Do You Want To Attend The Comedy Show ? * A comedy show will be held at the Borgata on Wednesday the 14th  Yes No

Richard · Accepted Answer

It is not possible to store an PHP array in a MySQL database (because of it's type), but you can convert it to string and store this. Of course, you can convert this string later back to an array. You should change a database field to type LONGTEXT to store an array in it.

To store an array in text form, you can use serialize:

$arr = serialize($arr); // To save it in DB
$arr = unserialize($arr); // To get array after select

Or use JSON (better readable in database):

$arr = json_encode($arr); // To save it in DB
$arr = json_decode($arr); // To get array after select

How To Echo Values Stored As Array in MYSQL?

Answers (2)

Related Questions