DesignPatternsPHP/Structural/FluentInterface/Sql.php at master · mphpify/DesignPatternsPHP · GitHub

History

80 lines (69 loc) · 1.32 KB

Raw

<?php

namespace DesignPatterns\Structural\FluentInterface;

/**

* class SQL

class Sql

{

/**

* @var array

protected $fields = array();

/**

* @var array

protected $from = array();

/**

* @var array

protected $where = array();

/**

* adds select fields

* @param array $fields

* @return SQL

public function select(array $fields = array())

{

$this->fields = $fields;

return $this;

}

/**

* adds a FROM clause

* @param string $table

* @param string $alias

* @return SQL

public function from($table, $alias)

{

$this->from[] = $table . ' AS ' . $alias;

return $this;

}

/**

* adds a WHERE condition

* @param string $condition

* @return SQL

public function where($condition)

{

$this->where[] = $condition;

return $this;

}

/**

* Gets the query, just an example of building a query,

* no check on consistency

* @return string

public function getQuery()

{

return 'SELECT ' . implode(',', $this->fields)

. ' FROM ' . implode(',', $this->from)

. ' WHERE ' . implode(' AND ', $this->where);

}

DesignPatternsPHP/Structural/FluentInterface/Sql.php at master · mphpify/DesignPatternsPHP · GitHub

Expand file tree

Breadcrumbs

Sql.php

Latest commit

History

Breadcrumbs

Sql.php

File metadata and controls