PHP - Case Help

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 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>

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

Is there a way to change the statement below so that it ignores case sensitivity of the variable?  for instance, the statement would be true if $category == 'Admissions', 'ADMISSIONS', 'admissions', etc.   For some reason I'm having the worst time finding this via google search and know y'all will be able to help!

if ($category == 'Admissions') {
echo '&nbsp;&nbsp;<a href="#">-Forms</a><br />&nbsp;&nbsp;<a href="#">-Tuition</a><br />'; } ?>

Thanks!

My case statement is not working. What happened is that two students got a $markgrade of 61 and 67. So they both should get grade B but instead they both get Grade A. 1 student got 55 which should be grade C but gets grade A. why is it not following the switch statement?

Code: [Select]
    function outputModule($moduleID, $moduleName, $sessionData)   
     
      {       
     
      if(!count($sessionData)) { return false; } 
   
   
    $markTotal = 0;       
          $markGrade = 0;
          $weightSession = 0;
          $grade = "";
          $sessionsHTML = ''; 
         
          switch($grade){
        case ($markGrade >=70):
        $grade = 'A';
        break;
        case ($markGrade >=60 && $markGrade <=69):
        $grade = 'B';
        break;
        case ($markGrade >=50 && $markGrade <=59):
        $grade = 'C';
        break;
        case ($markGrade >=40 && $markGrade <=49):
        $grade = 'D';
        break;
        case ($markGrade >=30 && $markGrade <=39):
        $grade = 'E';
        break;
        case ($markGrade >=0 && $markGrade <=29):
        $grade = 'F';
        break;
        };     
         
          foreach($sessionData as $session)        {           
         
           $sessionsHTML .= "<p><strong>Session:</strong> {$session['SessionId']} {$session['Mark']} {$session['SessionWeight']}%</p>\n";           
           $markTotal += ($session['Mark'] / 100 * $session['SessionWeight']);
           $weightSession  += ($session['SessionWeight']); 
           $markGrade = ($markTotal /  $weightSession * 100);   
           
           }       
           
           $moduleHTML = "<p><br><strong>Module:</strong> {$moduleID} - {$moduleName} {$markTotal} {$markGrade} {$grade}</p>\n";     
   
     return $moduleHTML . $sessionsHTML;    }

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

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 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 ?

This topic has been moved to MySQL Help.

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

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";
    }
?>

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 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.      

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.

Hi all,    I'v table called vehicles with
id (int auto_increment) and
plate_number (varchar 150).   the plate_number have records like (a a a 1 1 1 1) (b b b 2 2 2 2), three chars and four numbers spliced by spaces.   I'v php search page with url like this:

http://localhost/vehicles/show.php?plate_number=f%20f%20f%205%205%205%205

search about plate_numbet = f f f 5 5 5 5

my php code:

// pdo connection.

// first sql test 
$sql = "SELECT * FROM vehicles WHERE plate_number LIKE '%".$_GET['plate_number']."%'"; 

// second sql test
// $sql = "SELECT * FROM vehicles WHERE plate_number = '".$_GET['plate_number']."'";

$db->query($sql); 
if($db->rowcount() > 0){ 
// print all results... 
}else{
echo "There are no results.";
}

The query result is: There are no results..   But, when I copy the sql statements into phpmyadmin it is works fine. (there is a result). like this:

SELECT * FROM vehicles WHERE plate_number LIKE '%f f f 5 5 5 5%';

OR 

SELECT * FROM vehicles WHERE plate_number = 'f f f 5 5 5 5';

Also i used string functions (htmlspecialchars, rawurldecode, ... ), still not work.   any suggestion to solve this issue?   Thanks to all