send gps data to mySql

[dickthedev]

Hi, I am trying to send the GPS Data to an existing php script to write to a MySQL database,

-(void) sendGPS {
NSLog(@"Sending URL");
NSURL *urlToSend = [[NSURL alloc] initWithString: @"http://www.myserver.com/phpscript.php?latitude=66.6666&longitude= 55.5555&altitude=44.4444"];

NSURLRequest *urlRequest = [NSURLRequest requestWithURL:urlToSend
cachePolicy:NSURLRequestReturnCacheDataElseLoad
timeoutInterval:30];
NSURLConnection *theConnection=[[NSURLConnection alloc] initWithRequest:urlRequest delegate:self];
[urlToSend release];
[theConnection release];
}

What I did was using a NSTimer to call sendGPS every 10 minutes, What I can't figure out is why when the timer calls for the first time, the php script writes to the mySql database, but the subsequence calls, do not write any more, I am wondering if it's something wrong with this code, or the problem with th webserver configuration or something wrong with the php script?

[baja_yu]

For start, [code] tags please.

Second, this is very easy to pinpoint. Does your PHP script receive a message from your app on subsequent times, try logging this, if it does, then the problem is on the server side, if not, then it's in the app code.

[dickthedev]

The problem seems to be timer related but I just don't know what it is, if I make a sequence of calls to the sendGPS a lot of [self sendGPS]s from ViewDidLoad, every single one is recorded in MySQL, once I put it in the timer
only the first time is recorded, I tried different time interval, from 1.0 to 10.0
the result is the same.

[MattW]

Originally Posted by dickthedev

The problem seems to be timer related but I just don't know what it is, if I make a sequence of calls to the sendGPS a lot of [self sendGPS]s from ViewDidLoad, every single one is recorded in MySQL, once I put it in the timer
only the first time is recorded, I tried different time interval, from 1.0 to 10.0
the result is the same.

Post your timer setup code....

Have you put an NSLog() or a breakpoint in your sendGPS() function to make sure it's actually getting called multiple times?

[smithdale87]

where do you set up the timer? Is it set to repeat=YES?

[dickthedev]

Thanks all for replying.

Originally Posted by smithdale87

where do you set up the timer? Is it set to repeat=YES?

Yes and yes,

@MattW yes, at the beginning of the selector, I have a NSLog(@"Sending URL");
In the debug log, it shows the selector was called at the intended time interval.

[dickthedev]

Originally Posted by MattW

Post your timer setup code....

Have you put an NSLog() or a breakpoint in your sendGPS() function to make sure it's actually getting called multiple times?

my timer code setup is just a generic code, nothing out of the ordinary, but I will let you be the judge of that, so here it is:

-(void) GPSTrackingTimer {
    trackingTimer = [NSTimer scheduledTimerWithTimeInterval:5.0
                                     target:self 
                                   selector:@selector(sendURL) 
                                   userInfo:nil 
                                    repeats:YES];
    
}

and GPSTrackingTimer is called in viewDidLoad [self GPSTrackingTimer];

[mariano_donati]

Originally Posted by dickthedev

my timer code setup is just a generic code, nothing out of the ordinary, but I will let you be the judge of that, so here it is:

-(void) GPSTrackingTimer {
    trackingTimer = [NSTimer scheduledTimerWithTimeInterval:5.0
                                     target:self 
                                   selector:@selector(sendURL) 
                                   userInfo:nil 
                                    repeats:YES];
    
}

and GPSTrackingTimer is called in viewDidLoad [self GPSTrackingTimer];

Shouldn't it be sendGPS rather than sendURL on your timer's selector?