Getting values from php array and outputting to JSON -


i'm new php , i'm trying create webservice. have function select number of rows database preforms correctly (it returns 22 rows) when call function index.php page , output json first row being outputted.

can point me in correct direction?

mysql function:

    public function getstops()     {         //perform query         $result = mysql_query("select station_name station line =   2") or die(mysql_error());          //check result         $numrows = mysql_num_rows($result);          if($numrows > 0)         {             return mysql_fetch_array($result);         }         else         {             return false;         }     }

code in index.php calling getstops() function:

            //check tag request     if ($tag == "greenlinestations")     {         $greenstops = $db->getgreenlinestops();          if ($greenstops != false)         {             //get data , set success = 1             $response["success"] = 1;             foreach ($greenstops $value)             {             $response["stops"]['name'] = $value;             }             echo json_encode($response);         }         else         {             //set error = 1 , out error message             $response["error"] = 1;             $response["error_message"] = "error occured while retreiving stations";             echo json_encode($response);         }     }     else     {         echo "invalid request";     } }

json dump:

    {"success":1,"error":0,"stops":[{"name":{"0":"st. stephen's green","station_name":"st. stephen's green"}},{"name":{"0":"harcourt","station_name":"harcourt"}},{"name":{"0":"charlemont","station_name":"charlemont"}},{"name":{"0":"ranelagh","station_name":"ranelagh"}},{"name":{"0":"beechwood","station_name":"beechwood"}},{"name":{"0":"cowper","station_name":"cowper"}},{"name":{"0":"milltown","station_name":"milltown"}},{"name":{"0":"windy arbour","station_name":"windy arbour"}},{"name":{"0":"dundrum","station_name":"dundrum"}},{"name":{"0":"balally","station_name":"balally"}},{"name":{"0":"kilmacud","station_name":"kilmacud"}},{"name":{"0":"stillorgan","station_name":"stillorgan"}},{"name":{"0":"sandyford","station_name":"sandyford"}},{"name":{"0":"central park","station_name":"central park"}},{"name":{"0":"glencairn","station_name":"glencairn"}},{"name":{"0":"the gallops","station_name":"the gallops"}},{"name":{"0":"leopardstown valley","station_name":"leopardstown valley"}},{"name":{"0":"ballyogan wood","station_name":"ballyogan wood"}},{"name":{"0":"carrickmines","station_name":"carrickmines"}},{"name":{"0":"laughanstown","station_name":"laughanstown"}},{"name":{"0":"cherrywood","station_name":"cherrywood"}},{"name":{"0":"brides glen","station_name":"brides glen"}}]} 

   if($numrows > 0)    {       $return = array();       while($array = mysql_fetch_array($result)){           $return[] = $array;       }       return $return;    }

and :

        $response["success"] = 1;         $response['stops'] = array();         foreach ($greenstops $value){             $response["stops"][]['name'] = $value[0];         }

Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more