Jump to content

open php in smb url


Roelofzo

Recommended Posts

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 ;
?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.