Need help in PHP and in SQL

[stawkerm0h]

do i need to create another database for this??

because i already have the database of bad words...

if i need to create new....please help how and what will be the value for each field...

 

<?php
include('../../includes/inc.conn.php');

function swear_filter($string)
{
  $words = array();
  $query = "SELECT word FROM bad_words";
  $result = mysql_query($query) or die(mysql_error());
  while($row = mysql_fetch_array($result)){
    $words[] = '/\b' . $row['word'] . '\b/i';
  }
  return preg_replace($words, '***', $string);
}

$string_to_check = "My shitzu took a Shit on the carpet.";
echo swear_filter($string_to_check);

//Assuming the word 'shit' is in the db results
//Output: "My shitzu took a *** on the carpet"
?>

 

 

 

 

 

 

 

 

[RussellReal]

just add a new word to the table 

[stawkerm0h]

what will be the value for new word table and what will be it's name? "word"?? and the value??

 

here's my database

 

 

 

 

 

and here's the list of my bad words

 

 

please help thanks

[RussellReal]

uhm.. go to the top, pick 'insert'

 

then where it says 'word' insert the new bad word...

 

then where it says replacement.. doesn't matter what you put, you don't use that field, hit save, and you're done, BINGO new word added..

[MadLittleMods]

maybe this will help: http://www.phpfreaks.com/forums/index.php?topic=326822.0

[stawkerm0h]

what is the value for the new table "word"...

is it varchar??primary,not null and auto-increment?