PHP Movie::find方法代码示例

 public function get_update($id_pelicula)
 {
     $pelicula = Movie::find($id_pelicula);
     $pelicula->nombre = "Teminator genesis";
     $pelicula->duracion = "3 horas";
     $pelicula->save();
     return Redirect::to('movie');
 }

 public function review($review)
 {
     if (Auth::user()->usr_level == 2) {
         // gets the user details fro username
         $review = DB::table('film_review')->where('fr_id', '=', $review)->first();
         $film = Movie::find($review->fr_fl_id);
         $user = User::find($review->fr_usr_id);
         return view('admin.review', compact('review', 'film', 'user'));
     } else {
         return Redirect::to(Config::get('url.home'));
     }
 }

 /**
  * Store a newly created resource in storage.
  *
  * @return Response
  */
 public function omdbUpdate($id)
 {
     if (Request::format() == 'json') {
     }
     $rev = Movie::find($id);
     $rev->fl_dir_ar_id = Input::get('info.Director');
     $rev->fl_writer = Input::get('info.Writer');
     $rev->fl_stars = Input::get('info.Actors');
     $rev->fl_outline = Input::get('info.Plot');
     $rev->fl_genre = Input::get('info.Genre');
     $rev->fl_duration = Input::get('info.Runtime');
     $rev->fl_country = Input::get('info.Country');
     $rev->fl_imdbID = Input::get('info.imdbID');
     $rev->fl_imdbRating = Input::get('info.imdbRating');
     $rev->fl_imdbVotes = Input::get('info.imdbVotes');
     $rev->fl_metascore = Input::get('info.Metascore');
     $rev->save();
 }

 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($id)
 {
     return Response::json(Movie::find($id));
 }

 /**
  *  This function responses to
  *  the get request of /admin/movie/details/{id}
  *  and view movie respect to id
  */
 public function getDetails($id, $msg = null)
 {
     $movie = Movie::find($id);
     if (!empty($msg) && $msg == 1) {
         return View::make('adminArea.movie.details')->with('movie', $movie)->with('orders', Order::orderBy('from', 'desc')->get())->with('success', "Order has been deactivated successfully");
     }
     return View::make('adminArea.movie.details')->with('movie', $movie)->with('orders', Order::orderBy('from', 'desc')->get());
 }

class Movie extends \Illuminate\Database\Eloquent\Model
{
    public $timestamps = false;
}
/* Obtención de la lista de películas */
$app->get('/movies', function () use($app) {
    // Creamos un objeto collection + json con la lista de películas
    // Obtenemos el objeto request, que representa la petición HTTP
    $req = $app->request;
    // Obtenemos la ruta absoluta de este recurso
    $absUrl = $req->getScheme() . "://" . $req->getHost() . $req->getRootUri() . $req->getResourceUri();
    // Obtenemos la lista de películas de la base de datos y la convertimos del formato Json (el devuelto por Eloquent) a un array PHP
    $pelis = json_decode(\Movie::all());
    $app->view()->setData(array('url' => $absUrl, 'items' => $pelis));
    // Mostramos la vista
    $app->render('movielist_template.php');
});
/*  Obtención de una película en concreto  */
$app->get('/movies/:name', function ($name) use($app) {
    // Creamos un objeto collection + json con la película pasada como parámetro
    // Obtenemos el objeto request, que representa la petición HTTP
    $req = $app->request;
    // Obtenemos la ruta absoluta de este recurso
    $absUrl = $req->getScheme() . "://" . $req->getHost() . $req->getRootUri() . $req->getResourceUri();
    // Obtenemos la película de la base de datos a partir de su id y la convertimos del formato Json (el devuelto por Eloquent) a un array PHP
    $p = \Movie::find($name);
    $peli = json_decode($p);
    $app->view()->setData(array('url' => preg_replace('/' . preg_quote('/' . $name, '/') . '$/', '', $absUrl), 'item' => $peli));
    // Mostramos la vista
    $app->render('movie_template.php');
});

    //$name_mov, $email, $description
    $longitud = count($datos);
    for ($i = 0; $i < $longitud; $i++) {
        switch ($datos[$i]['name']) {
            case "name":
                $name_mov = $datos[$i]['value'];
                break;
            case "description":
                $description = $datos[$i]['value'];
                break;
            case "director":
                $director = $datos[$i]['value'];
                break;
            case "datePublished":
                $fecha = $datos[$i]['value'];
                break;
            case "embedUrl":
                $trailer = $datos[$i]['value'];
                break;
        }
    }
    //me inserta una nueva fila a la tabla Movie por asi decirlo. Esta tabla tiene los campos name, description....
    //la variable $name_mov tiene el nombre de la pelicula que quiero guardar
    $mod_movie = \Movie::find($id);
    $mod_movie->name = $name_mov;
    $mod_movie->description = $description;
    $mod_movie->director = $director;
    $mod_movie->datePublished = $fecha;
    $mod_movie->embedUrl = $trailer;
    $mod_movie->save();
});

        $film = DB::table('film')->where('fl_name', 'LIKE', $movie)->where('fl_year', '=', $year)->orderBy('fl_rating', 'desc')->first();
        if ($film) {
            //Check if already added or not
            $check = DB::table('user_suggestions')->where('us_fl_id', $film->fl_id)->get();
            if ($check) {
                //Update Movie Details
                $rev = Movie::find($film->fl_id);
                $rev->fl_language = 'English';
                $rev->fl_country = 'USA';
                $rev->save();
                echo 'Already added ' . $film->fl_name . '' . '<br/>';
                echo '<img width="60px" src="http://localhost/lara/public/uploads/movie/' . $film->fl_year . '/' . $film->fl_image . '"/>' . '<br/>';
            } else {
                $query = DB::table('user_suggestions')->insertGetId(array('us_fl_id' => $film->fl_id));
                //Update Movie Details
                $rev = Movie::find($film->fl_id);
                $rev->fl_language = 'English';
                $rev->fl_country = 'USA';
                $rev->save();
                //Updated
                echo 'Just added in suggestion ' . $film->fl_name . '' . '<br/>';
                echo '<img width="60px" src="http://localhost/lara/public/uploads/movie/' . $film->fl_year . '/' . $film->fl_image . '"/>' . '<br/>';
            }
        } else {
            echo '<b>Not found </b>' . $movie . '' . '<br/>';
        }
    }
});
Route::get('ajax/{query}', function ($query) {
    /*$dback = DB::table('film')
                ->where('fl_name', 'LIKE', '%' . $query . '%')

    $datos = $template['template']['data'];
    //longitud del vector
    $longitud = count($datos);
    //bucle que recorre vector
    for ($i = 0; $i < $longitud; $i++) {
        switch ($datos[$i]['name']) {
            case "name":
                $name = $datos[$i]['value'];
                break;
            case "description":
                $description = $datos[$i]['value'];
                break;
            case "director":
                $director = $datos[$i]['value'];
                break;
            case "embedUrl":
                $embedUrl = $datos[$i]['value'];
                break;
            case "datePublished":
                $datePublished = $datos[$i]['value'];
                break;
        }
    }
    $nueva_movie = Movie::find($id);
    $nueva_movie['name'] = $name;
    $nueva_movie['description'] = $description;
    $nueva_movie['director'] = $director;
    $nueva_movie['embedUrl'] = $embedUrl;
    $nueva_movie['datePublished'] = $datePublished;
    $nueva_movie->save();
});

 /**
  *  This function responses to
  *  the get request of /member/movie/details/{id}
  *  and view movie respect to id
  */
 public function getDetails($id)
 {
     $movie = Movie::find($id);
     return View::make('adminArea.movie.memberMovieDetails')->with('movie', $movie);
 }

 public function suggestionAdd()
 {
     $film = Input::get('film');
     $check = DB::table('user_suggestions')->where('us_fl_id', $film)->get();
     if ($check) {
         //Do nothing
     } else {
         $query = DB::table('user_suggestions')->insertGetId(array('us_fl_id' => $film));
         $rev = Movie::find($film);
         $rev->fl_language = 'English';
         $rev->fl_country = 'USA';
         $rev->save();
     }
     if ($query) {
         return 'true';
     } else {
         return 'false';
     }
 }

<?php

include __DIR__ . '/init.inc.php';
$top_url = 'http://itunes.apple.com/tw/genre/dian-ying/id33?l=zh';
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $top_url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_HEADER, 0);
$message = curl_exec($curl);
curl_close($curl);
if (!preg_match_all('#<a href="([^"]*)" class="top-level-genre" title="[^"]*">[^<]*</a>#', $message, $matches)) {
    die('failed');
}
foreach ($matches[1] as $genre_url) {
    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $genre_url);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl, CURLOPT_HEADER, 0);
    $message = curl_exec($curl);
    curl_close($curl);
    preg_match_all('#<li><a href="(http://itunes.apple.com/tw/movie/[^/]*/id([0-9]+)\\?l=zh)">([^<]*)</a> </li>#', $message, $matches);
    foreach ($matches[0] as $id => $data) {
        $url = $matches[1][$id];
        $movie_id = $matches[2][$id];
        $movie_name = $matches[3][$id];
        if (Movie::find($movie_id)) {
            continue;
        }
        Movie::insert(array('id' => $movie_id, 'url' => $url, 'description' => $movie_name, 'created_at' => time()));
    }
}