so in ios app following information stored in nsuserdefaults (latitude, longitude, number of seconds since epoch)
in form of nsmutablearray
of nsstrings
.
each index in array consists of latitude value, longitude value, , seconds since epoch time value. since array can more 1 in size, goal transfer each index of array database (each index of information row in database table).
i send out web request each index assume bad way this.
question: problem not familiar php. guessing way go doing splitting information inside of php? , how loop mysql insert command? not quite sure how this.
ios
- (void)viewdidload { [super viewdidload]; nsuserdefaults *defaults = [nsuserdefaults standarduserdefaults]; nsmutablearray *reportedsightings = [nsmutablearray arraywitharray:[defaults objectforkey:@"reportedsightings"]]; // objects in reportedsightings nsstring following format: "latitude,longitude,secondssinceepoch" // example: "43.993950,-77.720637,1432359000" (without quotations) nsstring *allinformationstring = @""; for(int i=0; i<reportedsightings.count; i++) allinformationstring = [allinformationstring stringbyappendingstring:reportedsightings[i]]; nsurl *url = [nsurl urlwithstring:[nsstring stringwithformat:@"http://example.com/addinformation.php?information=%@", allinformationstring]]; nsdata *data = [nsdata datawithcontentsofurl:url]; }
addinformation.php
<?php $con = mysqli_connect("localhost","user","password","database"); mysqli_set_charset($con, "utf8"); if (mysqli_connect_errno()) { echo "failed connect mysql: " . mysqli_connect_error(); } $information = $_get["information"]; $latitude = $longitude = $secondssinceepoch = mysqli_query($con,"insert informationreported (latitude, longitude, secondssinceepoch) values (''$latitude', '$longitude', '$secondssinceepoch')"); mysqli_close($con); ?>
Comments
Post a Comment