karkoonzaid · August 29, 2015 14:16 · May 27, 2013 · May 27, 2013 · May 27, 2013 · May 27, 2013
diff --git a/eloquent.md b/eloquent.md
@@ -86,5 +86,17 @@ Getting a sum of the query result:
 
 ``` Shop::where('orders_cache','>','100')->decrement('orders_cache'); ```
 
-
+## Todo :
+- or, between, whereNull, whereIn
+- inserts
+- updates
+- deletes
+- soft deletes
+- unions
+- raw expressions
+- grouping
+- joins
+- Fillable
+- Guarded
+- 
 
diff --git a/eloquent.md b/eloquent.md
@@ -81,9 +81,10 @@ Getting a sum of the query result:
 
 # Incrementing and decrementing values of a column:
 
-```Shop::where('orders_cache','>','100')->increment('orders_cache');```
+``` Shop::where('orders_cache','>','100')->increment('orders_cache'); ```
 
-```Shop::where('orders_cache','>','100')->decrement('orders_cache');```
+
+``` Shop::where('orders_cache','>','100')->decrement('orders_cache'); ```
 
 
 
diff --git a/eloquent.md b/eloquent.md
@@ -82,6 +82,7 @@ Getting a sum of the query result:
 # Incrementing and decrementing values of a column:
 
 ```Shop::where('orders_cache','>','100')->increment('orders_cache');```
+
 ```Shop::where('orders_cache','>','100')->decrement('orders_cache');```
 
 

diff --git a/eloquent.md b/eloquent.md
@@ -79,4 +79,10 @@ Getting a sum of the query result:
 
 ```$totalWeight = Product::where('name','Coffee')->sum('weight');```
 
+# Incrementing and decrementing values of a column:
+
+```Shop::where('orders_cache','>','100')->increment('orders_cache');```
+```Shop::where('orders_cache','>','100')->decrement('orders_cache');```
+
+
 
diff --git a/eloquent.md b/eloquent.md
@@ -77,6 +77,6 @@ Getting an average value of the query result:
 
 Getting a sum of the query result:
 
-```$averageCoffeePrice = Product::where('name','Coffee')->sum('price');```
+```$totalWeight = Product::where('name','Coffee')->sum('weight');```
 
 
diff --git a/eloquent.md b/eloquent.md
@@ -30,24 +30,24 @@ Retrieving single record that matches a certain column :
 ```$shop = Shop::where('name', 'Starbucks')->first();```
 
 Retrieving specific columns of the result (by default get() returns all columns):
-```$shop = Shop::where('name', 'Starbucks')->get('name','address','url');```
+```$shops = Shop::where('name', 'Starbucks')->get('name','address','url');```
 
-Retrieving singe column of single row :
-```$name = Shop::where('name', 'Starbucks')->pluck('address');```
+Retrieving single column of result :
+```$shopAddresses = Shop::where('name', 'Starbucks')->pluck('address');```
 
 Retrieving records matching a criteria:
 
-```$shops = Shop::where('orders_cache','>','100')->get();```
+```$profitableShops = Shop::where('orders_cache','>','100')->get();```
 where() takes 3 parameters, name of the column, operator and value to be compared against. The operator can be one of the following: 
 ```'=', '<', '>', '<=', '>=', '<>', '!=', 'like', 'not like', 'between', 'ilike'```
 
 Retrieve only a specified number of records matching a criteria:
 
-```$shops = Shop::where('state', 'CA')->take(10)->get();```
+```$californianShops = Shop::where('state', 'CA')->take(10)->get();```
 
 Skip a specified number of records:
 
-```$shops = Shops::where('name', 'Starbucks')->skip(10)->get();```
+```$someShops = Shops::where('name', 'Starbucks')->skip(10)->get();```
 
 Combining "skip" and "take" (useful for making custom paginators):
 
@@ -57,5 +57,26 @@ Using forPage() to accomplish the above statement:
 
 ```$shops = Shops::where('name', 'Starbucks')->forPage(2,25)->get();```
 
+# Aggregates
+
+Counting the number of rows of the query results:
+
+```$countStarbucks = Shop::where('name','Starbucks')->count();```
+
+Getting a maximum value of the query result:
+
+```$maxCoffeePrice = Product::where('name','Coffee')->max('price');```
+
+Getting a minimum value of the query result:
+
+```$minCoffeePrice = Product::where('name','Coffee')->min('price');```
+
+Getting an average value of the query result:
+
+```$averageCoffeePrice = Product::where('name','Coffee')->avg('price');```
+
+Getting a sum of the query result:
+
+```$averageCoffeePrice = Product::where('name','Coffee')->sum('price');```
 
 
diff --git a/eloquent.md b/eloquent.md
@@ -1,3 +1,5 @@
+# Conventions:
+
 Defining Eloquent model (will assume that DB table named is set as plural of class name and primary key named "id"):
 
 ```class Shop extends Eloquent {}```
@@ -11,4 +13,49 @@ Using custom primary key (instead of "id"):
 ```protected $primaryKey = 'my_key';```
 
 Disabling use of "created_at" and "updated_at" columns:
-```public $timestamps = false;```
+
+```public $timestamps = false;```
+
+# Retrieving records:
+
+Retrieving all records(rows) of a given model:
+
+```$shops = Shop::all();```
+
+Find and get a record by primary key:
+
+```$shop = Shop::find(1);```
+
+Retrieving single record that matches a certain column :
+```$shop = Shop::where('name', 'Starbucks')->first();```
+
+Retrieving specific columns of the result (by default get() returns all columns):
+```$shop = Shop::where('name', 'Starbucks')->get('name','address','url');```
+
+Retrieving singe column of single row :
+```$name = Shop::where('name', 'Starbucks')->pluck('address');```
+
+Retrieving records matching a criteria:
+
+```$shops = Shop::where('orders_cache','>','100')->get();```
+where() takes 3 parameters, name of the column, operator and value to be compared against. The operator can be one of the following: 
+```'=', '<', '>', '<=', '>=', '<>', '!=', 'like', 'not like', 'between', 'ilike'```
+
+Retrieve only a specified number of records matching a criteria:
+
+```$shops = Shop::where('state', 'CA')->take(10)->get();```
+
+Skip a specified number of records:
+
+```$shops = Shops::where('name', 'Starbucks')->skip(10)->get();```
+
+Combining "skip" and "take" (useful for making custom paginators):
+
+```$shops = Shops::where('name', 'Starbucks')->skip(25)->take(25)->get();```
+
+Using forPage() to accomplish the above statement: 
+
+```$shops = Shops::where('name', 'Starbucks')->forPage(2,25)->get();```
+
+
+
diff --git a/eloquent.md b/eloquent.md
@@ -2,13 +2,13 @@ Defining Eloquent model (will assume that DB table named is set as plural of cla
 
 ```class Shop extends Eloquent {}```
 
-Using custom table name
+Using custom table name 
 
 ```protected $table = 'my_shops';```
 
-Using custom primary key (instead of "id"):
+Using custom primary key (instead of "id"): 
 
 ```protected $primaryKey = 'my_key';```
 
-Disabling use of "created t" and "updated_at" columns:
+Disabling use of "created_at" and "updated_at" columns:
 ```public $timestamps = false;```
diff --git a/eloquent.md b/eloquent.md
@@ -1,11 +1,14 @@
 Defining Eloquent model (will assume that DB table named is set as plural of class name and primary key named "id"):
+
 ```class Shop extends Eloquent {}```
 
 Using custom table name
+
 ```protected $table = 'my_shops';```
 
 Using custom primary key (instead of "id"):
+
 ```protected $primaryKey = 'my_key';```
 
 Disabling use of "created t" and "updated_at" columns:
-  public $timestamps = false;
+```public $timestamps = false;```
diff --git a/eloquent.md b/eloquent.md
@@ -1,11 +1,11 @@
 Defining Eloquent model (will assume that DB table named is set as plural of class name and primary key named "id"):
-    class Shop extends Eloquent {}
+```class Shop extends Eloquent {}```
 
 Using custom table name
-    protected $table = 'my_shops';
+```protected $table = 'my_shops';```
 
 Using custom primary key (instead of "id"):
-  protected $primaryKey = 'my_key';
+```protected $primaryKey = 'my_key';```
 
 Disabling use of "created t" and "updated_at" columns:
   public $timestamps = false;
diff --git a/eloquent.md b/eloquent.md
@@ -7,5 +7,5 @@ Using custom table name
 Using custom primary key (instead of "id"):
   protected $primaryKey = 'my_key';
 
-Disabling use of "created_at" and "updated_at" columns:
+Disabling use of "created t" and "updated_at" columns:
   public $timestamps = false;
diff --git a/eloquent.md b/eloquent.md
@@ -1,8 +1,8 @@
 Defining Eloquent model (will assume that DB table named is set as plural of class name and primary key named "id"):
-  class Shop extends Eloquent {}
+    class Shop extends Eloquent {}
 
 Using custom table name
-  protected $table = 'my_shops';
+    protected $table = 'my_shops';
 
 Using custom primary key (instead of "id"):
   protected $primaryKey = 'my_key';

diff --git a/eloquent.md b/eloquent.md
@@ -0,0 +1,11 @@
+Defining Eloquent model (will assume that DB table named is set as plural of class name and primary key named "id"):
+  class Shop extends Eloquent {}
+
+Using custom table name
+  protected $table = 'my_shops';
+
+Using custom primary key (instead of "id"):
+  protected $primaryKey = 'my_key';
+
+Disabling use of "created_at" and "updated_at" columns:
+  public $timestamps = false;