Inserting if record not exist, updating if exist

Check this

https://laravel.com/docs/5.3/eloquent#insert-update-delete

$user = User::firstOrNew(array('name' => Input::get('name')));
$user->foo = Input::get('foo');
$user->save();

You can also use the updateOrCreate method:

$user = User::updateOrCreate(['name' => request()->name], [ 
    'foo' => request()->foo
]);

Using the same example code as @tomi from above

for your Table1 model

$table1 = Table1::firstOrNew(['name' => Input::get('name')]); // your data
// make your affectation to the $table1
$table1 ->save();

for your Table2 model

$table2 = Table2::create($arrayOfData); // if the fields are fillables

I tried your code but i am getting this error now "QueryException in Connection.php line 761: SQLSTATE[HY000]: General error: 1364 Field 'item' doesn't have a default value (SQL: insert into stationary (available, updated_at, created_at) values (12345, 2016-09-30 12:16:52, 2016-09-30 12:16:52))" Here is my controller code

    {
        $item = stationary::firstOrNew(array('item' => Input::get('name'),'available' => Input::get('quantity')));
$item->save();
    }

like this

$item = stationary::firstOrNew(array('item' => Input::get('name'),'available' => Input::get('quantity')));
$item ->save();

Try

$item = Stationary::firstOrNew(array('item' => Input::get('name'),'available' => Input::get('quantity')));
$item->save();

I changed the code now i am getting this error "QueryException in Connection.php line 761: SQLSTATE[HY000]: General error: 1364 Field 'item' doesn't have a default value (SQL: insert into stationary (available, updated_at, created_at) values (12345, 2016-09-30 12:16:52, 2016-09-30 12:16:52))"

@manojvarma here is it, make sure your item field is in the fillable list

$item = stationary::firstOrNew(array('available' => Input::get('quantity')));
$item ->save();

Does your field item is fillable?

https://laravel.com/docs/5.3/eloquent#mass-assignment

Yes it is fillable here is my form

<form action="stationary-add-item" method="POST">
  <div class="form-group">
    <input type="text" name="item" class="form-control" id="statnewname" placeholder="Enter item name">
  </div>
  <div class="form-group">
    <input type="number" name="available" class="form-control" id="compnewcount" placeholder="Enter count">
  </div>
  <input type="hidden" name="_token" value="{{csrf_token()}}">
  <button type="submit" class="btn btn-primary">Add</button>
</form>

@manojvarma have you tried the code I wrote? if it doesn't work, would you copy for us the content of stationary Model

you have typo, try now code bellow

$item = Stationary::firstOrNew(array('item' => Input::get('item'),'available' => Input::get('available')));
$item->save();

your input fields is item and available

@manojvarma in the model it should be something like that

protected $fillable = ['available', 'item'];

and then you can use it like that

$item = stationary::firstOrNew(array('item' => Input::get('item'),'available' => Input::get('quantity')));
$item->save();

here is my model code

namespace App;

use Illuminate\Database\Eloquent\Model;

class stationary extends Model
{
    protected $table = 'stationary';
     protected $fillable = ['item', 'available'];
}

try this then

https://laracasts.com/discuss/channels/laravel/inserting-if-record-not-exist-updating-if-exist/replies/283292

Thank you guys. you both are awesome @InaniELHoussain @tomi

Now one more issue. If both the available and item matches only it is updating. but i want it to be like " if item matches then it should update the count" instead it is adding one more row.

Than you need this

$item = Stationary::firstOrNew(array('item' => Input::get('item')));
$item->count++;
$item->save();

@tomi you suggested to give count++ in my thing i have to give available ++. when i give available++ it is incrementing the value but i need it to be add the present entered value to previous value. can you help me in that?

Does this work

$item = Stationary::firstOrNew(array('item' => Input::get('item')));
$item->count += Input::get('available');
$item->save();

@tomi thank you. it is working

I tried this, but the data won't be updated. Even thou the save() function returned a "true" value :/