从今天开始，我开始记录我最近开发的音乐网站项目的过程，从前台到后台等，程序是使用PHP+mysql开发的，这种模式大家都很熟悉。首页publicfunctionindex(){//滑动$slider=Db::name('slider')->where('status','1')->order('levelasc,create_timedesc')->limit(8)->select();//查询热门标签$hitstag=Db::name('tags')->order('hitsdesc')->where('status','1')->limit(22)->select();//歌曲列表$song_sheet=Db::name('song_sheet')->alias('sh')->field('sh.*,se.down_url')->join('serverse','sh.server=se.id','LEFT')->where('is_rec','1')->order('create_timedesc')->limit(10)->select();//新歌登场$new_song=Db::name("songs")->alias('so')->field('so.id,so.name,so.artist_name,so.cover_url,so.create_time,so.likes,so.listens,so.play_time,se.down_url,m.uid,m.avatar,m.route_name,se2.down_urlasmdown_url')->join('serverse','so.server=se.id',"LEFT")->join('memberm','so.up_uid=m.uid','LEFT')->join('serverse2','se2.id=m.server','LEFT')->where('so.status','1')->order('so.iddesc')->limit(12)->select();//热门歌手$hits_singer=Db::name('singer')->alias('si')->field('si.id,si.name,si.pic,se.down_url')->join('serverse','si.server=se.id',"LEFT")->order('si.hitsdesc')->limit(6)->select();if(empty(Request::get('isajax'))){returnview('',['headernav'=>'index',//nav'slider'=>$slider,//slide'hitstag'=>$hitstag,//热门标签'song_sheet'=>$song_sheet,//歌曲列表'new_song'=>$new_song,//新歌首发'hits_singer'=>$hits_singer,//热门歌手'json_data'=>'',//页面信息]);}else{//$a=[//'site_title'=>'Feed',//当前页面地址//'theme_url'=>'/themes/default',//模板地址//'page_name'=>'feed',//页面名称//'description'=>'Description',//Description//'keyword'=>'',//Keywords//'url'=>'/feed',//路径//'classes'=>'',//'scroll'=>false,//是否滚动//'ajax_url'=>'feed',//异步请求地址//];$page_msg=['site_title'=>'乐城','theme_url'=>'/themes/default','page_name'=>request()->action(),'description'=>'描述','关键字'=>'','url'=>"http://song.{$this->Web_url}".request()->url(),'classes'=>'','scroll'=>false,'ajax_url'=>请求()->动作(),];$page_msg=str_replace('"',""",json_encode($page_msg));$json_data='';returnview('index_content',['headernav'=>'index',//nav'slider'=>$slider,//slide'hitstag'=>$hitstag,//热标签'song_sheet'=>$song_sheet,//歌曲列表'new_song'=>$new_song,//新歌登场'hits_singer'=>$hits_singer,//热门歌手'json_data'=>$json_data,//页面信息]);}}页面信息公开functiongoPro(){if(empty(Request::get('isajax'))){returnview('',['json_data'=>'',//页面信息]);}else{$page_msg=['site_title'=>'GoPro','theme_url'=>'','page_name'=>request()->action(),'description'=>'GoPro','keyword'=>'','url'=>“http://我的。”.$this->Web_url.url('Collection/myPlaylists'),'classes'=>'','scroll'=>false,'ajax_url'=>'',];$page_msg=str_replace('"',""",json_encode($page_msg));$json_data='';returnview('index/go_pro_content',['json_data'=>$json_data,//页面信息]);}}}加载更多歌曲publicfunctionloadsongs(){echo111;return;//幻灯片$slider=Db::name('slider')->where('status','1')->order('levelasc,create_timedesc')->limit(8)->select();//查询热门标签$hitstag=Db::name('tags')->order('hitsdesc')->where('status','1')->limit(22)->select();//歌曲单$song_sheet=Db::name('song_sheet')->alias('sh')->field('sh.*,se.down_url')->join('serverse','sh.server=se.id','LEFT')->where('is_rec','1')->order('create_timedesc')->limit(10)->select();//新歌首发$new_song=Db::name("songs")->alias('so')->field('so.id,so.name,so.artist_name,so.cover_url,so.create_time,so.likes,so.listens,so.play_time,se.down_url,m.uid,m.avatar,m.route_name,se2.down_urlasmdown_url')->join('serverse','so.server=se.id',"LEFT")->join('memberm','so.up_uid=m.uid','LEFT')->join('serverse2','se2.id=m.server','LEFT')->where('so.status','1')->order('so.iddesc')->limit(12)->select();//热门歌手$hits_singer=Db::name('singer')->alias('si')->field('si.id,si.name,si.pic,se.down_url')->join('serverse','si.server=se.id',"LEFT")->order('si.hitsdesc')->limit(6)->select();returnview('',['headernav'=>'index',//nav'slider'=>$slider,//slide'hitstag'=>$hitstag,//流行标签'song_sheet'=>$song_sheet,//歌曲列表'new_song'=>$new_song,//新歌首发'hits_singer'=>$hits_singer,//热门歌手]);}}
