PHP queryMySQLData Exemples

Exemple #1

Fichier : mysql.php Projet : extendgears/php-components

function initTable($name, $query)
{
    $resultCheck = queryMySQLData('SELECT 1 FROM ' . $name . ' LIMIT 1');
    if ($resultCheck == false) {
        queryMySQLData($query);
    }
}

Exemple #2

Fichier : user.php Projet : extendgears/php-components

function addCustomFields($fieldarray)
{
    foreach ($fieldarray as $name => $type) {
        $name = secureString(strtolower($name));
        $type = secureString($type);
        $query = 'ALTER TABLE ' . DB_PREFIX . DB_USERS . ' ADD ' . $name . ' ' . $type;
        queryMySQLData($query);
    }
}