How to split an array into single quotes and comma separated list in PHP

How to split an array into single quotes and comma separated list in PHP, When we are working dynamic SQL queries we have to build them using the post array, after splitting the array field key and values into separate array’s. we need to have single quote mark arround the values and it is separated with comma in sql INSERT statement like this.
INSERT INTO table_name (column1, column2, column3) VALUES (‘value1’, ‘value2’, ‘value3’).

Our goal is to achieve the highlighted text from the array, for this we are using implode function, appending single quote mark and comma followed by a space and othe single quote mark.( ‘, ‘ ). If we only use implode function it will insert the between the values, first quote mark and the last quote mark will be missed, for that we are appeding single quote mark at the string starting and the ending. Then we will ge the output what we wanted.

<?php  
$array = array('hi', 'this', 'is', 'an', 'array');
  $comma_list = "'" .implode("', '", $array) . "'"; 
 echo $comma_list; 
?>

Vivek Vengala
 

Vivek Vengala is a Online Entrepreneur, Web Developer from Hyderabad India.

Click Here to Leave a Comment Below 0 comments

Leave a Reply:

x

Join My Facebook Group to Receive Coding Tutorial for Free

email-subsribe