本文整理汇总了PHP中Dao::self_columns方法的典型用法代码示例。如果您正苦于以下问题：PHP Dao::self_columns方法的具体用法？PHP Dao::self_columns怎么用？PHP Dao::self_columns使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Dao的用法示例。
在下文中一共展示了Dao::self_columns方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: create_sql
public function create_sql(Dao $dao)
{
$insert = $vars = array();
$autoid = null;
foreach ($dao->self_columns() as $column) {
$insert[] = '`' . $column->column() . '`';
$vars[] = $this->update_value($dao, $column->name());
if ($column->auto()) {
$autoid = $column->name();
}
}
return Dao::daq('insert into `' . $column->table() . '`(' . implode(',', $insert) . ') values (' . implode(',', array_fill(0, count($insert), '?')) . ');', $vars, $autoid);
}示例2: select_sql
public function select_sql(Dao $dao, Q $query, $paginator)
{
$select = $from = $order = array();
$self_columns = $dao->self_columns();
foreach ($dao->columns() as $column) {
$select[] = $column->table_alias() . ".`" . $column->column() . "` " . $column->column_alias();
$from[$column->table_alias()] = $column->table() . " " . $column->table_alias();
}
foreach ($query->order_by() as $q) {
foreach ($q->arArg1() as $column_str) {
$order[] = $this->column($column_str, $self_columns)->column_alias() . ($q->type() == Q::ORDER_ASC ? " asc" : " desc");
}
}
list($where_sql, $where_vars) = $this->where_sql($dao, $query, $self_columns, $this->where_cond_columns($dao, $from));
return (object) array("sql" => "select " . implode(",", $select) . " from " . implode(",", $from) . (empty($where_sql) ? "" : " where " . $where_sql) . (empty($order) ? "" : " order by " . implode(",", $order)) . ($paginator instanceof Paginator ? sprintf(" limit %d,%d ", $paginator->offset(), $paginator->limit()) : ""), "vars" => $where_vars);
}