controller
public function index(){
return view('index/index');
}
public function add(){
$arr=Request::all();
unset($arr['_token'],$arr['file']);
$mp3=Input::file('file');
$tmp=$mp3->getPathname();
$name=$mp3->getClientOriginalName();
$mp3->move(public_path().'/uploads',$name);
$arr['path']='./uploads/'.$name;
$arr['time']=date("Y-m-d",time());
$re=DB::table('mp')->insert($arr);
return redirect('show');
}
public function show(){
$search=Request::input('search');
if(!empty($search)){
$arr=DB::table('mp')->where(array('time'=>$search))->get();
echo json_encode($arr);
}else{
$arr['all']=DB::table('mp')->get();
return view('index/show',$arr);
}
}
html
index.blade.php
<center>
<form action="add" method="post" enctype="multipart/form-data">
<input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">
<table>
<tr>
<td>录音名称:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td>录音文件:</td>
<td><input type="file" name="file"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="上传录音"></td>
</tr>
</table>
</form>
</center>
show.blade.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<script src="jquery-1.8.3.min.js"></script>
</head>
<body>
<h3>面试录音列表</h3>
<input type="text" name="search"><button>筛选</button>
<table>
@foreach($all as $k)
<tr>
<td>{{ $k->name }}</td>
<td><audio controls="controls" preload="autoplay"
src="{{ $k->path }}"></audio></td>
</tr>
@endforeach
</table>
</body>
</html>
<script>
$(function(){
$('button').click(function(){
var search=$('input[name="search"]').val();
$.getJSON('search',{search:search},function(msg){
if(msg!=''){
var str='';
for(var i=0;i<msg.length;i++){
str+="<tr><td>"+msg[i]['name']+"</td><td><audio controls='controls' preload='autoplay' src='"+msg[i]['path']+"'></audio></td></tr>";
}
$('table').html(str);
}
});
});
})
</script>