Thanks for this. Unfortunately, the client is still using php4
> -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Oblygre > Sent: Tuesday, February 10, 2009 6:02 AM > To: Gears Users > Subject: [gears-users] Re: mysql to json > > > Why don't use file_put_contents ? > From the docs: > file_put_contents > Write a string to a file (PHP 5) > > int file_put_contents ( string filename, mixed data [, int flags [, > resource context]] ) > > Identical to calling fopen(), fwrite(), and fclose() successively. > > You can also specify the data parameter as an array (not multi- > dimension arrays). This is equivalent to file_put_contents($filename, > implode('', $array)). > > As of PHP 5.1.0, you may also pass a stream resource to the data > parameter. In result, the remaining buffer of that stream will be > copied to the specified file. This is similar with using > stream_copy_to_stream(). > > Parameters > filename > The file name where to write the data > > data > The data to write. Can be either a string, an array or a stream > resource (explained above). > > flags > flags can take FILE_USE_INCLUDE_PATH, FILE_APPEND and/or LOCK_EX > (acquire an exclusive lock), however the FILE_USE_INCLUDE_PATH option > should be used with caution. > > context > A context resource > > Return Values > The function returns the amount of bytes that were written to the > file, or FALSE on failure. > > > > On Feb 9, 11:34 pm, meerkat <[email protected]> wrote: > > Hello, > > > > I have the following code to select data from mysql db and save it in > > a json file: > > > > require_once "json_encode.php"; > > $arr = array(); > > $rs = mysql_query("SELECT order_id, order_no, order_no_iteration, > > estimated_completion_date, other_contact_tel FROM orders")or die > > ("Query failed: " . mysql_error() . " Actual query: " . $rs); > > while($obj = mysql_fetch_object($rs)) > > { > > $arr[] = $obj;} > > > > $json = json_encode($arr); > > $JSONFile = fopen("orders.json", "w"); > > fwrite ($JSONFile,$json); > > fclose($JSONFile); > > echo $json; > > > > The "fwrite ($JSONFile,$json);" is ONLY writing 1 record to the file. > > The "echo $json;" is however writing all the records to the browser. > > Looks like a logic error? Can anyone have a look? I want to get onto > > the next stage of reading the data from the json file into the gears > > sqlite db. > > Thanks, meerkat
