troubleshooting Question

How could I break up this string?

Avatar of Bruce Gust
Bruce GustFlag for United States of America asked on
PHP
9 Comments3 Solutions196 ViewsLast Modified:
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', 'bruce@brucegust.com')

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[0], array[1] 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?
ASKER CERTIFIED SOLUTION
Member_2_248744

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros