public function testWhereQuery() { $soql = new SoqlQuery(); $soql->where("state = 'AR'"); $results = $this->dataset->getDataset($soql); foreach ($results as $result) { $this->assertEquals($result['state'], 'AR'); } }
// You may also use "include_once," "require," or "require_once" include "phpsoda-0.1.0.phar"; // PhpSoda organizes its code inside namespaces; in order to use PhpSoda, you'll have to "use" the namespaces. These // three namespaces should suffice for most code. use allejo\Socrata\SodaClient; use allejo\Socrata\SodaDataset; use allejo\Socrata\SoqlQuery; // If someone has pushed the "Submit" button, this'll be set to true $postBack = $_SERVER['REQUEST_METHOD'] == 'POST'; if ($postBack) { // Our client will store information about the host, token, and authentication (if necessary) $sc = new SodaClient("data.seattle.gov", "B0ixMbJj4LuQVfYnz95Hfp3Ni"); $ds = new SodaDataset($sc, "pu5n-trf4"); // Build a SoqlQuery with functions $soql = new SoqlQuery(); $soql->where("within_circle(incident_location, {$_POST['latitude']}, {$_POST['longitude']}, {$_POST['range']})")->limit(20); // Get the dataset. $results is now an associative array in the same format as the JSON object $results = $ds->getDataset($soql); } ?> <html> <head> <title>Seattle Police Department 911 Incident Response</title> </head> <body> <h1>Seattle Police Department 911 Incident Response</h1> <?php if (!$postBack) { ?>