PHP check_uniqueness Examples

Example #1

File: new_account_process.php Project: samtechnocrat/ClinicCases

$fname = trim(str_replace(' ', '', $_POST['first_name']));
$lname = trim(str_replace(' ', '', $_POST['last_name']));
$concat_name = substr($fname, 0, 1) . $lname;
$proposed_username = preg_replace("/[^a-zA-Z0-9]/", "", $concat_name);
function check_uniqueness($dbh, $proposed_username)
{
    $q = $dbh->prepare("SELECT username FROM cm_users WHERE username = '******'");
    $q->execute();
    if ($q->rowCount() > 0) {
        return true;
    } else {
        return false;
    }
}
//Loop until we get a unique username
while (check_uniqueness($dbh, $proposed_username)) {
    if (is_numeric(substr($proposed_username, -1))) {
        $digit = substr($proposed_username, -1) + 1;
        $proposed_username = substr($proposed_username, 0, -1) . $digit;
    } else {
        $proposed_username = $proposed_username . "1";
    }
}
$new_username = strtolower($proposed_username);
//Create temp password
function generatePassword($length = 8)
{
    // start with a blank password
    $password = "";
    // define possible characters
    $possible = "0123456789bcdfghjkmnpqrstvwxyz";

Example #2

File: create_past_tallies_table.php Project: cpeel/dproofreaders-shadow

// XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
echo "Creating 'past_tallies' table...\n";
dpsql_query("\n    CREATE TABLE past_tallies (\n        timestamp    int(10) UNSIGNED NOT NULL,\n        holder_type  CHAR(1)          NOT NULL,\n        holder_id    INT(6)  UNSIGNED NOT NULL,\n        tally_name   CHAR(2)          NOT NULL,\n        tally_delta  INT(8)           NOT NULL,\n        tally_value  INT(8)           NOT NULL,\n\n        PRIMARY KEY (tally_name, holder_type, holder_id, timestamp)\n    )\n") or die("Aborting.");
// -----------------------------------------------
if (check_uniqueness('member_stats', 'u_id', 'date_updated')) {
    echo "\n";
    echo "Copying user page-tallies from 'member_stats' table to 'past_tallies'...\n";
    dpsql_query("\n        INSERT INTO past_tallies\n        SELECT date_updated, 'U', u_id, 'R*', daily_pagescompleted, total_pagescompleted\n        FROM member_stats\n    ") or die("Aborting.");
    echo "Renaming 'member_stats' table...\n";
    // For ease of backing out during testing,
    // merely rename 'member_stats' table, rather than dropping it.
    dpsql_query("\n        RENAME TABLE member_stats TO member_stats_obsolete\n    ") or die("Aborting.");
    // DROP TABLE member_stats
}
// -----------------------------------------------
if (check_uniqueness('user_teams_stats', 'team_id', 'date_updated')) {
    echo "\n";
    echo "Copying team page-tallies from 'user_teams_stats' table to 'past_tallies'...\n";
    dpsql_query("\n        INSERT INTO past_tallies\n        SELECT date_updated, IF(team_id=1,'S','T'), team_id, 'R*', daily_page_count, total_page_count\n        FROM user_teams_stats\n    ") or die("Aborting.");
    echo "Renaming 'user_teams_stats' table...\n";
    // For ease of backing out during testing,
    // merely rename 'user_teams_stats' table, rather than dropping it.
    dpsql_query("\n        RENAME TABLE user_teams_stats TO user_teams_stats_obsolete\n    ") or die("Aborting.");
    // DROP TABLE user_teams_stats
}
// -----------------------------------------------
echo "\nDone!\n";
// XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
function check_uniqueness($table_name, $holder_id_column_name, $timestamp_column_name)
{
    echo "Adding index to {$table_name}. This could take a while...\n";