What is the type this string? a:1:{s:2:”en”;}

by

The datatype you’re showing us here is a serialized variable in PHP.

To serialize or unserialize it, just use these two methods :

http://php.net/manual/en/function.serialize.php

http://www.php.net/manual/en/function.unserialize.php

To store it in MySQL, depends on the size of the serialized data. VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT or BIGTEXT are available.

More Related Contents:

  1. nested json using php and mysql
  2. How to create this type of JSON data from PHP [closed]
  3. How to convert the json image url string into Bitmap image to display images in android application
  4. JSON encode MySQL results
  5. PHP MySQL Google Chart JSON – Complete Example [closed]
  6. The holy grail of cleaning input and output in php?
  7. org.json.JSONException: Value
  8. Send data from android to server via JSON
  9. Sending HTML Code Through JSON
  10. How to build a JSON array from mysql database
  11. UTF-8 character encoding battles json_encode() [duplicate]
  12. How to insert json array into mysql database
  13. how to fetch all the row of the result in php mysql?
  14. The ultimate emoji encoding scheme
  15. How to update multiple MySQL table entries with different id?
  16. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  17. Shortcomings of mysql_real_escape_string?
  18. Alternative to mysql_real_escape_string without connecting to DB
  19. HTML – Change\Update page contents without refreshing\reloading the page
  20. Calculate age based on date of birth
  21. How do I count unique visitors to my site?
  22. php code to test pdo is available?
  23. PHP / MySQL build tree menu
  24. How to create Codeigniter language files from database?
  25. Laravel $q->where() between dates
  26. PHP convert XML to JSON group when there is one child
  27. adding 30 minutes to datetime php/mysql
  28. Create table with PHP and populate from MySQL
  29. How do I save PHP session data to a database instead of in the file system?
  30. Escaping SQL queries in Codeigniter

Leave a Comment