Trying to include a php file in public folder to the blade file, but that is not working:
Error:
View [../../public/pdf/index.php] not found. (View: C:\wamp\www\nih\app\views\rapport.blade.php)
rapport.blade.php
@extends('default')
@section('content')
<div class="jumbotron" >
<div class="container" >
<div class="row" >
<div class="col-lg-12" >
@include('../../public/pdf/index.php')
</div>
</div>
</div>
</div>
@stop
Index.php - Content
<form action='' method='Post'/>
Fra Dato: <input type="text" name="fraDato" value="<?php echo date('d-m-Y'); ?>" /> <br>
Til Dato: <input type="text" name="tilDato" value="<?php echo date('d-m-Y'); ?>"> <br>
<input type="radio" name="hent" value="timesmaling">Times malinger<br>
<input type='submit' name='submit' value='Generer rapport'>
</form>
<?php
require('mysql_table.php');
$timezone = "Europe/Oslo";
date_default_timezone_set($timezone);
$format="%H%M%S";
$strf=strftime($format);
if(isset($_POST['submit']))
{
$fraDato1 = DateTime::createFromFormat('d-m-Y', $_REQUEST['fraDato']);
$tilDato1 = DateTime::createFromFormat('d-m-Y', $_REQUEST['tilDato']);
$fraDato = $fraDato1->format('Y-m-d');
$tilDato = $tilDato1->format('Y-m-d');
class PDF extends PDF_MySQL_Table
{
function Header()
{
//Title
$this->SetFont('Arial','',18);
$this->Cell(0,6,'Malinger/Oppgaver',0,1,'C');
$this->Ln(10);
//Ensure table header is output
parent::Header();
}
}
//Connect to database
mysql_connect('localhost','root','');
mysql_select_db('nih_bw');
$pdf=new PDF();
$pdf->AddPage();
//First table: put all columns automatically
if (isset($_POST['hent']))
{
if($_POST['hent'] == 'timesmaling')
{
$pdf->Table("SELECT measurements.title as Maling, routines.value as Verdi, DATE_FORMAT(routines.date, '%d/%m/%Y') as Dato, routines.time as Tid, pools.name as Basseng, emps.user_name as Ansatt
FROM routines, measure_routine, measurements, pools, emps
WHERE routines.id = measure_routine.routine_id
AND measure_routine.measure_id = measurements.id
AND (measurements.title Like 'T_%') AND measure_routine.pool_id=pools.id AND routines.emp_id=emps.id AND Date between '".$fraDato."' and '".$tilDato."'
ORDER BY routines.date, routines.time;");
$pdf->Output($downloadfilename."$strf.pdf");
header('Location: '.$downloadfilename."$strf.pdf");
}
}
$prop=array('HeaderColor'=>array(255,150,100),
'color1'=>array(210,245,255),
'color2'=>array(255,255,210),
'padding'=>2);
}
?>