How could I break up this string?
Posted on 2014-12-01
Here's an insert statement:
insert into twitter_test(actor_id,actor_display_name,posted_time,geo_coords_lat,geo_coords_lon,location_name, session_id) VALUES ('actor_id','actor_display_name','posted_time','lat','lon','location_name', 'firstname.lastname@example.org')
I want to isolate the values that are listed after "twitter_test" and convert them into an array. In other words, I want to grab everything between the first set of parenthesis and then store " actor_id, actor_display, posted_time, geo_coords_lat, geo_coords_lon, location_name and session_id as array, array and so on.
How could I do that?
I started working with preg_split and some other things, but I figured it was time to bring the ninjas to the table.
What do you think?