Help, MySQL questions...

MtPHP

I'm sure this is obvious easy stuff but please help me with the following.
Firstly, I have a variable $reguser and I've done strtolower and called it $lowerreguser. Now I want to SELECT * FROM users WHERE 'username' = $lowerreguser, but there are some problems, firstly I don't know how I'd put this in PHP, secondly, I need to firstly convert the retrieved usernames to lowercase so if someone already has JustTesting and someone registers with jUSTtESTING it will still know they're already registered, and secondly I don't have a clue how to say if exists do this else if doesn't exist, do this. How can I go about that? Thanks all!

MtPHP

Oops I forgot to include the second thing I want to do.
I want to use strstr on something. For example,
I want to SELECT * FROM badwords
Then I need to do strstr($lowerreguser, "the words from MySQL") but it has to be strstr($lowerreguser, "the") || strstr($lowerreguser, "words") and so on to work (I think). How?

nnichols

Here is an example of a simple word filter -

$host = '';
$usr = '';
$pswd = '';
$db_name = '';

$db = mysql_pconnect($host, $usr, $pswd) or die('Failed to connect to server: ' . mysql_error());
mysql_select_db($db_name) or die('Failed to select db: ' . mysql_error());
// the "i" after the pattern delimiter indicates a case-insensitive search
// the \b in the pattern indicates a word boundary, so only the distinct
// word "$word" is matched, and not a word partial like "$word"ing

sql = "SELECT words FROM profanity";
$res = mysql_query($sql);

while($row = mysql_fetch_array($res)) {

$word = $row['words'];
if(preg_match ("/\b$word\b/i", $content))
	$flagged = 1;
}

if($flagged == 1) {
	print 'some error text';
	exit;
}

Post the code you've got relating to your first question and I'll have a look. 😉

MtPHP

Thanks for that. Note you missed a $ off the beginning of sql. That worked fine. Ok there is no code really. BAsically, I have a variable $lowerreguser, what I want to do is see if that username already exists in the 'users' table. But I want to see if it exists in any case, for example if $lowerreguser consits of justtesting and there is an entry with 'username' as JuSTtEStiNG I want it to detect taht and pull up the error, too. How can I do this? Thanks!

nnichols

Unless your user name is cast as 'BINARY' the SELECT will be case-insensitive by default.