PHP Person::all方法代码示例

 public static function index()
 {
     // Haetaan kaikki henkilöt tietokannasta
     $people = Person::all();
     // Renderöidään views/people kansiossa sijaitseva tiedosto index.html muuttujan $people datalla
     View::make('User/index.html', array('people' => $people));
 }

 public function testOptionsForAllPeople()
 {
     $options = array('count' => 1);
     self::createTestPerson();
     self::createTestPerson();
     $people = Person::all($options);
     $this->assertSame(1, count($people));
 }

 public function testInvalidOptionsErrorHandling()
 {
     try {
         $options = "count: 5";
         $people = Person::all($options);
     } catch (Util\Exception $e) {
         $expected = 'invalid_options_error';
         $this->assertSame($expected, $e->type);
         $this->assertTrue($e instanceof Util\Exception);
     }
 }

 public function index()
 {
     //		$this->load->view('welcome_message');
     $persons = Person::all();
     foreach ($persons as $person) {
         echo "Name: " . $person->name . '<br><br>';
         $telephones = $person->telephone;
         foreach ($telephones as $telephone) {
             echo $telephone->telephone_type->type . ': ' . $telephone->telephone . '<br>';
         }
         echo '<hr>';
     }
 }

$tito->reload();
echo "{$tito->name} has " . count($tito->orders) . " orders for: " . join(', ', ActiveRecord\collect($tito->orders, 'item_name')) . "\n\n";
// get all orders placed by Tito
foreach (Order::find_all_by_person_id($tito->id) as $order) {
    echo "Order #{$order->id} for {$order->item_name} (\${$order->price} + \${$order->tax} tax) ordered by " . $order->person->name . "\n";
    if (count($order->payments) > 0) {
        // display each payment for this order
        foreach ($order->payments as $payment) {
            echo "  payment #{$payment->id} of \${$payment->amount} by " . $payment->person->name . "\n";
        }
    } else {
        echo "  no payments\n";
    }
    echo "\n";
}
// display summary of all payments made by Tito and Jax
$conditions = array('conditions' => array('id IN(?)', array($tito->id, $jax->id)), 'order' => 'name desc');
foreach (Person::all($conditions) as $person) {
    $n = count($person->payments);
    $total = array_sum(ActiveRecord\collect($person->payments, 'amount'));
    echo "{$person->name} made {$n} payments for a total of \${$total}\n\n";
}
// using order has_many people through payments with options
// array('people', 'through' => 'payments', 'select' => 'people.*, payments.amount', 'conditions' => 'payments.amount < 200'));
// this means our people in the loop below also has the payment information since it is part of an inner join
// we will only see 2 of the people instead of 3 because 1 of the payments is greater than 200
$order = Order::find($pokemon->id);
echo "Order #{$order->id} for {$order->item_name} (\${$order->price} + \${$order->tax} tax)\n";
foreach ($order->people as $person) {
    echo "  payment of \${$person->amount} by " . $person->name . "\n";
}

 public function index()
 {
     $people = Person::all();
     return View::make('people.index', ['people' => $people]);
 }

$person->Firstname = "Kona";
$person->Age = "20";
$person->Sex = "F";
$creation = $person->Create();
// Update Person Info
$person->id = "4";
$person->Age = "32";
$saved = $person->Save();
// Find person
$person->id = "4";
$person->Find();
d($person->Firstname, "Person->Firstname");
d($person->Age, "Person->Age");
// Delete person
$person->id = "17";
$delete = $person->Delete();
// Get all persons
$persons = $person->all();
// Aggregates methods
d($person->max('age'), "Max person age");
d($person->min('age'), "Min person age");
d($person->sum('age'), "Sum persons age");
d($person->avg('age'), "Average persons age");
d($person->count('id'), "Count persons");
function d($v, $t)
{
    echo '<pre>';
    echo '<h1>' . $t . '</h1>';
    var_dump($v);
    echo '</pre>';
}

 /**
  * Display a listing of people
  *
  * @return Response
  */
 public function index()
 {
     $people = Person::all();
     return View::make('people.index', compact('people'));
 }

//
require_once '_common.php';
//
use Javanile\SchemaDB\Readable;
//
class Person extends Readable
{
    //
    public $id = self::PRIMARY_KEY;
    //
    public $name = "";
    public $surname = "";
    public $age = 0;
    public $address1 = 0;
    public $address2 = 0;
}
//
class Address extends Readable
{
    //
    public $id = self::PRIMARY_KEY;
    //
    public $name = "";
    public $latitude = 0;
    public $longitude = 0;
    public $city = "";
}
//
$Persons = Person::all(['name', 'address' => Address::join()]);
//
Person::dump($Persons);

 function testUpdateOnCollection()
 {
     $person = new Person();
     $person->age = 23;
     $person->lessThan('age', 23)->update();
     $people = $person->find();
     $this->assertEquals(count($people), 4);
     $person = new Person();
     $person->age = 100;
     $person->all()->update();
     $people = $person->find();
     $this->assertEquals(count($people), 6);
 }

<?php

/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It's a breeze. Simply tell Laravel the URIs it should respond to
| and give it the controller to call when that URI is requested.
|
*/
Route::get('/', function () {
    return view('welcome');
});
//Route::group(['prefix' => 'api/v1', 'middleware' => 'auth:api'], function () {
//    Route::post('/short', 'UrlMapperController@store');
//});
//
//Auth::guard('api')->user();
Route::get('/auth/login', function () {
    return "No tens Accés a l'API";
});
Route::group(['prefix' => 'api', 'middleware' => 'throttle:6,10'], function () {
    Route::get('people', function () {
        return Person::all();
    });
});

<?php

include_once "person_class.php";
if (count($_POST) > 0) {
    $newkid = new Person();
    $newkid->first_name = $_POST["first_name"];
    $newkid->last_name = $_POST["last_name"];
    $newkid->city = $_POST["city"];
    $newkid->state = $_POST["state"];
    $newkid->zip = $_POST["zip"];
    $newkid->email = $_POST["email"];
    $newkid->save();
}
$people = Person::all();
?>
<h1>Look at all my people</h1>
<table border="1">
    <thead>
        <tr><th>First</th>
            <th>Last</th>
            <th>City</th>
            <th>State</th>
            <th>Zip</th>
            <th>Email</th>
            <th>Action</th></tr>
    </thead>
    <tbody>
        <?php 
foreach ($people as $person) {
    echo "<tr>\n";
    echo "\t<td>{$person[1]}</td>\n";