PHP - Text File New Line Character

I have a PHP file that is executed via batch file very frequently for live updating. This is a sort of "sync" file for reading/writing to a MySQL database. I am able to get it functioning absolutely fine when executed manually via a web browser (and my echo debug lines output the expected information), yet when I run the same PHP file via the command line, it seems to just not be capable of opening any file for reading, so the equivalent variables that are correct when executed on a web browser are blank when echoed through the command line.

Is there a different way of handling reading of files when running a php script via the command line, or should it function exactly the same as when run via a browser?

For instance:

$k = "0";
$line = file("examplefile.log")[$k];
echo $line;

Hi    I am running on Linux scripts with PHP and need help with separating my output on html screen to have different sections. This is my php info below   echo "<td bgcolor=\"#00B400\"><a href="$f3"><font size="2">$f1</font></td>" >> $PINGVAIL

Hi i have this edit form that allows user to mofy data but the problems on the text box is that it deletes the rest of the data after the space from the first word i tried to increase the size of the varChars on mysql but did no work why it happens how can i stop from happening??

this the form input
<input type="text" name="name" id="name"  class='text_box' value="<?php echo $_GET['name'];?>"/>

If I was pulling back data from MySQL that was like this "monkeys / dogs / cats", how would I grab just "monkeys" from that using PHP?

In other words, I want to grab all text until a "/" is seen.

I have a script that reads a .gz file into an array and prints the name of each record but will not work on larger files. Is there a way to read 1 line at a time?
Here is the code I have so far.
Code: [Select]
<?php

if ($handle = opendir('.')) {

print "<ol>";
    
    while (false !== ($file = readdir($handle))) {
if($file != '..' && $file!="." && $file!="start_update.php" && $file!="sharons_dbinfo.inc.php" && $file!="root.php" && $file!="read_directory.php" && $file!="read_dir.php" && $file!="new_category.php" && $file!="index.php" && $file!="file_count.php" && $file!="dir_loop2.php" && $file!="dir_loop1.php" && $file!=".htaccess" && $file!="Answer.txt" && $file!="Crucial_Technology-Crucial_US_Product_Catalog_Data_Feed.txt"){
$filename = $file;
$go = filesize($filename);
if($go >= 1){
$filename2 = explode("-", $filename);
$filename2 = $filename2[0];
echo str_replace("_"," ",$filename2) . ' | Filesize is: ' . filesize($filename) . ' bytes<br>';
$gz = gzopen($filename, 'r');
$lines = gzfile($filename,10000);
foreach ($lines as $line) {
$line2 = explode(",", $line);
$line2 = str_replace("," , "-" , $line2);
    echo "<li>".str_replace("," , "-" , $line2[4])."</li><br>";
}

}
}
    }

    closedir($handle);
}
?>
</ol>

I'm importing some text files from my windows servers in to a SQL database, but I'm running in to what I think is some sort of issue with either a special character or something to do with UTF-8, or UTF-16... I haven't dealt with this before, so I'm really not even sure.

I read in the file as such:

$handler = fopen($file, "r");
$Data = fread($handler, filesize($file));
fclose($handler);


The text file itself contains the data formatted like this:

Quote

Unable to deliver this message because the follow error was encountered: "This message is a delivery status notification that cannot be delivered.".
The specific error code was 0xC00402C7.

The message sender was <>.

The message was intended for the following recipients.
   OnlineHelp@somedomain.com



If I simply echo out this data:

echo $Data


It'll come out in Firefox like the following. And I can see FF is choosing to view it as Western (ISO-8859-1), but if I choose to use Unicode (UTF-16) then the data displays correctly.
Quote

U�n�a�b�l�e� �t�o� �d�e�l�i�v�e�r� �t�h�i�s� �m�e�s�s�a�g�e� �b�e�c�a�u�s�e� �t�h�e� �f�o�l�l�o�w� �e�r�r�o�r� �w�a�s� �e�n�c�o�u�n�t�e�r�e�d�:� �"�T�h�i�s� �m�e�s�s�a�g�e� �i�s� �a� �d�e�l�i�v�e�r�y� �s�t�a�t�u�s� �n�o�t�i�f�i�c�a�t�i�o�n� �t�h�a�t� �c�a�n�n�o�t� �b�e� �d�e�l�i�v�e�r�e�d�.�"�.� � � � �T�h�e� �s�p�e�c�i�f�i�c� �e�r�r�o�r� �c�o�d�e� �w�a�s� �0�x�C�0�0�4�0�2�C�7�.� � � � � � �T�h�e� �m�e�s�s�a�g�e� �s�e�n�d�e�r� �w�a�s� �<�>�.� � � � � � �T�h�e� �m�e�s�s�a�g�e� �w�a�s� �i�n�t�e�n�d�e�d� �f�o�r� �t�h�e� �f�o�l�l�o�w�i�n�g� �r�e�c�i�p�i�e�n�t�s�.� � � �O�n�l�i�n�e�H�e�l�p�@�E�l�i�t�e�R�a�c�i�n�g�.�c�o�m� � �



And finally, if I try to insert the data in to SQL, the data looks like this:

Quote

INSERT INTO Badmail VALUES(
      2
      , '00360053425643112201000000004.BDR'
      , 'U n a b l e   t o   d e l i v e r   t h i s   m e s s a g e   b e c a u s e   t h e   f o l l o w   e r r o r   w a s   e n c o u n t e r e d :   " T h i s   m e s s a g e   i s   a   d e l i v e r y   s t a t u s   n o t i f i c a t i o n   t h a t   c a n n o t   b e   d e l i v e r e d . " .
 
 
 
 T h e   s p e c i f i c   e r r o r   c o d e   w a s   0 x C 0 0 4 0 2 C 7 .
 
 
 
 
 
 T h e   m e s s a g e   s e n d e r   w a s   < > .
 
 
 
 
 
 T h e   m e s s a g e   w a s   i n t e n d e d   f o r   t h e   f o l l o w i n g   r e c i p i e n t s .
 
     O n l i n e H e l p @ S o m e d o m a i n . c o m
 
 '
      , '2010-11-30 07:17:05'
      , GETDATE())




So basically, I'm not really sure if I'm supposed to convert the ASCII to UTF-8 or if I just need to do a bunch of str_replace to correct the data before inserting.
I'd appreciate any feedback or suggestions anyone has.

Thank you.

I have a PHP Form where users have to enter and upload a file but when they click upload everything is working except that it is only sending first character of text field to Database!

Can any one help??

Thanks

File upload.php form
Code: [Select]
<form action="add_file.php" method="post" enctype="multipart/form-data">
           <p><br>
      JobID:
        <input name="JobID" type="text" value="<?php echo $row_Recordset1['JobID']; ?>" readonly="readonly" />
    </p>
    <p>Company ID:
      <input name="CompanyID" type="text" value="<?php echo $row_Recordset1['CompanyID']; ?>" readonly="readonly" />
  </p>
    <p>UserID:
      <input name="UsersID" type="text" />
    </p>
    <p>Select File to upload:
      <input type="file" name="uploaded_file" />
  </p>
    <p>Make Sure All Details Are Correct before Submitting!</p>
    <p>
      <input type="submit" value="Submit Application" />
    </p>
        <form>   

add_file.php

// Check if a file has been uploaded
if(isset($_FILES['uploaded_file'])) {
    // Make sure the file was sent without errors
    if($_FILES['uploaded_file']['error'] == 0) {
        // Connect to the database
        $dbLink = new mysqli('localhost', 'user', 'password', 'phpsite');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $JobID = $dbLink->real_escape_string($_POST['JobID']['JobID']);
      $CompanyID = $dbLink->real_escape_string($_POST['CompanyID']['CompanyID']);
      $UsersID = $dbLink->real_escape_string($_POST['UsersID']['UsersID']);
      $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
       $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
        $query = "
            INSERT INTO `application` (
                `JobID`, `CompanyID`, `UsersID`, `name`, `mime`, `size`, `data`, `N_DateAndTime`
            )
            VALUES (
                '{$JobID}', '{$CompanyID}', '{$UsersID}', '{$name}', '{$mime}', {$size}, '{$data}', NOW()
            )";
 
 
        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your job application was successfully sent!';
        }
        else {
            echo 'Error! Failed to insert the file, please try again'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded, please try again. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent! Please try again!';
}
 
// Echo a link back to the main page
echo '<p>Click <a href="year1index.php">here</a> to go back</p>';
?>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hi guys, I did read allot of documentation on the internet about reading/writing/parsing an XML file. I ended up using the following code, because I really have large files (some about 200MB) and regular dom does not work:

while ($xml->read()) {
switch ($xml->nodeType) {
case (XMLReader::ELEMENT):
if ($xml->localName == "job") {
$node = $xml->expand();
$dom = new DomDocument();
$n = $dom->importNode($node,true);
$dom->appendChild($n);
$job = simplexml_import_dom($n);


The problem I have is a special character error in the xml file, error returned on this line: "$node = $xml->expand();"

I am literally banging my head to the wall to find a simple solution to this. I already have a cleaning function, but that can be applied only after the code above. As the file is large, to clean it, I would have to use the same code above to work on partial content at once, so I would have the same special character problem when I would try to read and split the file.

I bet I am not the first one to be in this situation, but after about 5 hours of searching on the internet, I cannot do it no more. And I am not a php expert to come up with a new idea.

One other thing to do probably would be to split the file into multiple files, and read them after that, without using the XMLReader. But this would ask for a different application.

If, for example, on a file where I have an error, I do the reading with simplexml, without using the XMLReader, I don't get the error. But I cannot use simplexml on the files, since file size is variable. I have to use a reliable method that works for all situations.

Hopefully someone has an idea to this STUPID situation!

Thanks.

Hello everybody!

Keep in mind I'm new to PHP but get the basics

I'm trying to collect email addresses from a web-form that gets filled out on a website into a simple txt file on the server.  The problem is the emails get appended one right after the other with no spaces so it looks like "user@server.comuser2@server.comuser3@server.com" and so on.  What I'm trying to do is either separate them by a comma, or put them on a new line but whatever I try, it will not accept it.

Anyway, here is the code that I have:

Code: [Select]
$fp = fopen("/home/fullertr/public_html/email_collector.txt","a");
fwrite($fp,$_POST['visitormail' . "\n"]);
fclose($fp);
unset($_POST);
Thanks for any help!

i am trying to pull a .txt file for a class assignment and it is pulling everything except for line 1 any suggestions would be great

html:

<html>
<head>
   <title>Weekly Report</title>
   <link rel ="stylesheet" type="text/css" href="sample.css" />
</head>

<body>
   <h1>Weekly Report</h1>
   <p>
   <form action = "weeklyReport1Boles.php" method = "post" >
      <p>
      <input type = "submit" value = "Display the Report" />
      </p>
   </form>
</body>
</html>

txt.file
1  236.00
2  284.00
3  148.00
4  128.00
5  0.00
6  110.00
7  0.00
8

php file:

<?php

$total = $_POST['total'];   
$avgDailyIncome = $_POST['avgDailyIncome'];   
$badDays = $_POST ['badDays'];      
$paintFile = $_POST ['paintfile'];
$nextDay = $_POST['nextDay'];

$paintFile = fopen("weeklyDataBoles.txt","r");
$week = fgets($paintFile);
$total = 0;   

for ($count = 1; $count <=8; $count = $count +1)   
{     
$nextDay = fgets($paintFile);
$total = $total + $nextDay;
}
$avgDailyIncome = $total/7;
print("<p>TOTAL INCOME FROM PAINT CONTRACTS: ");   
print("$".number_format($total, 2)."</p>");   
print("<p>AVG DAILY INCOME FROM PAINT CONTRACTS: ");   
print("$".number_format($avgDailyIncome, 2)."</p>");   
print("<p>NUMBER OF DAYS with NO INCOME: $badDays.</p>");   

?>
</body>
</html>

Hello,

I'm trying to read the first line of some large files by PHP, which means, the ideal solution does not work:

Quote

   $content = file($file_import);
   
   $fields = explode(",", $content[0]);


Quote

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 110 bytes) in C:\wamp\www\exchange\admin\import.php on line 55



Is there any other way to read only the first line without opening the whole file?

Thanks!!

Hi
I need to read a file and if a line match then proceed, file have content like this

file.txt
Code: [Select]
this is line one
this line two
and this line three
my code:

$content = file_get_contents("file.txt");
if (strstr("this line two", $content)) {
echo 'matched';
} else {
echo 'not matched';
}

but this always give not matched. any help please

hi, im using the following code to read the content of a file, and then add a line to the end of the file.

Code: [Select]
$file = dirname(dirname(dirname(__FILE__))).'/includes/settings.php';
$read = fopen($file, 'r')or die('Opening Error');

$content = fread($read, filesize($file));

fclose($read)or die('Close Error');

if(isset($_POST['cat_bg']))
{
    $write = fopen($file, 'w')or die('Opening Error');
   
    $cat_bg = $_POST['cat_bg'];

    $new_content = $content.'$color[\'cat_header\'][\'background\'] = '.$cat_bg.';';

    fwrite($write, $new_content)or die('Write Error');
   
    fclose($write);
}

however i would like to delete a line from the file before the content in inserted as the new line i am inserting is a duplicate variable with a different value.

Can anyone help?