Hello, Can anyone see why "fwrite ($JSONFile,$json);" is ONLY writing 1 record to the file (see first post)?
Thanks. meerkat On Feb 10, 9:08 am, "meerkat" <[email protected]> wrote: > 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
