Local does not match with online - PHP

Question

This piece of code allows: 1) creation of a folder 2) creation of a backup file 3) elimination of some data present in the db, with respect to a time interval.

In local, this code, works perfectly, having reported it online, instead, creates the folder correctly, creates the file, deletes the values in the db, but does not write the deleted files in the backup file, having tested it, I found myself with some deleted data, not backup.

And this is a problem, so my question is what can it be since the erasure happens but nothing is written?

How do I make a test, fictitious for the $ ok variable to be written?

<?php

$databaseHost = 'xxx';
$databaseName = 'xxx';
$databaseUsername = 'xxx';
$databasePassword = 'xxx';
$connessione = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName);

$query = $connessione->query("
    SELECT *
    FROM Log_sds
    WHERE data_log < DATE_SUB(NOW(), INTERVAL 7 DAY)
");

$results = $query->fetch_all(MYSQLI_ASSOC);
$ok = json_encode($results);

function makeDirectory($path, $mode)
{

    if (!is_dir($path)) {
        return mkdir($path, $mode, true);
    } else {
        echo $path . " already exist!";
    }
}

$path = 'backup_LOG';
$mode = 0777;

// or you can add here that if exist does not call the function makeDirectory
if (!is_dir($path)) {
    $risultato = makeDirectory($path, $mode);
}

$fileName = 'backup_LOG/backup_file_' . date('Y_m_d') . '.txt';
$file = fopen($fileName, 'a');
//$file = fopen($fileName, 'x+');
fwrite($file, $ok);
fclose($file);

if (count($results) > 0) {
    $firstId = reset($results)['data_log'];
    $lastId = end($results)['data_log'];
    //$stmt = $connessione->prepare("DELETE FROM Log_sds WHERE data_log < DATE_SUB(NOW() , INTERVAL 7 DAY)");
    $stmt->bind_param('ii', $firstId, $lastId);
    $stmt->execute();
}
?>

Donny · Answer 1 · 2019-04-08T13:07:20.090

0

It's a folder permission problem.

Allow writing in your online folder

Take a look at this

How do I change permissions for a folder and all of its subfolders and files in one step in Linux?

You can even change permission from PHP with chmod()

// Read and write for owner, nothing for everybody else
chmod("/somedir/somefile", 0600);

// Read and write for owner, read for everybody else
chmod("/somedir/somefile", 0644);

// Everything for owner, read and execute for others
chmod("/somedir/somefile", 0755);

// Everything for owner, read and execute for owner's group
chmod("/somedir/somefile", 0750);

https://www.php.net/manual/fr/function.chmod.php

edited Apr 08 '19 at 13:07

answered Apr 08 '19 at 12:55

Donny

516
3
9

how can i do this? – Apr 08 '19 at 12:55
I was reading, but I don't have to do it for my htdocs, but for an online root, do I run from my cpanel's terminal? isn't there another code level way to test it? – Apr 08 '19 at 12:58
CPanel should allow you to change permissions – Donny Apr 08 '19 at 12:59
@nbs I know. I was asking to the one who did it. However, if my answer helped you please consider to mark it so it can help other people with the same issue – Donny Apr 08 '19 at 13:01
the problem is that I don't have access to the cpanel, that's why I asked you if there was some code test that I could perform? – Apr 08 '19 at 13:03
i put this before the function for creation the folder? – Apr 08 '19 at 13:12
Yes, put it above the function call – Donny Apr 08 '19 at 13:13
ok for fix all i want change my query DELETE FROM Log_sds WHERE data_log < DATE_SUB(NOW() , INTERVAL 7 DAY)") became DELETE FROM Log_sds WHERE data_log < DATE_SUB(NOW() , INTERVAL 7 DAY) AND ID_log = 'number_of_id' ")? it s correct? – Apr 08 '19 at 13:16
// Read and write for owner, nothing for everybody else chmod("upload/backup_LOG/backup_file_' . date('Y_m_d') . '.txt", 0600); // Read and write for owner, read for everybody else chmod("upload/backup_LOG/backup_file_' . date('Y_m_d') . '.txt", 0644); // Everything for owner, read and execute for others chmod("upload/backup_LOG/backup_file_' . date('Y_m_d') . '.txt", 0755); // Everything for owner, read and execute for owner's group chmod("upload/backup_LOG/backup_file_' . date('Y_m_d') . '.txt", 0750); – Apr 08 '19 at 13:21

Local does not match with online - PHP

1 Answers1