3v4l.org

run code in 300+ PHP versions simultaneously
<?php $id =1; $SocialHandle = "Facebook,Twitter,LinkIn"; $SocialHandle = explode(",", $SocialHandle); $SociaUrl = "Url1,Url2,Url3"; $SociaUrl = explode(",", $SociaUrl); $sql = "INSERT INTO `social_table`(`id`, `social_handle`, `handle_url`) VALUES"; for ($i = 0; $i < count($SocialHandle); $i++) { $sql .= "($id, '$SocialHandle[$i]','$SociaUrl[$i]'),"; } $sql = rtrim($sql, ','); echo $sql;
Output for 5.5.0 - 5.5.36, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.0 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.30, 8.2.0 - 8.2.25, 8.3.0 - 8.3.13
INSERT INTO `social_table`(`id`, `social_handle`, `handle_url`) VALUES(1, 'Facebook','Url1'),(1, 'Twitter','Url2'),(1, 'LinkIn','Url3')
preferences:
80.43 ms | 408 KiB | 5 Q