PHP tickCommaSeperate Examples

Example #1

File: DedupeCommand.php Project: anthonyvipond/deduper-laravel

 protected function insertDuplicatesToRemovalsTable($undedupedTable, $dedupedTable, $removalsTable)
 {
     $sql = 'INSERT INTO ' . $removalsTable . '(' . tickCommaSeperate($this->pdo->getColumns($undedupedTable)) . ') ';
     $sql .= 'SELECT * FROM ' . $undedupedTable . ' ';
     $sql .= 'WHERE id NOT IN ';
     $sql .= '(SELECT id FROM ' . $dedupedTable . ')';
     return $this->pdo->statement($sql);
 }

Example #2

File: simplePDO.php Project: anthonyvipond/simple-pdo

 public function createCompositeIndex($table, array $columns, $postfix = '')
 {
     $indexName = implode('_', $columns) . $postfix;
     $columns = tickCommaSeperate($columns);
     $sql = 'CREATE INDEX ' . $indexName . ' ON ' . $table . '(' . $columns . ')';
     $this->statement($sql);
 }