php - Retrieve and use entire MYSQL Table in Swift -

-

i've looked around internet have yet come across solution seems should common practice.

i trying write method in swift which, using php backend, retrieves data specific mysql table in database.

in other sections of app (user login etc) have got similar system working, needs return few variables 1 specific user, can return these in json data individual variables , store them in nsuserdictionary use throughout app, easy!

however have table information different 'shops' each row storing various details (location, name etc). want able plot these names onto mkmapview , therefore need retrieve entire table , iterate through each row (shop) within swift. (well that's way can think of accomplishing this).

my issue can figure out how return '1d' json data in php (e.g. location / name etc specific shop), not entire array of shops?

this code i'm using in swift retrieve 1d data user:

        var post:nsstring = "email=\(email)&password=\(password)"          nslog("postdata: %@",post);          var url:nsurl = nsurl(string:"http://www.agentsweep.co.uk/scripts/agentsweep_user_login.php")!          var postdata:nsdata = post.datausingencoding(nsasciistringencoding)!          var postlength:nsstring = string( postdata.length )          var request:nsmutableurlrequest = nsmutableurlrequest(url: url)         request.httpmethod = "post"         request.httpbody = postdata         request.setvalue(postlength string, forhttpheaderfield: "content-length")         request.setvalue("application/x-www-form-urlencoded", forhttpheaderfield: "content-type")         request.setvalue("application/json", forhttpheaderfield: "accept")           var reponseerror: nserror?         var response: nsurlresponse?          var urldata: nsdata? = nsurlconnection.sendsynchronousrequest(request, returningresponse:&response, error:&reponseerror)          if ( urldata != nil ) {             let res = response as! nshttpurlresponse!;              nslog("response code: %ld", res.statuscode);              if (res.statuscode >= 200 && res.statuscode < 300)             {                 var responsedata:nsstring  = nsstring(data:urldata!, encoding:nsutf8stringencoding)!                  var error: nserror?                  let jsondata:nsdictionary = nsjsonserialization.jsonobjectwithdata(urldata!, options:nsjsonreadingoptions.mutablecontainers , error: &error) as! nsdictionary

and backend php part returns it:

if ($result = $mysqli->query("select id, fullname, mobile, mobilepref, address, autofill users email = '$email';")) {                 $userdata = $result->fetch_assoc();                 $result->close();             }                $fullnameresult = $userdata["fullname"];             $idresult = $userdata["id"];             $mobileresult = $userdata["mobile"];             $mobileprefresult = $userdata["mobilepref"];             $addressresult = $userdata["address"];             $autofillresult = $userdata["autofill"];             /* close connection */             $mysqli->close();              if ($id) {                  error_log("user $email: password match.");                   /* reply data:*/                 /*echo '{"success":1,"id":'. $idresult .',"fullname":'. $fullname .',"mobile":'. $mobileresult .',"mobilepref":'. $mobileprefresult .',"address":'. $addressresult .'}';             */                 echo '{"success":1,"idref":"'. $idresult .'","fullname":"'. $fullnameresult .'","mobile":"'. $mobileresult .'","mobilepref":"'. $mobileprefresult .'","address":"'. $addressresult .'","autofill":"'. $autofillresult .'"}';

can give me clear explanation of how process entire table rather 1 row? thank much, up-vote useful answers , select best 1 asap! :)

edit: considered bad thing send data client, imagine you'll have 70,000 results sql, gonna send user 15mb of data? dont think :). should learn how use pagination using skip , limit

answer:

well, first let's improve php code

if ($result = $mysqli->query("select id, fullname, mobile, mobilepref, address, autofill users email = '$email';")) {      $userdata = [];     while ($row = $result->fetch_assoc()){         $userdata[] = $row;     }      //no need write json self, php alone     echo json_encode($userdata);      //add mysqli->close()  }

on swift:

//you did this: let jsondata:nsdictionary = nsjsonserialization.jsonobjectwithdata(urldata!, options:nsjsonreadingoptions.mutablecontainers , error: &error) as! nsdictionary

and iterate on it

for (k,v) in jsondata {    println("jsondata[\(k)] = \(v)") //a row sql result }

Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

sql - MySQL query optimization using coalesce -

-
can explain me why second query faster first? (first 1 takes around 40 seconds, second 1 less 0.1) select releases.feature_code, releases.platform_id, version, release_date, general_available, uri, filesize, display_name, feature_name.full_name, if ((select exists(select 1 release_exceptions releases.feature_code = release_exceptions.feature_code , releases.platform_id = release_exceptions.platform_id , releases.version = release_exceptions.version) = 1), 1, 0) release_exceptions releases left outer join platform using(platform_id) left outer join feature_name using(feature_code) order version desc; ~~~ query 2 ------------------ ~~~ select feature_code, version, release_date, general_available, platform_id, uri, filesize, display_name, feature_name.full_name, coalesce(release_exceptions, 0) release_exceptions mus.releases left outer join ( select distinct feature_code, version, platform_id, 1 release_exceptions mus.release_exceptions ) release_exceptions using ...
Read more

unity3d - Unity local avoidance in user created world -

-
i'm using unity3d networked multiplayer online game have large complex 3d terrain scene forest, trees, cliff, hills, mountains, bounders, etc. players can build structures sort of minecraft, , put them anywhere in scene, or move them around anytime. aside human controlled players, there automated ai players , objects animals roaming around scene following path. the problem how make these automated ai players , animals, able navigate around static , dynamic player created structures, because path follow can blocked player created structures, or other players , other ai objects, cliffs etc. have find away around them or on track if tumble down off high cliff example. so made navmesh , used navagents, takes care of static, non moving objects, how make ai players navigate around each other , dynamic structures created players can number in hundreds? i thought of adding navmeshobstacle everything, result in being attached hundreds of objects since user created structures b...
Read more