Controller File name : UserController.php
Model File name : User.php
View File name : index.blade.php
Table name : users
Columns : id(primary),name,email, phone
To fetch all records from users table you can write in following 3 ways.
$users = DB::select('SELECT * FROM users');
(or)
$users = DB::table('users')->get();
(or)
$users = User::all(); //Here User is the model
Controller: UserController.php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Database\Eloquent\Model;
use App\User;
class UserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$userobj = new User();
$users = $userobj->getusers();
return view('index')->with('users',$users);
}
}
Model : User.php
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
class User extends Model
{
protected $table="users";
public function getusers(){
//$users = DB::select('SELECT * FROM users');
//$users = DB::table('users')->get();
$users = User::all();//User is the model here
return $users;
}
}
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
class User extends Model
{
protected $table="users";
public function getusers(){
//$users = DB::select('SELECT * FROM users');
//$users = DB::table('users')->get();
$users = User::all();//User is the model here
return $users;
}
}
Model File name : User.php
View File name : index.blade.php
Table name : users
Columns : id(primary),name,email, phone
To fetch all records from users table you can write in following 3 ways.
$users = DB::select('SELECT * FROM users');
(or)
$users = DB::table('users')->get();
(or)
$users = User::all(); //Here User is the model
Table:users
CREATE TABLE `users` (
`id` int(10) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`, `email`, `phone`) VALUES
(1, 'smita', 'smita@gmail.com', '9861012345'),
(2, 'Smith', 'deep@gmail.com', '9861012346');
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Database\Eloquent\Model;
use App\User;
class UserController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$userobj = new User();
$users = $userobj->getusers();
return view('index')->with('users',$users);
}
}
Model : User.php
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
class User extends Model
{
protected $table="users";
public function getusers(){
//$users = DB::select('SELECT * FROM users');
//$users = DB::table('users')->get();
$users = User::all();//User is the model here
return $users;
}
}
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
class User extends Model
{
protected $table="users";
public function getusers(){
//$users = DB::select('SELECT * FROM users');
//$users = DB::table('users')->get();
$users = User::all();//User is the model here
return $users;
}
}
View: index.blade.php
<html>
<table border="1">
<tr>
<td>Sl No</td>
<td>Name</td>
<td>Email</td>
<td>Phone</td>
</tr>
@foreach($users as $key=>$user)
<tr>
<td>{{$key+1}}</td>
<td>{{$user->name}}</td>
<td>{{$user->email}}</td>
<td>{{$user->phone}}</td>
</tr>
@endforeach
</table>
</html>
No comments:
Post a Comment