PMA\libraries\Tracker::deleteTracking PHP Method

deleteTracking() public static method

Removes all tracking data for a table or a version of a table
public static deleteTracking ( string $dbname, string $tablename, string $version = '' ) : integer
$dbname string name of database
$tablename string name of table
$version string version
return integer result of version insertion
    public static function deleteTracking($dbname, $tablename, $version = '')
    {
        $sql_query = "/*NOTRACK*/\n" . "DELETE FROM " . self::_getTrackingTable() . " WHERE `db_name` = '" . $GLOBALS['dbi']->escapeString($dbname) . "'" . " AND `table_name` = '" . $GLOBALS['dbi']->escapeString($tablename) . "'";
        if ($version) {
            $sql_query .= " AND `version` = '" . $GLOBALS['dbi']->escapeString($version) . "'";
        }
        $result = PMA_queryAsControlUser($sql_query);
        return $result;
    }

Usage Example

Ejemplo n.º 1
0
/**
 * Deletes a tracking version
 *
 * @param string $version tracking version
 *
 * @return string HTML of the success message
 */
function PMA_deleteTrackingVersion($version)
{
    $html = '';
    $versionDeleted = Tracker::deleteTracking($GLOBALS['db'], $GLOBALS['table'], $version);
    if ($versionDeleted) {
        $msg = Message::success(sprintf(__('Version %1$s of %2$s was deleted.'), htmlspecialchars($version), htmlspecialchars($GLOBALS['db'] . '.' . $GLOBALS['table'])));
        $html .= $msg->getDisplay();
    }
    return $html;
}
All Usage Examples Of PMA\libraries\Tracker::deleteTracking