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";
