Roelofzo Posted March 3, 2011 Share Posted March 3, 2011 Hi i have been working on a cow management program PHP based. it works beautifull but now i'm stuck , and i hope i post it in the right forum. On demand php has to generate an export.txt file with basic cow information (tag#, transponder#, Bdate) this will be read by the parlour computer an Eprom based computer serial connected. I finished the script and it creates a beautifull TXt file exxept it's php http://localhost/tmp/test.php if i open that URL in notepad, it prints the txt file: DH9900010090000624000900002080 VH990001 Dairy Comp 305 20100203 DN9900020031200808000300002080003000030300030003508000300357080003001940800030003308000300036020 VN99000200001034000014010052009112620100922201102042001111706 VN99000200001061000009420032010032820100906????????2007120101 VN99000200001083000067850032010061720100927????????2002030706 VN99000200001104000055440052009062720100817201101032002080605 VN99000200001116000078540042010083120110207????????2002082205 VN990002000011470000816800220101226????????????????2003010806 VN99000200001153000070120032010030420100906????????2003020305 but when i enter that URL in the sync.BAT nothing happends.. my question is, doe anyone know if there is a way to fool DOS for accepting a PHP url?. OR is there a way for Apache to treat one TXT file as an PHP file? my script: <?php //request sql cow info $db_host = 'localhost'; $db_user = ''; $db_pwd = ''; $database = 'cowdbase'; $table = 'cows'; if (!mysql_connect($db_host, $db_user, $db_pwd)) die("Can't connect to database"); if (!mysql_select_db($database)) die("Can't select database"); // sending query $result = mysql_query("SELECT * FROM {$table}"); if (!$result) { die("Query to show fields from table failed"); } //quiery alle info $query="SELECT * FROM {$table}"; $result=mysql_query($query); // hoeveel rijen zijn er? $num=mysql_numrows($result); //Type the header from the text file echo "DH9900010090000624000900002080" . PHP_EOL ; echo "VH990001 Dairy Comp 305 20100203" . PHP_EOL ; echo "DN9900020031200808000300002080003000030300030003508000300357080003001940800030003308000300036020" . PHP_EOL ; mysql_close(); $i=0; while ($i < $num) { $cowtag=mysql_result($result,$i,"cowTag"); $bdate=mysql_result($result,$i,"Bdate"); $group=mysql_result($result,$i,"group"); $alpro=mysql_result($result,$i,"Alpro_trans"); // LIST ALLE KOEIEN KOE VOOR KOE /// unknown cowtag unknown-0000 #### Alpro tag 00 Group 20 Fresh dateyymmdd 20 Heatdate yymmdd, Drydate YYYYMMDD, Birthdate YYYYMMDD Lactation number ## echo "VN9900020000" . str_pad($cowtag, 4, "0", STR_PAD_LEFT) . "0000" . str_pad($alpro, 4, "0", STR_PAD_LEFT) . "00" . "$group" . "20" . "0000" . "????????????????" . "00000000" . "01" . PHP_EOL ; $i++; } echo "EN" . PHP_EOL ; echo "ZN" . PHP_EOL ; ?> Quote Link to comment Share on other sites More sharing options...
Roelofzo Posted March 4, 2011 Author Share Posted March 4, 2011 found it!!! the aswer was Wget.exe thanks anyways!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.