PHP - Horizontal Scaling (how To Keep Code Identical?)

When I asked about adding a watermark to a video, this was suggested: "when scaling it, I'd do h/5:w/5 (of the source video), then position would be w/20 (5% from the left) and h-h/3 (75% of the way down)

When I asked about adding a watermark to a video, this was suggested: "when scaling it, I'd do h/5:w/5 (of the source video), then position would be w/20 (5% from the left) and h-h/3 (75% of the way down)"

I'd like to try that, but I don't know how to integrate that into my existing working code:

 $ffmpegCommand =''.$ffmpeg_b.' -y -i '.$video_file_full_path.' -i '.$watermark_image_full_path.' -filter_complex "scale=426:-2, overlay=10:10, " -vcodec libx264 -preset '.$pt->config->convert_speed.' -crf 26 '.$video_output_full_path_240.' 2>&1';

I've looked at the ffmpeg documentation, but need additional assistance. any help is appreciated

 

 

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');

 

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

I'm surely doing something wrong here, but I just cannot see it.  Any assistance will be greatly appreciated.

In a login script I read the following two variables from an SQL database.  Both fields are defined as int.

$this->ScheduleA = $rs->fetchCol('ScheduleA');
$this->SchedConst = $rs->fetchCol('SchedConstant');



Later, I retrieve these variables and attempt to compare them.

$schA = $sess['ScheduleA'];
$schC = $sess['SchedConst'];

if ($schA == $schC) {
   require('Testing.php');
   }
else {
   require('NotAllowed.php');
   }


They never compare as equal, even though they contain the same value.  What, pray tell, am I missing?

Trying to create a very simple API script sending XML data. When I send the "hard coded" XML, it works perfectly. When I add a form to supply the data for the XML, I get a 500 Internal Server error. Have tried it on two different servers. No error in the logs. Stumped.

Examples below are VERY simplified (and obviously won't do anything as-is) to show what I'm dealing with.

This one works fine:

<?php
$xml = "<Order><UserId>foo</UserId><Password>foo</Password><Mode>Test</Mode><Name>Charles R. Hodges</Name>";
$xml .= "</Order>"; 

$url = 'http://sitename.com';
$ch = curl_init($url);
 
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$response = curl_exec($ch);
curl_close($ch);
$xml = simplexml_load_string($response);
print_r($xml);
?>

And then I use this one and all heck breaks loose with the 500 Internal Error:

<?php
if (isset($_POST['submit'])) {
$xml = "<Order><UserId>foo</UserId><Password>foo</Password><Mode>Test</Mode><Name>{$_POST['name']}</Name>";
$xml .= "</Order>"; 

$url = 'http://sitename.com';
$ch = curl_init($url);
 
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$response = curl_exec($ch);
curl_close($ch);
$xml = simplexml_load_string($response);
print_r($xml);
exit;
}
?>

<html>... etc
<form method="post" action="">
Name: <input type="text" name="name" />
<p><input type="submit" name="submit" "Add to XML string and send" />
</form>
?>