GoFuckYourself.com - Adult Webmaster Forum - View Single Post

mkx · 12-15-2009, 08:49 PM

I have the following modem response being inserted into a field on a mysql database:

This is the complete contents of the field:

Code:

AT+SSS="SHOW"

+CT: 0,"OK","+974941949",,"09/12/15,03:06:18+00"
Sup
+CT: 1,"OK","+974941949",,"09/12/15,14:26:36+00"
Yo
+CT: 2,"OK","+974941949",,"09/12/15,22:30:51+00"
Test
OK

I want to automatically reinsert certain parts of this field into a new table (called modem2 lets say) and divide them into 5 different fields

FIELD NAMES =
CT, STATUS, FROM, TIME, MESSAGE

EXAMPLE FIELD INSERTIONS
0, OK, +974941949, 09/12/15,03:06:18+00, Sup
1, OK, +974941949, 09/12/15,14:26:36+00, Yo

Anyone know how or where I can find out how to do this? Seems pretty simple if I only knew a bit more php

12-15-2009, 08:49 PM
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	PHP and MYSQL insert question I have the following modem response being inserted into a field on a mysql database: This is the complete contents of the field: Code: AT+SSS="SHOW" +CT: 0,"OK","+974941949",,"09/12/15,03:06:18+00" Sup +CT: 1,"OK","+974941949",,"09/12/15,14:26:36+00" Yo +CT: 2,"OK","+974941949",,"09/12/15,22:30:51+00" Test OK I want to automatically reinsert certain parts of this field into a new table (called modem2 lets say) and divide them into 5 different fields FIELD NAMES = CT, STATUS, FROM, TIME, MESSAGE EXAMPLE FIELD INSERTIONS 0, OK, +974941949, 09/12/15,03:06:18+00, Sup 1, OK, +974941949, 09/12/15,14:26:36+00, Yo Anyone know how or where I can find out how to do this? Seems pretty simple if I only knew a bit more php