larave 增刪改查

web

Route::get('/sel','Article@sel'); Route::get('/sel1','Article@sel1'); Route::get('/sel2','Article@sel2'); Route::get('/sel3','Article@sel3'); Route::get('/myadd','Article@myadd'); Route::get('/myadd1','Article@myadd1'); Route::get('/upd','Article@upd'); Route::get('/upd1','Article@upd1'); Route::get('/mydel','Article@mydel'); Route::get('/mydel1','Article@mydel1');

Article

`namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;

// 數(shù)據(jù)庫增、刪、查、改。

class Article extends Controller
{
//查 原生
public function sel()
{

    $data = DB::select('select * from article where article_id =? ',[10]);
    foreach ($data as $k => $v){
        $data[$k]=(array)$v;
    }
    $data =$data[0] ；
    return view ('article/article',['res'=>$data]);
}
public function sel1()
{
 $data = DB::table('article')->where('article_id',10)->get()->toArray();
 return view('article.article1',['res'=>$data]);
}
public function sel3()
{
    $data = DB::table('article')->get()->toArray();
    return view('article.article3',['res'=>$data]);
}
public function myadd()
{
    $data =DB::insert("insert into article(title,fb_date,soure,ydl,pls,image,detail,cate_id) 

values(‘原生插入數(shù)據(jù)’,’2019-12-31’,’北京’,’11’,’22’,’a.jpg’,’原生插入數(shù)據(jù)’,’2’)”);
print_r($data);
return view(‘a(chǎn)rticle.article’,[‘res’=>$data]);
}

// 插入 構(gòu)造器
public function myadd1()
{
$data = DB::table(‘a(chǎn)rticle’)
->insert([‘title’=>’構(gòu)造器插入數(shù)據(jù)’,’fb_date’=>’2019-12-31’,
‘soure’=>’北京’,’ydl’=>’22’,’pls’=>’33’,’image’=>’b.gif’,
‘detail’=>’構(gòu)造器插入數(shù)據(jù)’,’cate_id’=>’3’]);

    print_r($data);
    return view('article.article',['res'=>$data]);
}
//修改  原生
public  function  upd()
{
    $data =DB::update("update article set title='原生修改數(shù)據(jù)' where article_id=29");

//
print_r($data);

    return view('article.article',['res'=>$data]);
}

// 修改 構(gòu)造器
public function upd1()
{
$data =DB::table(‘a(chǎn)rticle’)
->where(‘a(chǎn)rticle_id’,31)
// ->update([‘title’=>’構(gòu)造器修改數(shù)據(jù)’]);
->update([‘title’=>’構(gòu)造器修改數(shù)據(jù)’,’detail’=>’構(gòu)造器修改數(shù)據(jù)’]);

           print_r($data);
    return view('article.article',['res'=>$data]);
}
// 刪除  原生
  public function mydel()
  {
      $data = DB::delete('delete from article where article_id=33');
      print_r($data);
      return view('article.article', ['res' => $data]);
  }

// 刪除 構(gòu)造器
public function mydel1()
{
$data =DB::table(‘a(chǎn)rticle’)
->where(‘a(chǎn)rticle_id’,’34’)
->delete();
print_r($data);

     return view('article.article', ['res' => $data]);
 }

}`

article3
`
@foreach($res as $v)

         @if($v->article_id < 5)
             {{$v->title}}.買.<br>
            @elseif($v->article_id>5 && $v->article_id<10)
             {{$v->title}}.可以買.<br>
             @else
             {{$v->title}}.不能買.<br>
             @endif`

批改老師：天蓬老師

批改狀態(tài)：合格

老師批語：寫得不錯嘛, 繼續(xù)