add the content of the file in a variable

[yoyes86]

$query = (new Query('/file/print'))
                ->where('.id', $file['.id']);
$fileContent = $client->query($query)->read();
$content = $fileContent[0]['contents'];

but only the first line of the file is on the variable
How can I have the entire content on the variable?
It s for create the config client ovpn with certificate.

[EvilFreelancer]

Hi! Can you provide more details?

[yoyes86]

Hi, I have a file une Files of Mikrotik and i wanted to copy the content in a variable with this code:

$query = (new Query('/file/print'))
->where('.id', $file['.id']);
$fileContent = $client->query($query)->read();
$content = $fileContent[0]['contents'];

But only the first line of the file is on the variable;

When I debugging, I see the only first line is show on the content:

$filesQuery = (new Query('/file/print'));
files = $client->query($filesQuery)->read();
echo "<pre>Files List: "; print_r($files); echo "</pre>";

Files List: Array
(
    [0] => Array
        (
            [.id] => *D0D23
            [name] => RB2011-3011-BASE.startup-script3 - silent.rsc
            [type] => script
            [size] => 6124
            [creation-time] => may/28/2024 09:30:12
        )

    [1] => Array
        (
            [.id] => *D1AE6
            [name] => cert_export__most_ca_ovpn.crt
            [type] => .crt file
            [size] => 1229
            [creation-time] => may/30/2024 11:31:59
            [contents] => -----BEGIN CERTIFICATE-----
        )

    [2] => Array
        (
            [.id] => *D1AE7
            [name] => cert_export__most_client_ovpn.crt
            [type] => .crt file
            [size] => 1196
            [creation-time] => may/30/2024 11:31:59
            [contents] => -----BEGIN CERTIFICATE-----
        )

    [3] => Array
        (
            [.id] => *D1AE8
            [name] => cert_export__most_client_ovpn.key
            [type] => .key file
            [size] => 1858
            [creation-time] => may/30/2024 11:31:59
            [contents] => -----BEGIN ENCRYPTED PRIVATE KEY-----
        )

)

[anasamu]

fix this
$fileContent = $client->query($query)->read(false);

[fenads]

Forma 1 - If you want to concatenate everything into a string:

$filesQuery = (new Query('/file/print'));
files = $client->query($filesQuery)->read();

$content =' ';

foreach ($fileContent as $file) {
$content .= $file['contents'];
}

Forma 2 - If you want to put everything together in an array:

$filesQuery = (new Query('/file/print'));
files = $client->query($filesQuery)->read();

$content = [];

foreach ($fileContent as $file) {
$content[] = $file['contents'];
}