Skip to content

Instantly share code, notes, and snippets.

@harendra21
Created April 10, 2019 12:27
Show Gist options
  • Save harendra21/bb647765acee8ff3043834a29107cdcc to your computer and use it in GitHub Desktop.
Save harendra21/bb647765acee8ff3043834a29107cdcc to your computer and use it in GitHub Desktop.
<?php
namespace App;
use DB;
use Illuminate\Database\Eloquent\Model;
class crud extends Model
{
public function add($data){
$fName = $data['fName'];
$lName = $data['lName'];
$email = $data['email'];
$phone = $data['phone'];
$address = $data['address'];
if (isset($data['userId'])) {
$id = $data['userId'];
return DB::table('users')->where('id', $id)->update([
'first_name' => $fName,
'last_name' => $lName,
'email' => $email,
'phone' => $phone,
'address' => $address
]);
}else{
return DB::table('users')->insert([
'first_name' => $fName,
'last_name' => $lName,
'email' => $email,
'phone' => $phone,
'address' => $address
]);
}
}
public function getAll(){
$users = DB::table('users')->select('id','first_name','last_name','email','phone','address','created_at')->orderBy('id',"desc")->get();
return $users;
}
public function getUser($id){
$user = DB::table('users')->select('id','first_name','last_name','email','phone','address','created_at')->orderBy('id',"desc")->where('id',$id)->first();
return $user;
}
public function deleteUser($userId){
return DB::table('users')->where('id',$userId)->delete();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment