|
 |
| |
ถามเรื่องการ Passing Data To Views Laravel 5.6 กับ SQL SERV |
| |
 |
|
|
 |
 |
|
ถามเรื่องการ Passing Data To Views Laravel 5.6 กับ SQL SERV
View (.php) ไม่ใช่ Blade.php นะ
Code (PHP)
$visitToday = DB::table('DB_TEST.dbo.CONFIG')
->select(DB::raw('CtrlCode,Code,EngName,THName'))
->where('CtrlCode', '=', '42203');
ส่งค่าจาก controller
return view('Report/VisitToday',['code' => $visitToday],['EngName' => $visitToday],['THName' => $visitToday]);
View (.php) ไม่ใช่ Blade.php นะ
<?php echo substr($code,1)?>
<?php echo substr($EngName,1)?>
<?php echo iconv('TIS-620','UTF-8',substr($THName,1))?>
มันฟ้องว่า "Undefined variable: THName"
Tag : PHP, Ms SQL Server 2012, Laravel Framework
|
ประวัติการแก้ไข
2018-05-17 16:13:29
|
 |
 |
 |
 |
| Date :
2018-05-17 16:11:59 |
By :
nottpoo |
View :
795 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
มันหา parameter ไม่เจอครับ
substr($THName,1) มาจากไหน
|
| |
|
|
| |
| Date :
2018-05-17 17:11:39 |
By :
mongkon.k |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
มาจาก Controller
Code (PHP)
//controller
class VisitTodayController extends Controller
{
/**
* Show a list of all of the application's users.
*
* @return Response
*/
public function VisitTodayClinic()
{
//RAW QUERIES
$visitToday = DB::table('DB_TEST.dbo.CONFIG')
->select(DB::raw('CtrlCode,Code,EngName,THName'))
->where('CtrlCode', '=', '42203')
->whereIn('code', array('AC','ADIO','ADM','AJ','AN','NY'))
->get();
//dd($visitToday);
return view('Report/VisitToday',['code' => $visitToday][1],['EnglishName' => $visitToday][2],['LocalName' => $visitToday][3]);
}
}
//Route
Route::get('report', 'Report\VisitTodayController@VisitTodayClinic');
//View
<select class="custom-select" id="inputGroupSelect01">
<option selected>Choose...</option>
<option value="">
{{$code}}
{{substr($EnglishName,1)}}
{{substr($LocalName,1)}}
</option>
</select>
|
ประวัติการแก้ไข
2018-05-17 17:40:57
| |
|
|
| |
| Date :
2018-05-17 17:40:13 |
By :
nottpoo |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
$data = [
'code' => $visitToday][1],
'EnglishName' => $visitToday][2],
'LocalName' => $visitToday][3]
];
return view('Report/VisitToday',$data);
|
| |
|
|
| |
| Date :
2018-05-17 17:57:29 |
By :
mongkon.k |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 03
|
