Tag: serialize

How to Store a PHP Array in MySQL

Store Array in MySQL PHP
Save a PHP array in mySQL column This article explores how to save PHP arrays in MySQL. MySQL is an open-source relational database management system that allows you to store data in rows and columns. SQL stands for Structured Query Language for manipulating and retrieving data from SQL databases. Know more about MySQL. Before You Read! The article requires you to connect to your MySQL database with PHP, create a table and connect to it in PHP. If you’re not familiar with all these consider learning it from w3schools. Here we just focus on different ways of storing arrays in MySQL PHP. Storing Arrays in a Normalized Table Employees Table You need to create an employee table at your end if you’re trying out the examples in the article. For your convenience, here’s the SQL table creation code for you. CREATE TABLE EMPLOYEES_TABLE ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,…

read more

Best ways to store PHP arrays to data sources

store php array
How to store PHP array <?php $array = [ "HotelName" => "Shelton Inn", "RoomRate" => "200", "Currency" => "USD", "Amenities" => ["Free Wi-fi","Gym and Spa","Free Parking", "Complimentary buffet"], ]; // Encode array into JSON and store $jsonEncoded = json_encode($array, JSON_PRETTY_PRINT); // Serialize array and store $serialize = serialize($array); // Now you can store the formatted array in MySQL or other data storage ?> Stay tuned until the end to learn more about storing PHP arrays. Introduction PHP arrays are fundamental data structures for storing multiple data objects in memory. However, most real-time applications require data persistence which means storing data permanently in a data source - usually a database or a file in more simple applications.  Data storage is the last step, and before that, PHP needs to convert the array to a data exchange format like JSON, CSV, or just text. This article explores some best ways to store…

read more

PHP serialize vs json_encode

php serialize vs json_encode
Data formats are interchangeable and this allows you to move back and forth between different data formats. This data transformation is usually necessary for data storage, transfer, and communication over a network in computers. The two most renowned data formats are JSON, XML, and CSV. JSON is quite common these days as RESTful APIs use JSON, thus many applications use JSON data to communicate with servers. The image below shows a glimpse of a computer communicating with a server using JSON data. Many programming languages feature a built-in serialization interface that provides features for data transformation, usually specific to a programming language. Unlike JSON, XML, and CSV, serialized data is in the form of an encoded text, as we’ll see later.  In this article about PHP serialize vs json_encode, we’ll explore serialization in PHP. We’ll see serialize function and compare it to json_encode. So, let’s move forward without any further…

read more