[caboose9792]

Working from a backup trying to merge the valid data onto the clipped data. From my backup I have tab delimited text in which to insert the correct data from. I wrote a simple (ha ha ha) program to quickly patch the issue. The data from the txt page to the MYSQL makes it ok but no matches are ever found. If I add some code to manually set the variables it works fine. It is like there is two different languages in play there both the same style code and the variables are the same type and I have manually confirmed the data.


Code snip it that the trouble is occurring on:

$fp = fopen ( "tracedata.txt" , "r" );

//feof setting maxamum number of loop with the count of lines to be run

while (!feof($fp)) { $data =fgets ($fp);

$data = preg_split ( "#/\t/#" , $data);

// clean up the split
$road =trim($data[0]);
$numb =trim($data[1]);
$date =trim($data[3]);
$symbol =trim($data[2]);
$notes =trim($data[4]);
//row 35
// mysql adminastrative
$conn = mysql_connect( $mysql_host , $mysql_user , $mysql_password )or die(mysql_error());
$db = mysql_select_db( $mysql_database , $conn )or die(mysql_error());

//mysql serch for $rd , $nm,
$result = mysql_query("SELECT *
FROM `palpower`
WHERE `road` = '$road'
AND `number` = '$numb'
AND `last_date` = '$date'
LIMIT 1
");
print"$row<br>";
$row = mysql_fetch_assoc($result) or die(mysql_error());

[grace1004]

Do you have any specific reason to use preg_split()?
If the delimiter is tab, how about changing as follows:

PHP Code:

$fp = fopen ( "tracedata.txt" , "r" );

while (!feof($fp)) { $data =fgets($fp);
list($road, $numb, $symbol, $date, $notes) = $array
$array = split("\t", $data);

$road = trim($array[0]);
$numb = trim($array[1]);
.
.
.

$row = mysql_fetch_assoc($result) or die(mysql_error()); //This line should come before print command.
print"$row<br>"; 


[Leder678]

grace1004:
The split function is deprecated, so I would use one of the alternatives in the list in the php page:
http://php.net/manual/en/function.split.php

try using print_r to manually check the $data array for any mistakes the split funktion might cause

[grace1004]

Leder678:
The split() function is depreciated as of php 5.3.x. As the php version of 000webhost.com server is
5.2.x, it's still O.K. to use split() function in this hosting.

caboose9792:
In case php version of your hosting server is 5.3.x, you can use explode() function
instead of split() function.

[d3iti]

Hi,

Avoid using files with txt extension. The server usually block / disallow.

[caboose9792]

There isn't ant other options that I aware of and the fear of the TXT is rather irrational. So what TXT like file can 000 host both write and read without running afoul of the TOS and still be usable?

[caboose9792]

Originally Posted by Leder678

grace1004:
The split function is deprecated, so I would use one of the alternatives in the list in the php page:
http://php.net/manual/en/function.split.php

try using print_r to manually check the $data array for any mistakes the split function might cause

*************
I have and everything looks good. if I use

if I preload with valid data such as:
$road= PAL
$numb = 1998
$date = (valid date code)
under the fopen to replace the file data the data passes though correctly. I also have access to the other side of the code that goes from my backup file to the TXT code.


Maybe the issue is on this side:

while ($count <= 499) {

//mysql serch for data if it exist
$result = $result = mysql_query("
SELECT *
FROM `palpower`
WHERE `vpbkey` = '$akey'
LIMIT 1 ")
or die(mysql_error());

$row=mysql_fetch_assoc($result);

$road = $row["road"];
$numb = $row["number"];
$notes = $row["notes"];
$date =$row["last_date"];
$symbol =$row["symbol"];

$newrecord =$road."\t".$numb."\t".$symbol."\t".$date."\t".$no tes."\n";

// file system sign in & out and data preperation

$fp = fopen("tracedata.txt", "a");
fputs ($fp,$newrecord);
fclose($fp);

To further muddy the waters, I was successfully using the program for a few cycles and it worked fine. I stopped to spread my SQL usage out even more than usual and it stopped working when I tried to resume which seems odd in itself. Both sets of data are on 000 host just different servers (if one bits the dust all is not lost). The site itself is a low volume of data and visitor hobby site so there isn't tons of data to be dealt with I just haven't seen anything quite like this before .

[grace1004]

I tested my code above and it did not work. So, I changed it as shown below and it works fine.

PHP Code:

$fp = fopen ( "tracedata.txt" , "r" ); 

while (!feof($fp)) {$data =fgets($fp); 
list($road, $numb, $symbol, $date, $notes) = explode("\t", $data);

$road = trim($road);
$numb = trim($numb); 
. 
. 

echo $road; //To test $road is getting data from the txt file.

.
.
.

$row = mysql_fetch_assoc($result) or die(mysql_error()); //This line should come before print command.
 
print "$row['road']<br>";  
print "$row['number']<br>";
.
.
}
?> 


[grace1004]

Regarding txt file, I found that to use txt file within php script is O.K. in 000webhost.com server.
However, to write something in txt file through cron job is not allowed in this hosting. In case
the file is executed manually (not by cron job), it works fine.

[d3iti]

Originally Posted by grace1004

Regarding txt file, I found that to use txt file within php script is O.K. in 000webhost.com server.
However, to write something in txt file through cron job is not allowed in this hosting. In case
the file is executed manually (not by cron job), it works fine.

Are they working properly txt files?

It's new news to me. Thanks grace1004 for the information.
A greeting.