JSON vs. Serialized Array in database [closed]

by
  1. JSON encode() & decode()
    • PHP Version >= 5.0.0
      • Nesting Limit of 20.
    • PHP Version >= 5.2.3
      • Nesting Limit of 128.
    • PHP Version >= 5.3.0
      • Nesting Limit of 512.
    • Small footprint vs PHP’s serialize’d string.
  2. serialize() & unserialize()
    • PHP Version >= 4.0.0
      • Methods are not lost on PHP Datatype Object.
      • __wakeup() magic method called on any object being unserialize. (VERY POWERFUL)
      • It has been noted that it is some times best the base64 encode strings put into the database, and base64 decode strings taken out of the database with this function, as there are some issues with the handling of some white space characters.

The choice is yours.

More Related Contents:

  1. How to repair a serialized string which has been corrupted by an incorrect byte count length?
  2. How do i search from serialize field in mysql database?
  3. Create PHP timestamp to insert into mysql databse [duplicate]
  4. if condition in php and mysql [closed]
  5. PHP – Using PDO with IN clause array
  6. How to get ID of the last updated row in MySQL?
  7. When should I use MySQLi instead of MySQL?
  8. What kind of string is this? How do I unserialize this string? [duplicate]
  9. SQL injections in ADOdb and general website security
  10. php / Mysql best tree structure
  11. How to write a REST API?
  12. Best practice multi language website
  13. Prevent InnoDB auto increment ON DUPLICATE KEY
  14. PHP inserting multiple checkbox AND textbox arrays into MySQL Database
  15. How to know if MySQLnd is the active driver?
  16. How to solve time out in phpmyadmin?
  17. display data from SQL database into php/ html table [closed]
  18. MySQL: Add sequence column based on another field
  19. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  20. Is there a way to show a WHERE clause just for one field in MySQL?
  21. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  22. Change name of Laravel’s created_at and updated_at
  23. How do I get database column names in Laravel?
  24. MySQL Stored Procedure vs. complex query
  25. PDO and MySQL Fulltext searches
  26. How to avoid “Using temporary” in many-to-many queries?
  27. Query on a many-to-many relationship using Doctrine with Symfony2
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. How to use cURL to fetch specific data from a website and then save it my database using php
  30. Connect to a MySQL server over SSH in PHP

Leave a Comment