Jump to content

Exploding and Mysql arrays


oracle259

Recommended Posts

Not certain which forum this belongs in but here goes.

How can I explode numbers and symbols from a mysql query.
eg.  if  i have a table with column pwd which contains  2 row with the following information:
w2@%Def1IP!4m
bn3tj45#m%$nt

??? how do i go about exploding the numbers and symbols to get a result that gives me the following output:

array("wDefIPm","bntjmnt")

If you have any suggestions i would really appreciate it
Link to comment
Share on other sites

first of all, you're not looking for exploding.  exploding breaks up a string into an array based on what you're exploding with; that is, you're splitting up the string based on a delimiter.

second, a simple str_replace() should work for your purposes.  load all of your unwanted characters into an array and replace them with nothing:

[code]<?php
$unwanted_characters = array
(
  '!',
  '@',
  '#',
  '$'
);

$replacees = array_merge(range(0, 9), $unwanted_characters);

$actual_password = str_replace($replacees, '', $stored_password);
?>[/code]

this will automatically include digits, so just add all the other characters you want to get rid of into that $unwanted_characters array.  look up the function, it's useful.
Link to comment
Share on other sites

Ok i read up on str_replace and ur right its exactly what i was looking for. But im still somewhat confused so let me tell u what im tryin to do. Basically, i need a function that would check a userid for profanity eg fshit.%4m would not be accepted as a proper userid. The banned words would be stored in a mysql database and userids would be checked against it. Ok now need to know if im on the right track with the following code:

<?php
$sql = "SEARCH profanity FROM filter";
$result = @mysql_query($sql);
while ($words = @mysql_fetch_array($result, MYSQL_BOTH) {
$profanity[] = $words[profanity];
}
$kill_characters = array ('.', '-', '_');
$kill_num = range(0,9);
$kill_all = array_merge($kill_num, $kill_characters);

$userid = str_replace($kill_all, '' ", $userid);

$obscene = $profanity[];
foreach ($obscene as $obscenities) {
if (stristr(trim($userid), $obscenities)) {
  $match = similar_text($userid, $obscenities, $percent);
  $percent = round($percent, 2);
  if ($percent >= '50') {
  echo "Sorry, username <b>$userid</b> is too vulgar. Please select another username.";
} else {
echo "Congratulations, username <b>$userid</b> is available.";
}
} else {
echo "Congratulations, username <b>$userid</b> is available.";
}
}

?>

Where am i going wrong?  ???
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.