PHP - Insert Adds Two Identical Lines

 Thanks ahead of time, I have been working this all week end but get lost....
    a.  I want to insert all the lines from file1.txt into file2.txt .
    b.  I want the all lines in file1.txt to be inserted in file2.txt starting at "<image>"   tag label in file2.txt.
    c. I would like to overwrite all lines that start with the "<image>" tag in file2.txt with the insert (text in file1.txt contains <image> tag also).
 
 file2.txt has lines above  and below the insert point <image>.   The insert text (file1.txt) could be as many as twenty lines (records) all/each beginning with the<image>tag.
Here is what I have done so far.
<?
$key = '<image>';  //a text tag in $file1  and $file2

//copy file 
$file = "file1.txt";
$file2= 'file2.txt";
$newfile = "filetemp.txt";
copy($file, $newfile) or exit("could not copy $file");

//load file array
 $fc = fopen ($file, "r");
 while (!feof ($fc)) 
 {
    $buffer = fgets($fc, 4096);
    $lines[] = $buffer;
 }

fclose ($fc);

//open same file and use "w" to clear file  ,not sure this is needed
$f=fopen($newfile,"w") or die("$file did not open");

/* uncomment to debug
print_r($lines);
print "<br>\n";
*/

//loop through array 'foreach
foreach($lines as $line)
{
       fwrite($f,$line); //rewrite $line in file     
    if (strstr($line,$key)){ //find $key in each line
    fwrite($f,$newline."\n");
    } //rewrite $line in file 
}
fclose($f);

copy($newfile, $file2) or exit("could not copy $newfile");
?>


Again thanks ahead of time,  I just keep losing the flow,  old I guess.

Tom

Hello, is it possible to insert somehow information from textarea to mysql?
For example i have 3 lines in text area:
John Tacker is a bad guy
Tom Tacker has a big nose
Ted Tacker is the same person as John Tacker
and i want to insert them in table's different rows

Good morning to all.

Recently I just read a post here , it's about how to insert different lines from <textarea> to different mysql rows .
http://www.phpfreaks.com/forums/index.php?topic=325239.0

Thanks to AbraCadaver , his code works well.

Quote

$lines = array_map('mysql_real_escape_string', explode("\n", $_POST['textarea']));
$values = "VALUES ('" . implode("'), ('", $lines) . "')";

$query = "INSERT INTO table_name (column_name) $values";


But now if have more than one textarea , such as area1,area2 and area3 , how should change the code so that all data can be inserted into database simultaneously?

Such as data of area1 is for column 1, row 1,
data for area2 is for column2 , row 1,
and data of area3 is for column 3 ,row 1.

Is it possible to make this works?

Thanks for every reply .

Ok, so I have grabbed a free template and attempted to put a dynamic table into one of the div's.  I've got it to work on on my index.php, but I copied and pasted the entire code into member2.php and only changed the query and altered the table just a little bit  For some reason though my table doesn't show up on the member2.php even though 90% of the code is the same.

Here are the pages and codes...

http://www.royalfamilyhosting.com/test/index.php

<div id="layoutBodyContent">
         <h1>Aces Guild Donations Page </h1>
            <h2>Are you on top of your game? WE are!</h2>

           <?PHP


require_once('./mylib.php');
$rank = 1;
$olddate = strtotime(date("Y-m-d"));
$newdate;
$datecounter = 1;

//connects to db
dbconnect();


$query="SELECT name, date, SUM(amount) as total_money, SUM(bricks) as total_bricks FROM Aces_Donations GROUP BY Name ORDER BY total_money DESC, total_bricks DESC";
$result=mysql_query($query);


//Opens the table
echo "<table border = '3' width = 40% bgcolor=#A85045><caption><center>30 Day Rankings".'</center></caption>';

//Loop to run until eof

while($row = mysql_fetch_array($result)){

//turns date into a comparable string
$newdate = strtotime($row['date']);

/*checks to see if date of new record matches date of previous record. If dates dont match the table is closed and a new table is opened for the new date. Rank is reset to reflect rankings for each specific date*/
if($newdate !== $olddate){
$olddate = $newdate;
$datetracker++;
if($datetracker == 30){

echo "<center><tr><td alignment = 'center'>".$rank."</td> <td alignment = 'center'>".$row['name']. "</td><td  alignment = 'center'>". $row['total_money']."</td><td alignment= 'center'>".$row['total_bricks']."</tr></table></center>";
break;
}
}
echo "<center><tr><td alignment = 'center'>".$rank."</td> <td alignment = 'center'>".$row['name']. "</td><td  alignment = 'center'>". $row['total_money']."</td><td alignment= 'center'>".$row['total_bricks'].'</td></tr>';

echo '<br />';
$rank++;

}
echo '</table>';

?>


<br /><br /></p>
        </div>


http://www.royalfamilyhosting.com/test/member2.php?member=Zneve08

<div id="layoutBodyContent">
         <h1>Aces Guild Donations Page </h1>
            <h2>Are you on top of your game? WE are!</h2>

           <?PHP


require_once('./mylib.php');
$membername = $_GET['member'];
$rank = 1;
$olddate = strtotime(date("Y-m-d"));
$newdate;
$datecounter = 1;

//connects to db
dbconnect();


$query = sprintf("SELECT * FROM `Aces_Donations` WHERE `name` = '%s'",
$membername);

//sets the results to a variable
$result = mysql_query($query) or die(mysql_error());

//opens table, sets width, color, border and headers

echo '<table bgcolor=#A85045 border = "3" width = 40%>';
echo "<tr><th alignment = 'center'>Member</th>
<th alignment = 'center'>Amount</th><th alignment = 'center'>Date</th></tr>";

while($row = mysql_fetch_array($result)){
echo "<center><tr><td alignment = 'center'>".$row['name']. "</td><td alignment = 'center'>". $row['amount']."</td><td alignment  = 'center'>".$row['date']."</td></tr></center>";
var_dump ($row['name']);
var_dump ($row['amount']);
echo "<br />";
}
echo '</center></table>';

?>


<br /><br /></p>
        </div>

I'm dying here and would love even shot in the dark at this point.  The php code on member2.php works just fine when executed on its own page, so I don't really understand how this is happening.  I put the var_dump in there just to make sure the data was being retrieved from the database, but the table should be positioned where the var_dump displays on the page

When a file is uploaded, I wish to determine whether an existing identical file (regardless of what it is named or what extension it has) already exists and if so don't save the newly uploaded file but just point it to the existing one.  My primary reason for doing so is not really to save hard drive space but to be able to manage duplicate documents.

One option is to store a hash of the documents in the DB and when a new document is uploaded, query the DB to see if an identical hash exists.  How certain can one be that two hashes will never be duplicated?

Another option is to compare the byte stream.  For this, I would first query the DB to see if a file with same size and media type exists, and then compare the document to all existing files which have that same criteria.

Or many some other approach?

Recommendations?

Thanks

 

<?php

error_reporting(E_ALL);
ini_set('display_startup_errors', 1);
ini_set('display_errors', 1);

function compareFilesTest(string $file_a, string $file_b)
{
    $time = microtime(true);
    display($time, $file_a, $file_b, 'compareFilesTest', compareFiles($file_a, $file_b));
}
function compareFilesTest2(string $file_a, string $file_b)
{
    $time = microtime(true);
    display($time, $file_a, $file_b, 'compareFilesTest2', identical($file_a, $file_b));
}

function compareFilesHashTest(string $file_a, string $file_b, string $algo = 'md5')
{
    $time = microtime(true);
    display($time, $file_a, $file_b, 'compareFilesHashTest', hash_file($algo, $file_a)===hash_file($algo, $file_b), $algo);
}

function display(float $time, string $file_a, string $file_b, string $test, bool $status, string $algorithm=null)
{
    printf("\n%s\nFile1: %s\nFile2: %s\nStatus: %s\nTime (uS): %d\n", $test.($algorithm?" ($algorithm)":''), $file_a, $file_b, $status?'EQUAL':'NOT EQUAL', 1000000*(microtime(true) - $time));
}

function compareFiles(string $file_a, string $file_b):bool
{
    if (filesize($file_a) == filesize($file_b))
    {
        $fp_a = fopen($file_a, 'rb');
        $fp_b = fopen($file_b, 'rb');

        while (!feof($fp_a) && ($b = fread($fp_a, 4096)) !== false) {
            $b_b = fread($fp_b, 4096);
            if ($b !== $b_b)
            {
                fclose($fp_a);
                fclose($fp_b);
                return false;
            }
        }

        fclose($fp_a);
        fclose($fp_b);

        return true;
    }

    return false;
}

function identical($fileOne, $fileTwo)
{
    if (filetype($fileOne) !== filetype($fileTwo)) return false;
    if (filesize($fileOne) !== filesize($fileTwo)) return false;

    if (! $fp1 = fopen($fileOne, 'rb')) return false;

    if (! $fp2 = fopen($fileTwo, 'rb'))
    {
        fclose($fp1);
        return false;
    }

    $same = true;

    while (! feof($fp1) and ! feof($fp2))
        if (fread($fp1, 4096) !== fread($fp2, 4096))
        {
            $same = false;
            break;
        }

        if (feof($fp1) !== feof($fp2)) $same = false;

    fclose($fp1);
    fclose($fp2);

    return $same;
}

$path = __DIR__.'/test_documents/';

//print_r(hash_algos());

compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx');
compareFilesHashTest($path.'file1.txt', $path.'file2.md');
compareFilesHashTest($path.'file1.txt', $path.'file3.txt');

compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg', 'sha256');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf', 'sha256');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg', 'sha256');
compareFilesHashTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx', 'sha256');
compareFilesHashTest($path.'file1.txt', $path.'file2.md', 'sha256');
compareFilesHashTest($path.'file1.txt', $path.'file3.txt', 'sha256');

compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg');
compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf');
compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg');
compareFilesTest($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx');
compareFilesTest($path.'file1.txt', $path.'file2.md');
compareFilesTest($path.'file1.txt', $path.'file3.txt');

compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpg');
compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c1c96440_MasterFormat-2016.pdf');
compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'x602a9c07af00c_IMG_1225.jpg');
compareFilesTest2($path.'602a9c07af00c_IMG_1225.jpg', $path.'602a9c07af00c_IMG_1225.jpgx');
compareFilesTest2($path.'file1.txt', $path.'file2.md');
compareFilesTest2($path.'file1.txt', $path.'file3.txt');