php框架总结,PHP框架laravel知识总结

/**

* Created by PhpStorm.

* User: TXDK

* Date: 2020-11-23

* Time: 16:01

*/

namespace App\Http\Controllers;

use App\Models\Student;

use Illuminate\Support\Facades\DB;

class StudentController

{

public function showStudent(){

$studentInfo = Student::studentInfo();

return view("student", ["studentName"=> $studentInfo, ]);

}

public function dbFacade(){

$bool = DB::insert('insert into student(name, age, score) values (?, ?, ?)', ['tony', 7, 100]);

var_dump($bool);

$bool = DB::update('update student set age=20 where name=?', ['tony']);

var_dump($bool);

$bool = DB::delete("delete from student where name=?", ["tony"]);

var_dump($bool);

$studentInfo = DB::select("select * from student");

dd($studentInfo);

foreach ($studentInfo as $student){

echo "姓名:" . $student->name ."
" . "年龄:" . $student->age . "
分数:" . $student->score . "
";

}

$studentInfo = DB::select("select * from student where name=:name", ["name"=>"snow"]);

dd($studentInfo);

}

public function builder(){

$bool = DB::table("student")->insert(["name"=>"alisa", "age"=>"13", "score"=>88]);

var_dump($bool);

$bool = DB::table("student")->insert([

["name"=>"jacker", "age"=>"17", "score"=>85],

["name"=>"rose", "age"=>"33", "score"=>80]

]);

var_dump($bool);

$id = DB::table("student")->insertOrIgnore(["id"=>7 ,"name"=>"baker", "age"=>"13", "score"=>88]);

var_dump($id);

$n = DB::table("student")->where('name', "rose")->update(["age"=>21]);

var_dump($n);

$n = DB::table("student")->updateOrInsert(

["name"=>"tony"],

["age"=>18, "score"=>66]

);

var_dump($n);

$n = DB::table("student")->where("name", "tony")->increment("age", 5);

var_dump($n);

$results = DB::table("student")->where("score", ">" , 90)->get();

$results = DB::table("student")

->whereRaw("age > ? and score > ?", [20, 80])

->get();

foreach ($results as $item){

echo "姓名:" . $item->name . "|年龄:" . $item->age . "|分数:" . $item->score . "

---

";

}

$results = DB::table("student")

->where("name", "tony")->value("age");

echo $results;

$item = DB::table("student")

->find(2);

echo "姓名:" . $item->name . "|年龄:" . $item->age . "|分数:" . $item->score . "

---

";

$items = DB::table("Student")->orderBy("id", 'desc')->pluck("name");

echo $items;

echo "

";

$items = DB::table("student")->orderBy("id", 'desc')->chunk(2, function ($students){

//var_dump($students);

foreach ($students as $student){

echo "
姓名:" . $student->name . "年龄:" . $student->age . "分数:" . $student->score;

if ($student->name == "tony"){

return false;

}

}

});

$n = DB::table("student")->count();

echo $n;

$max_age = DB::table("student")->where("score", ">=", 80)->min("age");

echo $max_age;

$results = DB::table("student")->where("score", ">=", 80)->select("name", "age")->get();

dd($results);

}

public function orm(){

$student = new Student();

$student->name = "jony";

$student->age = 7;

$student->score = 88;

$res = $student->save();

dd($res);

$student = Student::create(

["name"=>"rose", "age"=>18, "score"=>"78"]

);

$student = Student::firstOrCreate(

["name"=>"snow", "age"=>38, "score"=>100]

);

dd($student);

$res = Student::get();

$res->reject(function ($res){

var_dump($res->name);

});

dd($res);

$res = Student::first();

dd($res);

echo "

";

Student::chunk(2, function ($item){

var_dump($item);

});

echo "

";

foreach ( Student::cursor() as $item){

var_dump( $item->name);

}

$n = Student::count();

echo $n;

$item = Student::where("age", ">", 30)

->select("name", "age")->get();

dd($item);

$item = Student::findOrFail("1");

dd($item);

$item = Student::where("age", ">", 100)->firstOrFail();

dd($item);

//更新数据

$student = Student::first();

$student->name = "baker";

$student->age = 100;

$student->save();

Student::where("name", "=", "baker")

->update(["name"=>"penny", "age"=>"35"]);

//删除数据

$student = Student::first();

$student->delete();

Student::destroy(15);

Student::where("age", ">=", 18)->delete();

}

}