首页 \ 问答 \ 使用电子邮件地址查询MySQL数据库中的用户名(Query MySQL database for user names with their email addresses)

使用电子邮件地址查询MySQL数据库中的用户名(Query MySQL database for user names with their email addresses)

 我正在寻找一种方法来查询我的所有用户（很简单），但我需要让特定用户回到结果中。 我将尝试解释下面我能做的最好但总之，我想使用电子邮件地址列表作为参考，以拉动所有匹配这些电子邮件地址的用户。  
 简要概述  
 我有一个wordpress网站，我从中运行事件。 当人们注册活动时，会为他们创建一个帐户。 还有另一个与会者表，将这些用户配置文件链接到他们的注册。  
 就像现在一样，我需要获得一个特定于一个活动组织者的人员列表。 我认为最好的方法是使用来自与会者信息的电子邮件地址，并在我的wp_users表中查询用户名。  
SELECT display_name
FROM `mydatabase`.`wp_users` WHERE `user_email` LIKE 
'myemail@email.com' OR 
'mysecondemail@email.com' OR
'mythirdemail@email.com';
 
 我删除了真实的电子邮件并更改了数据库名称。  
 我想要实现的是一个查询，它将通过我的用户列表运行，比较我提供给表中用户的电子邮件地址，并返回任何匹配的用户。  
 就像现在一样，它返回它找到并停止的第一个结果。  
 我已经准备好了电子邮件列表，但我正在努力让这个工作。 

I'm looking for a way to query all of my users (simple enough) but i need to get specific users back in the results. I'll try explain the best i can below but in short i want to use a list of email addresses as a reference to pull all users matching those email addresses. 
Brief overview 
I have a wordpress website which i run events from. When people sign up for the events an account is created for them. there is also another table for attendees which links these user profiles to their registrations. 
As it is right now i need to get a list of people specific to one event organiser. I thought the best way to do this would be to use their email address from the attendee info and query my wp_users table for the user names.  
SELECT display_name
FROM `mydatabase`.`wp_users` WHERE `user_email` LIKE 
'myemail@email.com' OR 
'mysecondemail@email.com' OR
'mythirdemail@email.com';
 
I've removed the real email and changed the database name. 
What i am trying to achieve is a query that will run through my list of users comparing their email address that i provide to the users in the table and return any of them that match. 
As it is right now it returns the first result it finds and stops.  
I've got the list of emails ready to go but i am struggling to get this to work.

原文：https://stackoverflow.com/questions/43516482

更新时间：2023-07-09 13:07

最满意答案

 显然我解决了它。 在for的内部有代码用NSMutableAttributedString的图像替换子字符串。 此外，我决定在类似（但不同）的问题中对前一个答案进行反思  
NSMutableAttributedString *formattedText = myString.mutableAttributedString;

// Look for image
NSString *regEx = @"([a-z])+(?:([0-9])+){0,1}.png";
NSError *error = nil;
NSRegularExpression *regex = [NSRegularExpression
                              regularExpressionWithPattern:regEx
                              options:NSRegularExpressionCaseInsensitive error:&error];
if(error != nil){
    NSLog(@"Error: %@",error);
} else{
    NSArray *matches = [regex matchesInString:myString
                                      options:kNilOptions
                                        range:NSMakeRange(0, myString.length)];
    for (NSTextCheckingResult *result in [matches reverseObjectEnumerator])
    {
        NSString *insideString = [myString substringWithRange:[result rangeAtIndex:0]];
        UIImage *image = [UIImage imageNamed:insideString];
        NSTextAttachment *imageAttachment = [NSTextAttachment new];
        imageAttachment.image = image;
        NSAttributedString *replacementForTemplate = [NSAttributedString attributedStringWithAttachment:imageAttachment];
        [formattedText replaceCharactersInRange:result.range
                           withAttributedString:replacementForTemplate];

        NSLog(@"found! -> %@", insideString);

    }
}
 
 相反， mutableAttributedString属性属于NSString类别。 这是它的代码  
- (NSMutableAttributedString *)mutableAttributedString {
    return [[NSMutableAttributedString alloc] initWithString:self];
}

Apparently I resolved it. Inside the for there is the code to replace a substring with an image in the NSMutableAttributedString. Also I decided to put a reversed for in inspiration to a previous answer in a question similar (but different) like this 
NSMutableAttributedString *formattedText = myString.mutableAttributedString;

// Look for image
NSString *regEx = @"([a-z])+(?:([0-9])+){0,1}.png";
NSError *error = nil;
NSRegularExpression *regex = [NSRegularExpression
                              regularExpressionWithPattern:regEx
                              options:NSRegularExpressionCaseInsensitive error:&error];
if(error != nil){
    NSLog(@"Error: %@",error);
} else{
    NSArray *matches = [regex matchesInString:myString
                                      options:kNilOptions
                                        range:NSMakeRange(0, myString.length)];
    for (NSTextCheckingResult *result in [matches reverseObjectEnumerator])
    {
        NSString *insideString = [myString substringWithRange:[result rangeAtIndex:0]];
        UIImage *image = [UIImage imageNamed:insideString];
        NSTextAttachment *imageAttachment = [NSTextAttachment new];
        imageAttachment.image = image;
        NSAttributedString *replacementForTemplate = [NSAttributedString attributedStringWithAttachment:imageAttachment];
        [formattedText replaceCharactersInRange:result.range
                           withAttributedString:replacementForTemplate];

        NSLog(@"found! -> %@", insideString);

    }
}
 
Instead the mutableAttributedString property belongs to a NSString Category. This is the code of it 
- (NSMutableAttributedString *)mutableAttributedString {
    return [[NSMutableAttributedString alloc] initWithString:self];
}

使用电子邮件地址查询MySQL数据库中的用户名(Query MySQL database for user names with their email addresses)

简要概述

Brief overview

最满意答案

相关问答

正则表达式在Adobe Dreamweaver中查找和替换(Regular expression find and replace in Adobe Dreamweaver)[2023-11-28]

sublime text替换并查找表达式正则表达式(sublime text replace and find expression regular expression)[2022-09-16]

使用正则表达式在Xcode中查找/替换(Find/Replace in Xcode using Regular Expression)[2024-01-10]

使用正则表达式在NSString中查找/替换子串(Use regular expression to find/replace substring in NSString)[2023-04-02]

Microsoft Excel查找和替换正则表达式(Microsoft Excel Find and Replace with regular expression)[2022-09-24]

我们可以通过在记事本中使用另一个正则表达式来查找和替换正则表达式吗？(Can we find and replace a regular expression by using another regular expression in notepad?)[2022-02-19]

使用正则表达式查找文本并替换文件(Find text with regular expression and replace in file)[2023-11-20]

正则表达式来替换'<？'(regular expression to replace '[2023-03-21]

NSString找到正则表达式并用image替换它（NSMutableAttributeString）(NSString find regular expression and replace it with image (NSMutableAttributeString))[2022-09-29]

使用正则表达式在NSString中查找和替换Textfield中的字符串(Use regular expression to find and replace the string from Textfield in NSString)[2022-07-16]

相关文章

最新问答