PHP - Editing And Updating Text Files

i am trying to delete files for a user, and then update the database with the new bandwhitch/free space.  here is my code:

http://pastebin.com/J2XE9Fip

i just can't figure out where i'm going wrong... 

thanks in advance

Hey,

Currently i have a chat room which calls my database quite frequently... so im thinking i can lower the heavy load from my server by taking it off MYSQL methods and using PHP read/write/delete methods of a text file.

Now i have two issues with this... first one is:
Code: [Select]
<?php
$myFile = "chatlist.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = $Message.'<br/>';
fwrite($fh, $stringData);
fclose($fh);
?>

This writes the most recent line, how ever the next line that gets sent overwrites so theres only ever one line in the txt file =/

Secondly how on earth do you delete a specific line from the file efficiently ? Say for example a line which broke the rules some how like spam was posted etc.

Hope you get shed light on this.

Thanks

Hey guys,

I have a problem with my quote thing, i have a few long quotes that i want to word wrap

My code:
<?php

/**
 * @author Jragon
 * @copyright 2010
 */

    Header ("Content-type: image/gif");
    $textfile = "quotes.txt";
    $quotes = array();
    if(file_exists($textfile)){
        $quotes = explode("\n",file_get_contents($textfile));
        srand ((float) microtime() * 10000000);
        $string = $quotes[array_rand($quotes)];
        $string= wordwrap($string, 50, "\n", true);
    } else {
        $string = "Sig file non-existant...";
    }
    $font = 3;
    $width = ImageFontWidth($font)* strlen($string);
    $height = ImageFontHeight($font);
    $im = ImageCreate($width,$height);
    $x=imagesx($im)-$width ;
    $y=imagesy($im)-$height;
    $background_color = imagecolorallocate ($im, 242, 242, 242); //white background
    $text_color = imagecolorallocate ($im, 0, 0,0);//black text
    $trans_color = $background_color;//transparent colour
    imagecolortransparent($im, $trans_color);
    imagestring ($im, $font, $x, $y, $string, $text_color);
    imagegif($im);
    ImageDestroy($im);
?>

The where the line breake should be there is a strange symbol, also there is a symbol at the end of eatch line.


Thanks

Jragon

Ok i have been working on this for a day+ now. here is my delema

simple .ini text file. when a user makes a change (via html form) it makes the correct adjustments.
problem is the newline issue

1. if i put a "\n" at the end (when using fputs) works great, except everytime they edit the file it keeps adding a new line (i.e. 10 edits there are now 10 blank lines!!!!)
2. if i leave off the "\n" it appends the next "fgets" to that lilne making a mess

Code: [Select]
##-- Loop thruoght the ORIGINAL file
    while( ! feof($old))
    {
        ##-- Get a line of text
        $aline = fgets($old);
       
        ##-- We only need to check for "="
        if(strpos($aline,"=") > 0 )
        {
            ##-- Write NEW data to tmp file
            fputs($tmp,$info[$i]." = ".$rslt[$i]."\n");
            $i++;
        }
        ##-- No Match
        else
        {
            fputs($tmp,$aline."\n");
        }//Checking for match
    }//while eof(old)
   

what in the world is making this such a big deal. i dont remember having this issue in the past
I tried opening with w+, and just w on the temp file

a typical text line would be

some fieldname = some value

the scipt cycles through the file ignoring comments that are "#"


ps
the tmp file will overwrite the origianl once complete

all i really want to know is WHY i cant get the newline to work, and what is the suggested fix

EDIT:
i just tried PHP_EOL and it still appends another newline

Hi,
  I have a 125 X 156 jpeg image with some text underneath in the right column of my home page and the same image and text in the right column of 47 other pages. When I update the image and text in my home page I don't want to do the same 47 other times. So I have placed the image and text in a separate file. I am guessing I  have to insert preg_replace() function at the places where I want the updates to be made. My knowledge of PHP is not that great. So can anyone give me the exact function and parameters I have to use to replace the image and text. I would be very grateful.

So i have this CMS that is used by lots of users and generally they do have rights to edit each others article. So now i'm thinking how can i at least warn them that somebody else is already editing it. Just that.

maybe with sessions? but what happens when a user just closes the windows, will it destroy it. i taught about storing the value to mySQL but again what if the user closes the windows and so on.

i never did this and i could use a boost. thanks guys

Here goes. I am trying to retrieve info. from mySql database and update 3 textfields. I also have 4 selects on the form that need populating during the running of the program. My problem is using console I can see the info - Customer name - but it does not appear in the text field. The onchange request in the DIV container seems to be where it fails. Here are the files I am using:   1. add_an_order.php   <html>
<head>

<title>Add an Order</title>
     
<link href = "css/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="include/jquery-1.11.1.min.js"></script>

</head>

<body>
    
<div id="header"><img src="images/logo.png" /></div>

<div id="nav">
    
    <div id="nav_wrapper">
        <ul>
            <li><a href="index.php">Orders</a></li><li>
            <a href="customers.php">Customers</a></li><li>
            <a href="contacts.php">Contacts</a></li><li>
            <a href="batteries.php">Batteries</a></li><li>
            <a href="#">Queries</a>
            </li>
        </ul>
    </div>
    
</div>

<div id="main">

<?php

echo '<h3 id="menOpt">Add an Order</h3><hr>';

// Check for a form submission.
/*
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        
    $errors = array();
    
    $required_fields = array('customer_name', 'customer_address', 'city', 'telephone');
    foreach ($required_fields as $fieldname) {
        if (!isset($_POST[$fieldname]) || empty($_POST[$fieldname])) {
            $errors[] = strtoupper($fieldname);
        }
    }
    
    if (empty($errors)) {
            
        include ('include/dbconnect.php');
        
        $name = mysqli_real_escape_string($con, trim(strip_tags($_POST['customer_name'])));
        $contact = mysqli_real_escape_string($con, trim(strip_tags($_POST['contact'])));
        $address = mysqli_real_escape_string($con, trim(strip_tags($_POST['customer_address'])));
        $city = mysqli_real_escape_string($con, trim(strip_tags($_POST['city'])));
        $telephone = mysqli_real_escape_string($con, trim(strip_tags($_POST['telephone'])));
        $telephone = preg_replace('/[^0-9]/', '', $telephone);
        
        if (isset($_POST['deepc'])) {
            $deepc = 1;
        } else {
            $deepc = 0;
        }
        
        if (isset($_POST['problemc'])) {
            $problemc = 1;
        } else {
            $problemc = 0;
        }
        
        $problem = mysqli_real_escape_string($con, trim(strip_tags($_POST['problem'])));
        
        if (isset($_POST['blacklist'])) {
            $blacklist = 1;
        } else {
            $blacklist = 0;
        }
        
        if (isset($_POST['pickup'])) {
            $pickup = 1;
        } else {
            $pickup = 0;
        }
        
        
        $query = "INSERT INTO customers (
                    customer_name, contact, customer_address, city, telephone, deep_cycle,
                    problem_customer, problem, blacklist, pickup)
                  VALUES ('$name', '$contact', '$address', '$city', '$telephone', $deepc,
                    $problemc, '$problem', $blacklist, $pickup)";
        
        $r = mysqli_query($con, $query);
        
        if (mysqli_affected_rows($con) == 1) {
                
            echo '<p class="success">Customer has been successfully added.</p>';
            
        } else {
                
            $message = "Could not add customer.";
            $message .= "<br />" . mysqli_error($con);
            
        }
        
        mysqli_close($con);
        
    } else {  // We have errors.
        
        $message = count($errors) . " error(s) on the form.";
        
    }
    
} // End: if ($_SERVER['REQUEST_METHOD'] == 'POST').

*/

// Leave PHP and display the form.
?>

<?php if (!empty($message)) {
    echo '<p class="error">' . $message . '</p>';
} ?>
<?php
// Output list of fields that have errors.
if (!empty($errors)) {
    echo '<p class="error">';
    foreach ($errors as $error) {
        echo $error . '<br />';
    }
    echo '</p>';
}

?>

<div class="container">
    <form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
        <fieldset>
            <label>Business: <span class="important"> *</span><select name="customer_name" id="customer_name" onchange="request_fill(this.value)"
                value="<?php if (isset($_POST['customer_name'])) echo $_POST['customer_name']; ?>" ></select></label>
            <label>Address: <input type="text" name="address" id="add_a"
                value="<?php if (isset($_POST['customer_address'])) echo $_POST['customer_address']; ?>" /></label>
            <label>City: <input type="text" name="city" id="city"
                value="<?php if (isset($_POST['city'])) echo $_POST['city']; ?>" /></label>
            <label>Phone: <input type="text" name="telephone"
                value="<?php if (isset($_POST['telephone'])) echo $_POST['telephone']; ?>" /></label>

            <label>Manufacturer: <span class="important"> *</span><select name="manufacturer" id="manufacturer" onchange="request_mod(this.value)"
                value="<?php if (isset($_POST['manufacturer'])) echo $_POST['manufacturer']; ?>" ></select></label>

            <label>Model: <span class="important"> *</span><select name="model" id="model" onchange="form_yr(this.value)"
                value="<?php if (isset($_POST['model'])) echo $_POST['model']; ?>" ></select></label>
            
            <label>Year: <span class="important"> *</span><select name="battery" id="bat_disp"
                value="<?php if (isset($_POST['battery'])) echo $_POST['year'] ?>" ></select></label>

            <label>Quantity: <span class="important"> *</span><input type="text" name="quantity" id="quantity"
                value="<?php if (isset($_POST['quantity'])) echo $_POST['quantity']; ?>" /></label>
            <label>Warranty ? <input type="checkbox" name="warranty"
                <?php if ($_POST['warranty']) echo " checked"; ?> /></label>
            <label>Exchange ? <input type="checkbox" name="exchange"
                <?php if ($_POST['exchange']) echo " checked"; ?> /></label>
            <input type="submit" name="submit" value="Add Order" /> or
                    <a href="index.php">Cancel</a>
        </fieldset>
    </form>
</div>

<script type="text/javascript" src="include/functions.js"></script>

<script>
$(document).ready(function() {

    $('.container').hide();
    $('.container').fadeIn(1000);

    request_cust();
    request_man();

});
</script>

<?php include ('include/footer.php');           2. request_fill       function request_fill() {

    var cust2 = 'customer';
    var ad = document.getElementById("add_a");
    
    var hr = new XMLHttpRequest();
    hr.open("POST", "battery_parser.php", true);
    hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
    hr.onreadystatechange = function() {

        if(hr.readyState == 4 && hr.status == 200) {

            var dataArray = hr.responseText;

            ad.innerHTML = dataArray[1];
            
        }
    }

    hr.send("&cust2="+cust2);  
}       3. battery_parser.php       <?php   include_once("include/dbconnect.php");   if (isset($_POST['cust2'])) {
        $cust2 = $_POST['cust2'];
        $sql = "SELECT customer_address FROM customers WHERE customer_id = 2";
        $query = mysqli_query($con, $sql);
        $dataString = '';
        while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){
            $add = $row["customer_address"];
            $dataString = $add;  
        }
        mysqli_close($con);
    
        echo $dataString;
        exit();

    } else {
        exit();
    }

?>

I have problem that only last text field  is updated, how should I fix this?

Here's the code
<?php
if(isset($_POST["update"])){
mysql_query("UPDATE categories SET name_category = '".$_POST['category']."'  WHERE ID= ".$_POST['currentCat']." ") or die(mysql_error());
mysql_query("UPDATE podkategorije SET name_subcategory = '".$_POST['subcategory']."'  WHERE id_subCat= ".$_POST['currentSubCat']." ") or die(mysql_error());
 }
?>
<form action="" method="post" >
<?php

//creating texfields from db

$query = "SELECT k.ID, k.name_category, pk.name_subcategory, pk.id_subCat
          FROM `categories` AS k
          JOIN `subcategories` AS pk ON pk.id_mainCat = k.ID";

$result = mysql_query($query) or die(mysql_error());

$currentCat = false;
while($row = mysql_fetch_array($result))
{
    //so it doesn't repeat itself
    if($currentCat != $row['ID'])
    {
        //display of main Categories

?>

<ul>

<li>

<br/><input name="categories" type="text" value="<?php  echo $row['name_category']; ?>" />

</li>

</ul>

<?

$currentCat = $row['ID'];

    }
    //display subcategories

?>

<input name="subcategories" type="text" value="<?php  echo $row['name_category']; ?>" /><br/>

<input type="hidden" name="currentCat" value="<?php echo $row['ID']; ?>" />

<input type="hidden" name="currentSubCat" value="<?php echo $row['id_subCat']; ?>" />

<?
}
?>
<br />
<input type="button" value="Back" onClick="history.go(-1);return true;">
<input type="submit" value="Update" name="update"/>
</form>

I have a folder of .txt files which have an array like this:
0#|#1#|#2#|#3#|#4#|#5#|#6

NOTE: All of the textfiles are md5 hashes.

Every text file has an array like this, (numbers representing the data) and i'm trying to make it so i can access every array an combine it. So in the end i want to know how many text files have the number "6" for the 6th array and so on.

I'm pretty new at PHP, so please be detailed.

Hey!

I have a bunch of text files with one line of text ex. SHS9GW34

I'm trying to write a little php script on my local machine that will take all the files and put all the different codes in the same files in this kind of format:

RGDGIDSG453
EOHBDSBN453
ERGD4535355
etc
etc


Thanks

Just thinking last night trying to speed some things up, how hard is it to have a text file on the server that can only be edited by PHP?

Or is there a way of making a folder unreadable to anyone?, this way I could have all the text files in the non-readable (non-viewable) folder so no user could edit them?

James

Hey,

I'm looking for some PHP code which can read a certain text file i have.
I need to get certain information from this text file.

This is how the text file looks like:

metadataIngester: now executing performAction with token: 9188147351
metadataIngester: result of performAction with token:9188147351
metadataIngester: runtime (ms) for token 9188147351: 9953
inferencer: now executing performAction with token:9188147351
inferencer: result of performAction with token:9188147351
inferencer: runtime (ms) for token 9188147351: 10903
transcoder: now executing performAction with token:9188147351
transcoder: result of performAction with token:9188147351
transcoder: runtime (ms) for token 9188147351: 65456
transcoder: now executing performAction with token:9188147351
transcoder: result of performAction with token:9188147351
transcoder: runtime (ms) for token 9188147351: 83128
streamingServerTransfer: now executing performAction with token:9188147351
streamingServerTransfer: result of performAction with token:9188147351
streamingServerTransfer: runtime (ms) for token 9188147351: 12187
middlewa now executing performAction with token:9188147351
middlewa result of performAction with token:9188147351
middlewa runtime (ms) for token 9188147351: 28148


Now, there are more parts like this with an other tokenID & runtimes.
I need to get the runtime for each token (in this example it will be 9953 + 10903 + 65456 + 83128 + 12187 + 28148 = 209775 (ms)).
I need PHP to display the tokenID + the total time per token.

I have some fairly small text files (2K) which are parsed where certain deliminated fields are replaced with values provided in an associated array.  There will typically be less than 5 replaced fields, and I plan on using preg_replace_callback to find and replace them.   I am contemplating caching the files after being parsed (note that they will only be accessed by PHP, and not directly by Apache).   Do you think doing so will provide any significant performance improvement?   If I do go this route, I would like thoughts on how to proceed.  I am thinking something like the following: Append the filename along with the serialized value of the array, and hash it using md5(). Store the parsed file using name "file_".$hash Get the modification time of the newly created file using filemtime(), and store the value in a new file called "time_".$hash. bla bla bla When the next request comes in to parse a file, create the hash again. If the file exists for the given hash name, and the time file matches filemtime(), use that file, else parse the original file. Is this a good approach?

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.

So far I have managed to create an upload process which uploads a picture, updates the database on file location and then tries to upload the db a 2nd time to update the Thumbnails file location (i tried updating the thumbnails location in one go and for some reason this causes failure)

But the main problem is that it doesn't upload some files

Here is my upload.php

<?php
include 'dbconnect.php';

$statusMsg = '';

$Title = $conn -> real_escape_string($_POST['Title']) ; 
$BodyText = $conn -> real_escape_string($_POST['ThreadBody']) ; 
	 

// File upload path
$targetDir = "upload/";
$fileName = basename($_FILES["file"]["name"]);
$targetFilePath = $targetDir . $fileName;
$fileType = pathinfo($targetFilePath,PATHINFO_EXTENSION);
$Thumbnail = "upload/Thumbnails/'$fileName'";

if(isset($_POST["submit"]) && !empty($_FILES["file"]["name"])){
    // Allow certain file formats
    $allowTypes = array('jpg','png','jpeg','gif','pdf', "webm", "mp4");
    if(in_array($fileType, $allowTypes)){

        // Upload file to server
        if(move_uploaded_file($_FILES["file"]["tmp_name"], $targetFilePath)){

            // Insert image file name into database
            $insert = $conn->query("INSERT into Threads (Title, ThreadBody, filename) VALUES ('$Title', '$BodyText', '$fileName')");
            if($insert){
               $statusMsg = "The file ".$fileName. " has been uploaded successfully."; 

		$targetFilePathArg = escapeshellarg($targetFilePath);
		$output=null;
		$retval=null;
		 //exec("convert $targetFilePathArg -resize 300x200 ./upload/Thumbnails/'$fileName'", $output, $retval);
		 exec("convert $targetFilePathArg -resize 200x200 $Thumbnail", $output, $retval);
		echo "REturned with status $retval and output:\n" ; 
		if ($retval == null) { 
		echo "Retval is null\n" ;
		echo "Thumbnail equals $Thumbnail\n" ; 
		}

            }else{
                $statusMsg = "File upload failed, please try again.";
            } 
        }else{
            $statusMsg = "Sorry, there was an error uploading your file.";
        }
    }else{
        $statusMsg = 'Sorry, only JPG, JPEG, PNG, GIF, mp4, webm & PDF files are allowed to upload.';
    }
}else{
    $statusMsg = 'Please select a file to upload.';
}

//Update SQL db by setting the thumbnail column to equal $Thumbnail
$update = $conn->query("update Threads set thumbnail = '$Thumbnail' where filename = '$fileName'");
            if($update){
               $statusMsg = "Updated the thumbnail to sql correctly.";
		echo $statusMsg ;  } 
else 
{ echo "\n Failed to update Thumbnail. Thumbnail equals $Thumbnail" ; } 


// Display status message
echo $statusMsg;
?>

And this does work on most files however it is not working on a 9.9mb png file  which is named "test.png" I tested on another 3.3 mb gif file and that failed too?

For some reason it returns the following

Updated the thumbnail to sql correctly.Updated the thumbnail to sql correctly.

Whereas on the files it works on it returns

REturned with status 0 and output: Retval is null Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif' Failed to update Thumbnail. Thumbnail equals upload/Thumbnails/'rainbow-trh-stache.gif'The file rainbow-trh-stache.gif has been uploaded successfully.

Any idea on why this is?