How can I send an array from iOS app and create multiple mysql rows using php? -


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