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);
90 $row = $pdo->query("SELECT * FROM $tableName LIMIT 1")->fetch();
102 $pdo->exec("RENAME TABLE $tableName TO $tableNameOld");
105 $pdo->exec("
123 $pdo->exec("
139 $pdo->exec("ALTER TABLE $tableName RENAME TO $tableNameOld");
143 $pdo->exec("
160 $pdo->exec("
190 … $pdo->exec("ALTER TABLE $tableName ADD synctoken INT(11) UNSIGNED NOT NULL DEFAULT '1'");
191 $pdo->exec("ALTER TABLE $tableName DROP ctag");
192 $pdo->exec("UPDATE $tableName SET synctoken = '1'");
195 $pdo->exec("ALTER TABLE $tableName ADD synctoken integer");
196 $pdo->exec("UPDATE $tableName SET synctoken = '1'");
210 $pdo->query("SELECT * FROM $changesTable LIMIT 1");
221 $pdo->exec("
234 $pdo->exec("
245 … $pdo->exec("CREATE INDEX {$itemType}id_synctoken ON $changesTable ({$itemType}id, synctoken);");
255 $pdo->query("SELECT * FROM calendarsubscriptions LIMIT 1");
266 $pdo->exec("
285 $pdo->exec("
303 … $pdo->exec("CREATE INDEX principaluri_uri ON calendarsubscriptions (principaluri, uri);");
311 $pdo->query("SELECT * FROM propertystorage LIMIT 1");
322 $pdo->exec("
330 $pdo->exec("
335 $pdo->exec("
343 $pdo->exec("
358 $row = $pdo->query("SELECT * FROM cards LIMIT 1")->fetch();
368 $pdo->exec("RENAME TABLE cards TO cards_old$random");
371 $pdo->exec("ALTER TABLE cards RENAME TO cards_old$random");
388 $pdo->exec("
404 $pdo->exec("
421 $pdo->exec("
430 $pdo->exec("
438 $result = $pdo->query('SELECT id, carddata FROM cards');
439 $stmt = $pdo->prepare('UPDATE cards SET etag = ?, size = ? WHERE id = ?');