Skip to main content

Object of class App\Invoice could not be converted to int

 In my case I was doing this:

<?php
$getallinvoiceids = \App\Invoice::all();

echo 'in'.'-'.sprintf('%06d',$getallinvoiceids->last()->id+1);

?>

So, $getallinvoiceids->last()->id+1 was giving me the error of App\Invoice could not be converted to int. as it was searching for the last data but the invoices table was empty. 


Now to solve this, first we need to count the table then do the operation. Like:

<?php 
     $getallinvoiceids = \App\Invoice::all();
     if($getallinvoiceids->count() <= 0)
     {
        $rowcount = 1;
     }
     else
     {
        $rowcount = $getallinvoiceids->last()->id+1;
     }
     echo 'in'.'-'.sprintf('%06d',($rowcount));
?>


Thanks.


Comments

Popular posts from this blog

SQL: sneak peek

show databases; use mysql; show tables; select * from component; describe component; create database sql_intro; show databases; use sql_intro; create table emp_details (Name varchar(25), Age int, gender char(1), doj date, city varchar(15), salary float); describe emp_details; insert into emp_details  values("Jimmy",35,"M","2005-05-30","Chicago",70000), ("Shane",30,"M","1999-06-25","Seattle",55000), ("Marry",28,"F","2009-03-10","Boston",62000), ("Dwayne",37,"M", "2011-07-12","Austin", 57000), ("Sara",32,"F","2017-10-27","New York",72000), ("Ammy",35,"F","2014-12-20","Seattle",80000); select * from emp_details; select distinct city from emp_details; select count(name) as count_name from emp_details; select avg(salary) from emp_details; select name, age...

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists

While migration to db you often face/might face this error which says the table name that you wrote is already exists in the database. so in that case one of the solutions that you can try is wrapping up your create schema with this: if(!Schema::hasTable('users')){ } Example: if (! Schema :: hasTable ( 'users' )){              Schema :: create ( 'users' ,  function  ( Blueprint   $table ) {                  $table -> bigIncrements ( 'id' );                  $table -> bigInteger ( 'role_id' )-> unsigned ()-> nullable ();                  $table -> foreign ( ' role_id ' )-> references ( 'id' )-> on ( 'roles' ) ...