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

Join & Append PHP Strings: Concatenation Code Examples (2023)

concatenate strings in PHP
How to Concat Strings in PHP to Combine Multiple Strings Together I use several methods for concatenating strings in PHP. The dot operator is the standard method for combining multiple strings together. Sometimes, I also need PHP concat arrays. I use the implode function in these cases. Check out the examples below to learn more about joining & combining PHP strings together. Concat String Code Example: Combine & Append 2 or More Strings to Form a New String // Here's a few quick ways to append to strings in php. // let's setup the base string. $myString = "Start with one string"; // Let's do a quick concatenation example. $myString = $myString . " and add 2nd string. "; // Let's show another way to append and concatenate a string in PHP $myString .= " Here's a 3rd string added. "; // What if we have another variable string that…

read more