Good morning. I'm just learning PHP, so forgive the basic question...
I have a user that needs to get information from our system and into a flat file so he can then import it over to another DB (Going from Oracle here to Access there so he can manipulate it)
I have created a view in Oracle, then done a basic select in PHP and inserting a pipe(|) character as a separator before and after each item so he can use that as a separator on the import..
Currently this does work and process to the screen (I put a limiter in on my select just for a test) - I dont need it to come back to the screen, ideally it would prompt the user to download the file and let him select a name/location as usual and then he can do whatever he likes with it... How can I get it from going to the regular output on the screen like it is currently to having it ask him how/where to save it and rendering it as a text file?
$sql = "select * from myView where rownum < 1000";
die ("Select Failed!: " .$result->getMessage(). "\n");
echo "There are: <i> " . $result->numRows(). " </i>number of active files in the query.<br>";
while($row =& $result->fetchRow(DB_FETCHMODE_ASSOC))