PHP - Case In Where Statement

I need to make the following code work without case sensitivity.  For example, if this was processed, I would like for $message to be changed from

"Stupid is not a nice word. Ugly is not nice either."

to

"unintelligent is not a nice word. unattractive is not nice either."

For my purposes, I don't care that the capitalization changes, I just need the $goodwords to be replaced with the $badwords regardless of capitalization.

Any ideas here?

Code: [Select]
<?php

$message = "Stupid is not a nice word. Ugly is not nice either.";

$badwords = array("stupid", "ugly");
$goodwords = array("unintelligent", "unattractive" );

$message = str_replace($badwords, $goodwords, $message);

?>

hi,

i just wanted to know...

$arr[0] $arr[1] $arr[2] also this $arr[1] would be called a value, but how are the numbers 0,1 and 2 called? are that keys?

didn't know where else to post this question.

How do I make the username and password checking CASE SENSITIVE?

$result=sprintf("SELECT * FROM  db WHERE username = '%s' AND watchword ='%s'", mysql_real_escape_string($username), mysql_real_escape_string($password));

Thanks.
Bickey.

I have a pspell script and I want it to ignore upper case. ie at the moment if I check spelling for say christopher it returns spelling error of Christopher (upper case C)



<?php

$query = 'helllo';

    $pspell_config = pspell_config_create("en");
    pspell_config_ignore($pspell_config, 5);
    pspell_config_mode($pspell_config, PSPELL_FAST);
    pspell_config_personal($pspell_config, "/home/*/public_html/custom.pws");
    pspell_config_repl($pspell_config, "/home/*/public_html/custom.repl");
    $pspell_link = pspell_new_config($pspell_config);

    $words = preg_split ("/\s+/", $query);
    $ii = count($words);

    global $spellchecked;
    $spellchecked = "";

    for($i=0;$i<$ii;$i++){

        if (pspell_check($pspell_link, $words[$i]))
        {
            $spellchecked .= $words[$i]." ";
        }
        else
        {
            $erroneous = "yes";
            $suggestions = pspell_suggest($pspell_link, $words[$i]);
            $spellchecked .= $suggestions[0]." ";
        }
    }
    if($erroneous == "yes")
    {
        $spellchecked2 = str_replace(" ", "+", $spellchecked);
        echo "Did you mean: <a href=GetSearchResults.php?Query=$spellchecked2&catID=&siteID=3><i>".$spellchecked."</a></i>?";
    }
    else
    {
        echo $spellchecked . " is a valid word/phrase";
    }
?>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=317710.0

when the simple search script in the tutorials on this site searches my mySQL database it doesnt find results unless they are typed in the same case as the original entry. ie 'horse' does not find 'Horse'

is it some problem with my database table formats or do i need to add a bit of script to the search to solve it?

I have this $str variable which say holds "String" and in my comparison I'm checking if it's content is "string" and it is supposed to return true but it isnt because of the case, how do I compare them without the case being an issue ?

I am using preg_replace to automatically bold "$word" when it appears. It will only replace the word when capitalized. How can I get it to replace the word without being case sensitive.

Also could I also throw a link in? I tried and I get a syntax error. I'm guessing the links in PHP are different than HTML

Here is my code


<?php

$find ="/$word/";
 $replace ="<b>$word</b>";

 Echo preg_replace ($find, $replace, $definition); ?>

Thanks

Hi everyone,   On our school website, we've got a page where students can do a quiz, and get feedback given to them, as to whether their answers are correct or incorrect.   The code echos the student response for each question, and the feedback, tick / cross is displayed in the adjacent column.   However, I've just changed the input box from a text field to a text area, and I've noticed a little quirk.   The student answer, after pressing submit, now displays in lower case. Is their any way I can echo their answer, exactly as they input it.   Here is the relevant code:

<textarea name="user_answer_<?=$row_counter?>" cols="40" rows="2" /><?=$userAnswer?></textarea>

Thanks for your time, Dave

i want to make a simple forced lower case  form but i got stuck on it  to begin with i want to everything user's write and submit convert to lowercase am i using the right code? i'm not sure about using preg_match in this situation but i dont know what else to do
don't be harsh with me i'm noob     

<?php
if(isset($_GET['user'])&&!empty($_GET['user']))
{
$user = $_GET['user'];
if (preg_match('$englishUpperAlphabet'//English alphabet Upper case  array//',$user)){
$user = mb_strtolower($user);
echo $user;
}
else{
echo 'none';
}}
?>

<form action="t.php" action="GET">
name:
<input type="text" name="user" > <br>
<input type="submit" value="submit" >
</form>

Hello, I am having a small issue with a case switch array that uses a range of data. I am using it to set the background of table cells depending on the data. I.E. 0-0.9, 1-1.9 etc with each one being a different color. Issue I am having is it doesn't change. It sets it based on the first array entry. What might I be missing? This is the first time I have used a case switch with a range.    -Thanks

$magScale = '';

           switch($magnitude)
{
              case myInterval >= 0 && myInterval <= 0.9: $magScale = 'rgb(195, 218, 236)';
                             break;
              case myInterval >= 1 && myInterval <= 1.9: $magScale = 'rgb(210, 238, 197)';
                             break;
              case myInterval >= 2 && myInterval <= 2.9: $magScale = 'rgb(244, 240, 202)';
                             break;
              case myInterval >= 3 && myInterval <= 3.9: $magScale = 'rgb(244, 223, 202)';
                             break;
              case myInterval >= 4 && myInterval <= 4.9: $magScale = 'rgb(240, 199, 205)';
                             break;
              case myInterval >= 5 && myInterval <= 10:  $magScale = 'rgb(212, 195, 236)';
                             break;

}

I'm having issues with the following:

Code: [Select]
<?php
session_start();
$_SESSION['username']=$_POST['username'];
$_SESSION['password']=$_POST['password'];
if($_SESSION['username']=="username" && $_SESSION['password']=="password"){
if($_GET['product']=="add"){
$content.='
<p><label>Product Name:</label> <input type="text" name="product_name" size="30" />
<label>Product Price:</label> <input type="text" name="product_price" size="5" />
</p>
<p><label>Product Category:</label> <input type="text" name="product_category" size="30" /></p>
<p><label>Product Link:</label> <input type="text" name="product_link" size="30" /></p>
<p><label>Product Image:</label> <input type="text" name="product_image" size="30" /></p>
<p><label>Product Tag:</label> <input type="text" name="product_tag" size="30" /></p>
<p><label>Product Keywords:</label> <input type="text" name="keyword" size="30" /></p>
<p><label>Product Features:</label><br />
<textarea name="product_features" rows="10" cols="60"></textarea>
</p>
<p><label>Product Pros:</label><br />
<textarea name="product_pros" rows="5" cols="30"></textarea>
</p>
<p><label>Product Cons:</label><br />
<textarea name="product_cons" rows="5" cols="30"></textarea>
</p>
<p><label>Product Description:</label><br />
<textarea name="product_description" rows="10" cols="60"></textarea>
</p>
<p><label>Product Notes:</label><br />
<textarea name="product_notes" rows="5" cols="30"></textarea>
</p>
';
$logout='<div><a href="./acp_admincp.php?log-out">Log-Out</a></div>';
}
elseif($_GET['product']=="view"){
}
else{
$content.='
<a href="./admincp.php?product=add">Add New Product</a>
<br />
<a href="./admincp.php?product=view">View Products</a>
';
}
}
elseif(isset($_GET['log-out'])){
session_start();
session_unset();
session_destroy();
header("Location: ./admincp.php");
}
else{
$content='
<form action="./admincp.php" method="post">
<p><label>Username:</label> <input type="text" name="username" size="30" />';
$content.='</p>
<p><label>Password:</label> <input type="password" name="password" /></p>';
$content.='<p><input type="submit" value="Submit" name="Submit" /></p>
</form>';
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<base href="http://ghosthuntersportal.com/" />
<title>Ghost Hunter's Portal - Admin Control Panel</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="verify-v1" content="" />
<meta name="keywords" content="ghost, hunters, hunter, ghosts, spirit, spirits, paranormal, investigation, investigator, investigators, k2, emf, meter, kii" />
<meta name="description" content="Ghost Hunters Potal. Parnormal research equipment store." />
<meta name="author" content="Andrew McCarrick" />
<meta name="robots" content="index, follow"
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<img src="./logo.png" alt="Ghost Hunter's Portal Admin Control Panel" />
<br />
<div style="color: #AA44AA; font-size: 26px; margin-top: -30px; margin-left: 125px;">Admin Control Panel</div>
<?php
echo $logout;
echo $content;
?>
</body>
</html>

I can log-in, and get to the page with the two links on it. However, once I click one of the links it falls back to the log-in page, and it ends up being a never ending loop.

It's doing this:
Log-In --> Page with links ---> Log-In page again

Should be doing this:
Log-In --> Page with links --> Add Product page or View Products page

I can never get into the the actual sub page.

Just to be clear, the address bar actually shows product=add or product=view, but it still shows the log-in page.

Once again the php noob returns with another boggle..... 

I got my client search working, but when it searches the database, it is only searching case sensative, and its not searching partial words.  like for example using last names, if i search for Angeleyezz it will find Angeleyezz, but if i search angeleyezz it wont find it, nor will it find it if i search it as angel, ang, eye, etc etc etc.  same goes for all fields that i am searching, name, address, telephone number, city, etc.  how do i change this?

my form code is he
Code: [Select]
<form method="get" action="search_client_function.php">
    <input type="text" name="search_term" value="search">
    <input type="submit" name="search" value="search" />
    </form>
my search_client_function.php code is he
Code: [Select]
<?php
$title = "Search Results"; 
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  
include('includes/header.php');

mysql_select_db("terra_elegante_operations", $con);



$searchfor = $_GET['search_term'];


$query = "select * from client_information where concat (account_number,name_first,name_last,address,city,state,zipcode,telephone,telephone_alt,email)  like \"%$searchfor%\"";

$result = mysql_query($query) or die("Couldn't execute query");
?>
<br /><br />
<table border="2" cellspacing="0" cellpadding="3" width="960" bordercolor="#000000">
  <tr bgcolor="#e6e6e6" align="center">
    <td><font face="verdana" size="2" color="#000000"><b>Account Number</b></font></td><td><font face="verdana" size="2" color="#000000"><b>First Name</b></font></td><td><font face="verdana" size="2" color="#000000"><b>Last Name</b></font></td><td><font face="verdana" size="2" color="#000000"><b>Address</b></font></td><td><font face="verdana" size="2" color="#000000"><b>City</b></font></td><td><font face="verdana" size="2" color="#000000"><b>State</b></font></td><td><font face="verdana" size="2" color="#000000"><b>Zipcode</b></td><td><font face="verdana" size="2" color="#000000"><b>Telephone #</b></font></td><td><font face="verdana" size="2" color="#000000"><b>Telephone Alt</b></font></td>
<?php
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td><font face="verdana" size="1" color="#000000"><?php echo $row['0'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['1'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['2'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['3'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['4'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['5'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['6'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['7'] ?></font></td><td><font face="verdana" size="1" color="#000000"><?php echo $row['8'] ?></font></td>
</tr>
<?php
}
?>
</table>



<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />


<?php
include('includes/footer.php');
?>
I know its a bit sloppy, but I'm a php noob =\  this is the only way i could get it to work lol.

Hi,

I have been using an old contact form for a while now, this is it:
Code: [Select]
<?php
if (isset($_POST['submit'])) {
  switch($_POST['contact_type']) {
      case 'Customer':
      $to = '...@gmail.com';
      break;
case 'HQ';
      $to = '...@gmail.com';
      break;  
    case 'Office 2':
      $to = '...@gmail.com';
      break;
    case 'Office 3':
      $to ='...@gmail.com';
      break;
   case 'Office 4':
      $to = '...@gmail.com'; 
      break;
    case 'Office 5':
      $to = '...@gmail.com'; 
      break;
  }
 
  $subject = "WEBSITE ENQUIRY";
  $name_field = $_POST['name'];
  $email_field = $_POST['email'];
  $message = $_POST['message'];
 
  if (strlen(trim($message)) > 0) {
 
    $body = "From: $name_field\n E-Mail: $email_field\n Message:\n $message";
 
    if (mail($to, $subject, $body)) {
      echo "<h3>Thanks! Your email has been sent <br />We will answer your enquiry as soon as possible.</h3>";
    } else {
      echo 'Cannot sent mail';
    }
  } else {
    echo "<h3>Error! <br />Please ensure that all fields are filled out in order to email us!</h3>";
  } 
} else {
  echo "blarg!";
}
?>



I recently extended the form with HTML5 etc and got a new form script, which makes a lot of improvements with the PHP.

I want to put this on a site I am working on. The current form has an contact type pull down which changes the destination of the submitted form.  It looks like this:

Code: [Select]
<?php
if( isset($_POST) ){

//form validation vars
$formok = true;
$errors = array();

//sumbission data
$ipaddress = $_SERVER['REMOTE_ADDR'];
$date = date('d/m/Y');
$time = date('H:i:s');

//form data
$name = $_POST['name'];
$email = $_POST['email'];
$telephone = $_POST['telephone'];
$company = $_POST['company'];
$enquiry = $_POST['enquiry'];
$product = $_POST['product'];
$message = $_POST['message'];

//validate form data

//validate name is not empty
if(empty($name)){
$formok = false;
$errors[] = "You have not entered a name";
}

//validate email address is not empty
if(empty($email)){
$formok = false;
$errors[] = "You have not entered an email address";
//validate email address is valid
}elseif(!filter_var($email, FILTER_VALIDATE_EMAIL)){
$formok = false;
$errors[] = "You have not entered a valid email address";
}


//validate company is not empty
if(empty($company)){
$formok = false;
$errors[] = "You have not entered a name";
}

//validate message is not empty
if(empty($message)){
$formok = false;
$errors[] = "You have not entered a message";
}
//validate message is greater than 20 charcters
elseif(strlen($message) < 20){
$formok = false;
$errors[] = "Your message must be greater than 20 characters";
}

//send email if all is ok
if($formok){
$headers = "From: user@mysite.com" . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

$emailbody = "<p>You have recieved a new message from the enquiries form on your website.</p>
  <p><strong>Name: </strong> {$name} </p>
  <p><strong>Email Address: </strong> {$email} </p>
  <p><strong>Telephone: </strong> {$telephone} </p>
  <p><strong>Company: </strong> {$company} </p>
  <p><strong>Enquiry: </strong> {$enquiry} </p>

  <p><strong>Product of Interest: </strong> {$product} </p>

  <p><strong>Message: </strong> {$message} </p>
  <p>This message was sent from the IP Address: {$ipaddress} on {$date} at {$time}</p>";

mail("....@gmail.com","New Enquiry",$emailbody,$headers);

}

//what we need to return back to our form
$returndata = array(
'posted_form_data' => array(
'name' => $name,
'email' => $email,
'telephone' => $telephone,
'company' => $company,
'enquiry' => $enquiry,
'product' => $product,
'message' => $message
),
'form_ok' => $formok,
'errors' => $errors
);


//if this is not an ajax request
if(empty($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) !== 'xmlhttprequest'){
//set session variables
session_start();
$_SESSION['cf_returndata'] = $returndata;

//redirect back to form
header('location: ' . $_SERVER['HTTP_REFERER']);
}
}



As you can see the new php form is much better, validates each field etc...

I am having issues getting the case and switch statement into my new form though, can anyone please advise where to put it / what I need to take out to make it work? Its an important part of the form I need to make.

Any help would be much appreciated.

I think my eyes are going to fall out from all the searches ive made to find a solution for this that works on a shared host.   I tried this... but it doesnt work.

RewriteEngine  on
CheckSpelling on

The only Rough solution i got is to do the case manually with an internal redirect. Like this.

RewriteEngine on
RewriteBase /~quux/
RewriteRule ^foo\.html$ bar.html

Is there absolutely no way to mention [a-z] and [A-Z] into a RewriteRule to get this done?   I find it terribly stupid from Apache not to provide a simple solution for this.