Ivory ORM Docs

Ivory ORM Docs

  • Docs

›SQL Syntax

SQL Syntax

  • First-Steps
  • Select
  • Select Distinct
  • Where
  • And, Or and Not
  • Order By
  • Insert
  • Update
  • Delete
  • Min and Max
  • Count, Avg and Sum
  • Like
  • In
  • Between
  • Alias
  • Joins
  • Union
  • Group By
  • Having
  • Exists
  • Any & All
  • Procedures

Select

Select

The steps to made a simple select in ivory are very simple as write the query manually.

Example

//import the ivory class
require_once('Operations.php');

//the instance of the ivory
$ivoryOrm = new Operations();

//an array where you add all the field names of the fields you want to  select
$arrSelect[] = "name";
$arrSelect[] = "email";

//an array where you add all the table names you want to  select
$tables[] = "users";

//the method select creates the query : SELECT name,email FROM users;
$select = $ivoryOrm->select($arrSelect, $tables);

//the method runQuery is responsible to literally run your query into the database;
$result = $ivoryOrm->runQuery($select);

Example 2

$arrSelect[] = "users.name";
$arrSelect[] = "country.userCountry";

$tables[] = "users";
$tables[] = "country";

$select = $ivoryOrm->select($arrSelect, $tables);
//output SELECT users.name,country.userCountry FROM users,country;

← First-StepsSelect Distinct →
  • Select
  • Example
  • Example 2
Repository Link
Copyright © 2020 Kevin da Silva