How are My Laravel Model Objects Changing To Disable Updating?

2021-02-22 22:39 Chris imported from Stackoverflow

I'm first selecting the record from the db like $obj = MyDbObject::select(...)->first() and assign it to a variable. I'm then trying to update it like

                $obj->update([
                    'status' => 0
                ]);

but doing this throws an error "Array to string conversion". If I pull the record again the update works fine.

$o = MyDbObject::find($obj->id);
                $o->update([
                    'status' => 0
                ]);

If I dd() $obj or $o they are both instances of the same class.

What changes when I "SELECT" the object?

EDIT: added stack trace.

ErrorException {#2682
  #message: "Array to string conversion"
  #code: 0
  #file: "./vendor/laravel/framework/src/Illuminate/Support/Str.php"
  #line: 353
  #severity: E_NOTICE
  trace: {
    ./vendor/laravel/framework/src/Illuminate/Support/Str.php:353 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/QueryException.php:56 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/QueryException.php:39 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Connection.php:665 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Connection.php:490 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Connection.php:423 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2721 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:820 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:745 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:660 { …}
    ./vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:607 { …}
    ./app/.../MyDbObject.php:217 {
      App\...\MyDbObject->myfunc(...)^
      ›                     $obj->update([
      ›                         'status' => 0,
      arguments: {
        $attributes: array:1 [ …1]
      }
    }

EDIT 2: adding more code for @lagbox

$obj->update(['status' => 0, 'col2' => 'test']);

array_map(function ($obj) {
// do stuff with $obj; then run an update on it.
}, MyDbObject::select("t1.information as info", "my_db_objects.*")
            ->leftJoin('table_1 as t1', function ($join) {
                return $join->on('my_db_objects.table_1_id', '=', 't1.id');
            })
            ->where('my_db_objects.status', '1')
            ->get()
            ->map(function($mdo) {
                ...
            })
            ->all()
);

1 answer

answered 2021-02-23 05:38 Manish Rajora

try this

$o = MyDbObject::where('column_name',$obj->id);
            $o->update([
                'status' => 0
            ]);

change 'find' with 'where'

See also questions close to this topic

PHP-XML: How do I modify text value of a given target

<?xml version="1.0" encoding="utf-8" ?>
<xliff>
    <body>
        <trans-unit id="NFDBB2FA9-tu4" xml:space="preserve">
            <source xml:lang="en">He</source>
            <target xml:lang="id">He</target>
        </trans-unit>
        <trans-unit id="NFDBB2FA9-tu5" xml:space="preserve">
            <source xml:lang="en">She</source>
            <target xml:lang="id">She</target>
        </trans-unit>
    </body>
    <body>
        <trans-unit id="NFDBB2FA9-tu6" xml:space="preserve">
            <source xml:lang="en">They</source>
            <target xml:lang="id">They</target>
        </trans-unit>
        <trans-unit id="NFDBB2FA9-tu7" xml:space="preserve">
            <source xml:lang="en">We</source>
            <target xml:lang="id">We</target>
        </trans-unit>
    </body>
</xliff>

how do I modify value of <target> of trans-unit id="NFDBB2FA9-tu7" or any other?

done this but empty on the print_r and don't know what's next

$dom = new \DOMDocument();
$dom->load("my.xlf");
$root = $dom->documentElement;
$xliffBodies = $root->getElementsByTagName("body")->item(0);

foreach ($xliffBody as $body) {
    $el = $body->getElementsByTagName("trans-unit");
    print_r($el);
}

PHP OOP mt_rand() function do it twice by calling method

I write a class for doing FTP stuff When i calling a method from my class to make an directory on FTP, it creates the folder two times if i'm using the mt_rand() function. I use mt_rand() to create unique id/name for my folder to prevent duplicates.

I'm trying also uniqid() function but have the same result. What i'm doing wrong?

Here is my class:

class Ftp
{
   private $host;
   private $username;
   private $password;
   private $port;
   private $mode;
   private $stream;
   private $connected;
   private $Createdir;
   private $subdir;
   private $files;
   
   // make FTP connection
   function __construct( $host, $username, $password, $port = 21, $mode){
       $this->host      = $host;
       $this->username  = $username;
       $this->password  = $password;
       $this->port      = $port;
       $this->mode      = $mode;
   }

   // FTP connect
   protected function connect(){
       return ftp_connect($this->host, $port);
   }

   // FTP login and create connection
   public function open(){
       $connect = $this->connect();

       if ( $connect == false ){
           // give a error if connection failed
            die( "Kan niet verbinden met " . $this->host );
       }
       if( ftp_login($connect, $this->username, $this->password) ){
            $this->stream = $connect;
            $this->connected = true;
       }
   }

   // create folder
   public function create_folder( $temp_dir ){

        $this->Createdir = $temp_dir;
/*         if( ftp_mkdir( $this->stream, $this->Createdir ) ){
            return true;
        } */
        /* if( $this->folder_exists() === false ) {
            
        } */
        
        //return false;
        
   }
   
   // create subfolder
   public function create_subfolder( $dir ){

       $this->subdir    = $dir;     

       if ( ftp_chdir( $this->stream, $this->Createdir ) ){
           if ( ftp_mkdir( $this->stream, $this->subdir ) ){
               return $this->subdir;
           }
       }

   }

   // check if folder exists
   protected function folder_exists(){
       if ( ftp_chdir( $this->stream, $this->Createdir ) ){
           return true;
       }

       return false;
   }

   // upload files
   public function upload( $files ){
       $this->files = $files;
       if ( ftp_put( $this->stream, $this->Createdir, $this->files) ){
           return true;
       }
   }

   // close FTP connection
   public function __destruct(){
        if( $this->connected ){
            ftp_close($this->stream);
        }
   }
}

    
    $unique_id = date("Y-m-d",time()) ."_". $_POST["prod_id"] ."_".uniqid(); // creating unique dir into temp_files
    $ftp = new Ftp( get_option("ftp_host"), get_option("ftp_user"), get_option("ftp_pass") , 21, get_option("ftp_mode"));
    $ftp->open();
    $ftp->create_folder('temp_files');
    $ftp->create_subfolder($unique_id);

How users can retweet from a different app and it will reflect on the twitter feed

I have an app that allow people to share quotes they like on the app and it automatically reflect on their timeline.

The users are authenticated from the app with twitter auth and i have their UserAccessToken and UserAccessTokenSecret, but because i do not have TwitterConsumerKey and TwitterCOnsumerSecret, i am unable to post to their timeline.

I need guidiance on how i can post to post or retweet(existing twitter post that has valid twitter_post_id) on their timeline.

Aggregate and count data by date in Laravel and PostgreSQL

I recently migrated from MySQL to Postgres and I haven't been able to translate this MySQL query to a Postgres one:

function aggregate($query, $table, string $order): array
{
    $by = $order === 'day' ? 'date' : 'month';

    $from = $by === 'date' ? now()->subDays(14) : now()->subYears(2);

    $dateKey = $by === 'date' ? "DATE($table.created_at)" : "EXTRACT(YEAR_MONTH from $table.created_at)";
    $aggregate = $query->select([
        DB::raw("$dateKey as `{$by}`"),
            DB::raw("COUNT($table.id) as `count`"),
        ])
        ->whereBetween("$table.created_at", [$from, now()])
        ->groupBy($by)
        ->orderBy($by)
        ->get()->toArray();

    return $this->formatAggregates($aggregate, $by);
}

That works when the DB was MySQL but fails on Postgres. This query returns an array of associatives like date=>2021-01-23, count=>4 where the date is a day of the year (yyyy-mm-dd) or a month (yyyy-mm), and the count is the aggregate of all the times that date is repeated.

This is as far as I've gotten as of yet:

    $by = $order === 'day' ? 'date' : 'month';
    $from = $by === 'date' ? now()->subDays(14) : now()->subYears(2);

    $dateKey = $by === 'date' ? "DATE('day', $table.created_at)" : "DATE_TRUNC('month', $table.created_at)";
    $aggregate = $query->select([
        DB::raw("$dateKey AS date"),
        DB::raw("COUNT($table.created_at) AS count"),
    ])->groupBy('date')->orderBy('date')->get();
    dd($aggregate);

I haven't even included the condition to look only for either the last 2 weeks or the last 2 years. I'm ok with it returning a truncated timestamp instead of the yyyy-mm-dd / yyyy-mm formats for day / month.

The error I'm getting from this is that Postgres required me to either group_by or aggregate something coming from the $query argument (codes.business_id). Which, for context, is something like this in Laravel:

$query = $this->hasManyThrough(Scan::class, Code::class, 'business_id', 'code_id');

It's a long shot, but I'd greatly appreciate anyone who can help me make that query work in Postgres...

My charts.js chart is bugging out. I cant explain it you have to see it

Look at this gif i made

https://gyazo.com/53c5d554fc65739e39a6c93fa03c9eb0

What is going on with my charts. I have no ide what i did for this to happen. It was working for along time before it happend. I cant figure out what i did, when i did something to trigger this bugg. Anybody with same experiance?
logo image path not working for pages with parameter
images of header are getting parameter added with their original path while calling at the pages (having parameters )

My code is :
```
<a class="navbar-brand" href="{{url('/')}}"><img src="{{ $general->website_logo?? 'Not Found' }}" 
class="img-fluid" alt="logo"></a>
```
It works nicely for normal pages (without params ) but , when called from pages with params , the images get disappeared :

Property does not exist in collection while using belongsToMany in laravel eloquent

I am using Laravel 8.X and eloquent to develop a web app.

I have a pivot table 'portal_event_users'

I am trying to add a belongsToMany relationship to the portal_users in the model of portal_event_users table.

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class EventUser extends Model
{
    use HasFactory;
    protected $table = 'portal_event_users';
    
      public function users()
    {
        return $this->belongsToMany(User::class);
    }
    
    public function events()
    {
        return $this->belongsToMany(Event::class);
    }
}

I have the following statements in the controller

$eventusersobj = \App\Models\EventUser::select('*')
                                    ->where('event_id', '=', $event_id)
                                    ->get();
                    
                    $response =  $eventusersobj->users->keyBy('id');

It is returning the following error

Property [users] does not exist on this collection instance.

Can someone please advice on how can i change this error?

Thanks in advance

is there any way to Pass 2 variable in one object Laravel JSON response
```
 return response()->json([
            'code'=>$codeTable->code,
            'data'=>$data,
             
        ]);
```
Is there any way to send both code and data as same object???

Laravel Return Migration and Eloquent Response

Is there any way to get the response or message from the migration and eloquent? Regardless of success or failure.

Migration:

$response = Artisan::call('make:model', [
    'name' => 'MyModel'
    '-m' => true
]);
//I need the response for my next step

Eloquent:

$response = MyModel::create($myValues);
//I need the response for my next step

Related questions

How are My Laravel Model Objects Changing To Disable Updating?

1 answer

See also questions close to this topic