예제 #1
0
파일: editTest.php 프로젝트: g7o/sqw
            break;
        case 512:
            check($connection, "SELECT mail FROM users WHERE mail='{$textInput}'");
            break;
        case 513:
            check($connection, "SELECT isActivated FROM users WHERE isActivated='\${$textInput}'");
            break;
        case 514:
            check($connection, "SELECT isRetailer FROM users WHERE isRetailer='{$textInput}'");
            break;
        case 521:
            check($connection, "SELECT isActivated FROM notice WHERE isActivated='{$textInput}'");
            break;
        case 531:
            check($connection, "SELECT isActivated FROM rating WHERE isActivated='{$textInput}'");
            break;
        case 541:
            check($connection, "SELECT title FROM categories WHERE title='{$textInput}'");
            break;
        case 550:
            changePasswordBe($connection, $username, $password, $pwOld);
            break;
        case 560:
            listCategories($connection, $textInput);
            break;
    }
    mysqli_close($connection);
} else {
    mysqli_close($connection);
    echo "DB-Connection Failed";
}
예제 #2
0
파일: edit.php 프로젝트: g7o/sqw
            break;
        case 511:
            check($connection, "SELECT username FROM users WHERE username='******'");
            break;
        case 512:
            check($connection, "SELECT mail FROM users WHERE mail='{$textInput}'");
            break;
        case 513:
            check($connection, "SELECT  isActivated FROM users WHERE isActivated='\${$textInput}'");
            break;
        case 514:
            check($connection, "SELECT  isRetailer FROM users WHERE isRetailer='{$textInput}'");
            break;
        case 521:
            check($connection, "SELECT  isActivated FROM notice WHERE isActivated='{$textInput}'");
            break;
        case 531:
            check($connection, "SELECT  isActivated FROM rating WHERE isActivated='{$textInput}'");
            break;
        case 541:
            check($connection, "SELECT  title FROM categories WHERE title='{$textInput}'");
            break;
        case 550:
            changePasswordBe($connection, $username, $pwOld, $pwNew, $pwNewChk);
            break;
    }
    mysqli_close($connection);
} else {
    mysqli_close($connection);
    echo "DB-Connection Failed";
}