Lines Matching refs:pdo
62 $pdo = new PDO($dsn, $user, $pass); variable
63 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
64 $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
66 $driver = $pdo->getAttribute(PDO::ATTR_DRIVER_NAME);
84 $result = $pdo->query('SELECT * FROM propertystorage LIMIT 1');
95 $pdo->exec('RENAME TABLE propertystorage TO propertystorage_old' . $random);
96 $pdo->exec('
105 …$pdo->exec('CREATE UNIQUE INDEX path_property_' . $random . ' ON propertystorage (path(600), name…
108 $pdo->exec('ALTER TABLE propertystorage RENAME TO propertystorage_old' . $random);
109 $pdo->exec('
118 … $pdo->exec('CREATE UNIQUE INDEX path_property_' . $random . ' ON propertystorage (path, name);');
140 $pdo->exec('ALTER TABLE propertystorage ADD valuetype INT UNSIGNED');
143 $pdo->exec('ALTER TABLE propertystorage ADD valuetype INT');
148 $pdo->exec('UPDATE propertystorage SET valuetype = 1 WHERE valuetype IS NULL ');
154 $result = $pdo->query('SELECT id, uri, vcardurl FROM principals WHERE vcardurl IS NOT NULL');
155 $stmt1 = $pdo->prepare('INSERT INTO propertystorage (path, name, valuetype, value) VALUES (?, ?, 3,…