Code Duplication    Length = 18-24 lines in 2 locations

class/adodb.php 1 location

@@ 981-998 (lines=18) @@
978
	 * @param	string	$tbl
979
	 * @return	boolean
980
	 */
981
	public function TblExists ($tbl) {
982
		if ($this->IsDbSybase()) {
983
			$sql = "select count(1) as c from sysobjects where name = '$tbl' and type = 'U'";
984
			$rs = $this->Execute($sql);
985
			return (0 != $rs->fields['c']);
986
		}
987
		elseif ($this->IsDbMysql()) {
988
			$sql = "SHOW TABLES LIKE '$tbl'";
989
			$rs = $this->Execute($sql);
990
			return (0 != $rs->RowCount());
991
		}
992
		else {
993
			// :NOTICE: Un-tested method
994
			$sql = "select 1 from $tbl";
995
			$rs = $this->Execute($sql);
996
			return (0 == $this->ErrorNo());
997
		}
998
	} // end of func TblExists
999
1000
1001
	/**

src/Fwlib/Bridge/Adodb.php 1 location

@@ 1190-1213 (lines=24) @@
1187
     * @param   string $table
1188
     * @return  boolean
1189
     */
1190
    public function isTableExist($table)
1191
    {
1192
        $table = addslashes($table);
1193
1194
        // @codeCoverageIgnoreStart
1195
        if ($this->isDbSybase()) {
1196
            $sql = "SELECT count(1) AS c FROM sysobjects WHERE name =
1197
                '{$table}' AND type = 'U'";
1198
            $rs = $this->execute($sql);
1199
1200
            return (0 != $rs->fields['c']);
1201
1202
        } elseif ($this->isDbMysql()) {
1203
            $sql = "SHOW TABLES LIKE '$table'";
1204
            $rs = $this->execute($sql);
1205
1206
            return (0 != $rs->RowCount());
1207
1208
        } else {
1209
            // :THINK: Better method ?
1210
            $sql = "SELECT 1 FROM $table";
1211
            $this->execute($sql);
1212
1213
            return (0 == $this->conn->ErrorNo());
1214
        }
1215
        // @codeCoverageIgnoreEnd
1216
    }