Categories: My SQL

php store array in database ?

Array can be stored in database in the form of string.we can use serialize function to make storable representation of array.we can also get back from that string to array using unserialize function.eg.

<?php
$arr=array(“India”,”Pakistan”,”Sri Lanka”,”Bangladesh”);
//process of serialization
$newString=serialize($arr);
//it will produce following output
a:4:{i:0;s:5:”India”;i:1;s:8:”Pakistan”;i:2;s:9:”Sri Lanka”;i:3;s:10:”Bangladesh”;}
//process of unserialization
$arr=unserialize($newString);
print_r($arr);

//it will produce following output
Array ( [0] => India [1] => Pakistan [2] => Sri Lanka [3] => Bangladesh )

?>

Developer Diary

Share
Published by
Developer Diary

Recent Posts

Git Tag Cheat Sheet

Introduction Git tags are an essential feature of version control systems, offering a simple way…

2 months ago

Understanding Web Storage: Cookies, Local Storage

Introduction The methods that browsers employ to store data on a user's device are referred…

2 months ago

Setting up OpenVPN Access Server in Amazon VPC – AWS

Introduction A well-known open-source VPN technology, OpenVPN provides strong protection for both people and businesses.…

3 months ago

Enhance Error Tracking & Monitoring: Integrate Sentry with Node.js & Express.js

Introduction Integrating Sentry into a Node.js, Express.js, and MongoDB backend project significantly enhances error tracking…

3 months ago

Comparing Callbacks, Promises, and Async/Await in JavaScript

Introduction In the world of JavaScript development, efficiently managing asynchronous operations is essential. Asynchronous programming…

5 months ago

How To Secure Nginx with Let’s Encrypt on Ubuntu EC2 Instance

Introduction Let's Encrypt is a Certificate Authority (CA) that makes it simple to obtain and…

6 months ago