Skip to content

Instantly share code, notes, and snippets.

<?php
// Doctrine\ORM\Query
function getRecentByPage($page) {
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder->select('a');
$queryBuilder->from('Blar\\Model\\News\\Article', 'a');
$queryBuilder->orderBy('a.created', 'DESC');
$query = $queryBuilder->getQuery();
@blar
blar / gist:823652
Created February 12, 2011 09:46
INSERT INTO … ON DUPLICATE KEY UPDATE
INSERT INTO
table(id, title, created, modified)
VALUES
(NULL, 'foo', NOW(), NOW()),
(NULL, 'bar', NOW(), NOW())
ON DUPLICATE KEY UPDATE
modified = VALUES(modified);
<?php
use Form,
Blar\Model\News\Article,
Blar\Model\News\Articles;
class News_IndexController extends Zend_Controller_Action {
protected $entityManager;
<?php
public function test() {
$user = $this->entityManager->getRepository('Blar\\Model\\User')->findOneById(1);
var_dump($user->getName());
$article = $this->entityManager->getRepository('Blar\\Model\\News\\Article')->findOneBy(array(
'user' => $user
));
var_dump($article->getName());
}
<?php
namespace Blar;
use Doctrine\Common\EventSubscriber,
Doctrine\ORM\Events,
Doctrine\ORM\Event\OnFlushEventArgs,
Doctrine\ORM\EntityManager;
class AuditListener implements EventSubscriber {
@blar
blar / gist:852668
Created March 3, 2011 12:02
PHP DirectoryIterator
<?php
function foo($path, $callback = NULL) {
$result = array();
$iterator = new DirectoryIterator($path);
foreach ($iterator as $fileinfo) {
if($fileinfo->isDot()) {
continue;
}
@blar
blar / gist:856735
Created March 5, 2011 21:25
Get informations via SNMP from Apple TimeCapsule with PHP
<?php
# http://www.opensource.apple.com/source/net_snmp/net_snmp-127/mibs/AIRPORT-BASESTATION-3-MIB.txt
# snmpwalk -v 2c -c public -m AIRPORT-BASESTATION-3-MIB 10.0.1.1 enterprises.apple.airport
$hostname = '10.0.1.1';
$password = 'public';
snmp_read_mib('/usr/share/snmp/mibs/AIRPORT-BASESTATION-3-MIB.txt');
snmp_set_enum_print(true);
#
# Encoding: Unicode (UTF-8)
#
CREATE TABLE `activity_like` (
`activity_id` int(11) NOT NULL,
`like_id` int(11) NOT NULL,
PRIMARY KEY (`activity_id`,`like_id`),
KEY `IDX_AFA79B2181C06096` (`activity_id`),
array(2) {
[0]=>
object(Blar\HTTP\Response)#213 (3) {
["url":protected]=>
NULL
["headers":protected]=>
array(5) {
["Status"]=>
object(Blar\HTTP\Headers\Status)#216 (3) {
["protocol"]=>
<?php
switch(array_filter(array(gettype($foo), is_object($foo) ? get_class($foo) : NULL))) {
case array('integer'):
var_dump('integer');
break;
case array('object', 'foo'):
var_dump('foo');