elapez's questions

I clarify that although I am in a PHP environment with Eloquent-ORM and using Carbon to handle dates on the server side, I am NOT using Laravel. I want to show a date in Spanish using Carbon, but I can't get it to show in that language, I have this:

use Carbon\Carbon;
Carbon::setLocale("es");

$fechaCarbon = Carbon::parse($miEgreso->created_at)->toDayDateTimeString();

I have also tried:

$fechaCarbon = Carbon::parse($miEgreso->created_at)->locale("es")->toDayDateTimeString();

In both cases I get something like:

"Mon, Jan 4, 2021 4:53 PM"

When I expect to get:

"Mon, Jan 4, 2021 4:53 PM"

Or something similar where it is interpreted that the expression is in Spanish.

I have a method of a class that I extend from ELOQUENT that has to process very large collections of the order of more than 800,000 items and I have realized that it eventually causes some difficulties in the service, so I decided according to the advice of the documentation of Laravel, use chunk() method from QueryBuilder. The process is to read the existing entries in a certain date range and then calculate averages in time subdivisions of the entire collection, to display in a behavior graph. The problem is that the chunk() method perfectly processes each chunk calculating the averages of each input segment but I can't get it to return those averages, I can print them from an "echo" but as by default it does a loop iterating between each chunk of the collection, at the end it only returns a "

public static function gghh($campo, $marca = [], $corte=5000)
{
    $ini = isset($marca["ini"]) ? $marca["ini"] : Carbon::now()->subDay()->format('Y-m-d');
    $fin = isset($marca["fin"]) ? $marca["fin"] : Carbon::now()->format('Y-m-d');

    return self::whereBetween("fecha", [$ini, $fin])->chunk($corte,function ($regs) use ($campo){

        //echo $regs->avg($campo)."<br />";
        //echo $regs->first()->fecha."<br />";
    
        if(!isset($trozos))
        {
           $trozos = [];
        }
        
        array_push($trozos, ["dato" => $regs->avg($campo), "fecha" => $regs->first()->fecha]);

        return $trozos
    });
}

I know that the process is done correctly because if I remove the comments from the two "echoes", the values ​​are displayed correctly, but I need these same values ​​to be returned to me for a later process. As it is now shown, the method only returns a boolean value (TRUE). Any ideas to obtain something like the Array that follows?

[
  ["dato"=>145.58, "fecha"=>"2020-08-12"],
  ["dato"=>128.89, "fecha"=>"2020-09-12"],
  ["dato"=>132.14, "fecha"=>"2020-10-12"],
  ["dato"=>136.62, "fecha"=>"2020-11-12"],
  ...
]

I have a SELECT that evaluates two conditions, the first of them is mandatory and the second is a subgroup where at least one should give "true" so that the general SELECT is fulfilled. The thing is that according to the recommendations of the ELOQUENT documentation, in these cases the best option is to pass a "closure" as the second parameter (the group of options) but the thing is that even in there I have to send a variable to validate and when I try to do it, the "closure" function fails and throws an error. This is what I have so far.

$modelo = Escuela::where("nombre", $nombre)
  ->where(function($q, $b){
  $q->where("apellido","like","%" . $b . "%")
  ->orWhere("ciudad","like","%" . $b . "%");
  })->select("id","nombre","apellido")->get();

Assuming one the values:

$nombre = "John"
$b = "gua"

It should be more or less like this:

select * from users where name = 'John' and (apellido LIKE '%gua%' or ciudad  LIKE '%gua%'),

But it throws me an error saying that the number of arguments of the "closure" is not correct

What am I missing?

I have a php array that I send to a SOAP service, but the service returns an error

$params = ["key1"=>"value 1", "key2" => "value 2"];
$soap = new SoapClient($url, ["trace"=>true]);
$data = $soap->metodo($params);

This operation returns me:

Server was unable to read request. ---> There is an error in XML document (2, 461). ---> The string '' is not a valid AllXsd value.

Understanding that the message indicates that there is an error in the XML format, what I want is to manually validate the resulting XML that is sent to the SOAP service.

How can I generate an output of the resulting XML that is sent to the service? If possible, I would like to obtain it before sending it to the SOAP service to be able to validate it. I have tried to make a "trace" in "SoapClient" but apparently, because the process aborts its execution... I cannot obtain any other data from the process that will help me to obtain the resulting XML that is sent to the service.

Thanks in advance!

I would like to do something like this with Eloquent:

UPDATE `perros` SET `raza` = "indeterminado" WHERE `raza` = "Lobo"

So that all records in the "race" field that match the value "Wolf" are automatically rewritten to the value "indeterminate".

I know how to identify all records with the value "Lobo" but I don't know how to update them all at once.

Perros::where("raza","Lobo")->get() 

I have access via SSH console to a folder in an AWS service, how can I download an entire folder to my local PC?

I've tried something like ~$ wget filename

and it doesn't work... what it does is try to find "http://filename", that is, it tries to find it in the global network and the file or folder to download in this case is locally on the server

Both answers.. in the end a local friend pointed out to me that I could use the same IDE I use to develop "PHP Storm" to set up this download and from there - everything was very easy... Thanks to Marco the first thing I did was to compact the entire folder to make it easier to have everything in one file and then taking Abraham Guerrero's suggestion of using an SFTP connection. Thanks friends !!!

I am using xampp, php 7.1.1, laravel 5.5, MySQL(MariaDB), all in a windows environment.

when I try to set the initial migration it gives me the following response

$ php artisan migrate
Migration table created successfully.

In Connection.php line 664:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

In Connection.php line 458:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

As a result, it effectively creates the users table (users) and another "migrations" table, but it does not create the "password reset" table

What am I missing?

I have a block of text with embedded strings similar to "[ ]blk_foto_1[ ]" and I want to filter said block so that the result is a text where "[ ]blk_foto_1[ ]" is replaced by "image1.jpg", then I tried to do it with regular expressions but I don't achieve what I want, and the truth is that I think I'm going to die and I still won't fully understand how "regex" work. So far I have something like this:

$cadena = 'lorem vestibulum torquent at [***]blk_foto_1[***] orttitor habitasse mattis [***]blk_foto_2[***] platea taciti';
$patrones = [0=>'/[***]blk_foto_1[***]/', 1=>'/[***]blk_foto_2[***]/'];
$imagenes = [0 => 'imagen1.jpg', 1 => 'imagen2.jpg'];

echo preg_replace($patrones, $imagenes, $cadena);

But it returns me exactly the same original string with no changes.

My expectation is that the resulting string would replace '[ ]blk_photo_1[ ]' with 'image1.jpg' and so on, where the indices of $patterns match the indices of $images

I have a couple of connections to each of them going to a different MySQL database, the issue is that one connects to a local server itself, but the other goes to a remote server and under "another port", I manage connections like this:

$capsule->addConnection([
'driver' => 'mysql',
'host' => LOCAL_DB_HST,
'database' => LOCAL_DB_NAM,
'username' => LOCAL_DB_USR,
'password' => LOCAL_DB_PWD,
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => ''
], "local");

$capsule->addConnection([
'driver' => 'mysql',
'host' => REMOTE_DB_HST,
'database' => REMOTE_DB_NAM,
'username' => REMOTE_DB_USR,
'password' => REMOTE_DB_PWD,
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => ''
], "remota");

It's important to clarify that I'm not using Eloquent as part of Laravel... but as a totally stand-alone implementation.

The issue is that the remote MySQL server uses a port other than 3306 and I don't know how to tell Eloquent to use another port when connecting to the remote server as long as it keeps the default port (3306) for the local connection.

I have created a tab on a Facebook page with personalized content from an external server... it looks perfectly on desktop, but on mobile the tab does not even appear and I cannot find details about this on FB developers.... how can I do it that the new tab is also seen on mobile phones... I really don't think it's a problem with the code... I use the javascript API.

You can see the application from Desktop at https://www.facebook.com/studioqatro/app/1777986842510245/ But if I try to access from a mobile, it tells me that the page cannot be displayed because the link is not available, then I consider It must be something in the Facebook settings that prevents showing that tab on mobile devices