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

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.

Related Contents:

  1. JSON encode MySQL results
  2. PHP MySQL Google Chart JSON – Complete Example [closed]
  3. How to build a JSON array from mysql database
  4. The holy grail of cleaning input and output in php?
  5. Send data from android to server via JSON
  6. How can I parse a JSON file with PHP? [duplicate]
  7. MySQL query to get column names?
  8. MySQL vs MySQLi when using PHP [closed]
  9. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client [duplicate]
  10. How do I set ORDER BY params using prepared PDO statement?
  11. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  12. How to resolve ambiguous column names when retrieving results?
  13. Why is mysqli giving a “Commands out of sync” error?
  14. Processing large JSON files in PHP
  15. Fatal error: Call to undefined function mysql_connect()
  16. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  17. Detect bad json data in PHP json_decode()?
  18. Parsing JSON object in PHP using json_decode
  19. How can I loop through a MySQL result set more than once using the mysql_* functions?
  20. how safe are PDO prepared statements
  21. Set PDO to throw exceptions by default [duplicate]
  22. handle json request in PHP
  23. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  24. How do I set the selected item in a drop down box
  25. MySQL – count total number of rows in php
  26. PHP7.1 json_encode() Float Issue
  27. Alternative to mysql_real_escape_string without connecting to DB
  28. Object of class DateTime could not be converted to string
  29. Import file size limit in PHPMyAdmin
  30. Best way to create an empty object in JSON with PHP?
  31. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  32. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  33. MySQL ORDER BY IN()
  34. Is there any way to convert json to xml in PHP?
  35. PHP Create a Multidimensional Array from an array with relational data [duplicate]
  36. Converting Object to JSON and JSON to Object in PHP, (library like Gson for Java)
  37. How do detect that transaction has already been started?
  38. How do I insert multiple checkbox values into a table?
  39. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  40. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  41. Error while using PDO prepared statements and LIMIT in query [duplicate]
  42. Best practice: Import mySQL file in PHP; split queries
  43. Update query with PDO and MySQL
  44. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  45. What is the advantage of using try {} catch {} versus if {} else {}
  46. Aggregated query without GROUP BY
  47. Laravel Cannot delete or update a parent row: a foreign key constraint fails
  48. How can I access an object property named as a variable in php?
  49. How to get primary key of table?
  50. Change name of Laravel’s created_at and updated_at

Leave a Comment