Lines Matching refs:st
874 $st = $this->db->prepare( $sql );
875 if ( !$st )
878 if ( !$st->execute( array( $rowid ) ) )
881 $row = $st->fetch( PDO::FETCH_NUM );
883 $st->closeCursor();
1128 $st = $this->db->prepare( $sql );
1129 if ( !$st )
1132 if ( !$st->execute( array_values( $record ) ) )
1210 $st = $this->db->prepare( $sql );
1211 if ( !$st )
1214 if ( !$st->execute( array( $duplicateOf ? $duplicateOf : $rowid ) ) )
1217 $record = $st->fetch( PDO::FETCH_ASSOC );
1221 $st->closeCursor();
1396 $st = $this->db->prepare( 'DELETE FROM ' . $this->table . ' WHERE '.
1398 if ( !$st )
1401 if ( !$st->execute( array( $rowid ) ) )
1550 $st = $this->db->prepare( $query . $filter );
1551 if ( !$st )
1554 if ( !$st->execute( $parameters ) )
1557 $count = $st->fetch( PDO::FETCH_NUM );
1559 $st->closeCursor();
1664 $st = $this->db->prepare( $query . $filter . $order . $limit );
1665 if ( !$st )
1668 if ( !$st->execute( $parameters ) )
1671 return $st->fetchAll( PDO::FETCH_ASSOC );
2679 $st = $this->db->prepare( 'SELECT ' . implode( ',', $cols ) .
2681 if ( !$st )
2684 if ( !$st->execute( $parameters ) )
2689 while ( ( $record = $st->fetch( PDO::FETCH_NUM ) ) !== false )
2692 $st->closeCursor();
2719 $st = $this->db->prepare( 'SELECT ' . implode( ',', $cols ) .
2722 if ( !$st )
2725 if ( !$st->execute( $parameters ) )
2729 $record = $st->fetch( PDO::FETCH_NUM );
4174 $st = $this->db->prepare('SELECT recent FROM __keys WHERE tablename=?');
4175 if ( !$st )
4178 if ( !$st->execute( array( $table ) ) )
4182 $row = $st->fetch( PDO::FETCH_NUM );
4196 $st->closeCursor();
4200 $st = $this->db->prepare( $sql );
4201 if ( !$st )
4204 if ( !$st->execute( array( $nextID, $table ) ) )
4289 $st = $this->db->prepare( 'INSERT INTO __log (tablename,rowid,action,' .
4291 if ( !$st )
4294 if ( !$st->execute( array( $table, intval( $rowid ), $action,
4373 $st = $this->db->prepare( 'SELECT COUNT(*) FROM __locks ' .
4376 if ( !$st )
4379 if ( !$st->execute( array( $table, $currentUser ) ) )
4383 $count = $st->fetch( PDO::FETCH_NUM );
4387 $st->closeCursor();
4395 $st = $this->db->prepare( 'SELECT username,obtained FROM __locks ' .
4397 if ( !$st )
4400 if ( !$st->execute( array( $table, $rowid ) ) )
4403 $lock = $st->fetchAll( PDO::FETCH_NUM );
4435 $st = $this->db->prepare( $sql );
4436 if ( !$st )
4439 if ( !$st->execute( array( $currentUser, time(), $table, $rowid ) ))
4506 $st = $this->db->prepare( 'DELETE FROM __locks WHERE tablename=? AND ' .
4508 if ( !$st )
4511 if ( !$st->execute( array( $table, $rowid, $currentUser ) ) )