PHP - Make Form Field Check Case Insensitive

Hi im new to php and I need help making webpage that queries a mysql database based on a 3 check boxes and displays results on the same page or on another page. The table being queried has 4 columns, name, gps, wifi, bluetooth. So for example a row in the table would be like, samsung galaxy s2, yes, yes, yes. The idea is for it to be a website that will display phones according to their features.

So the idea is depending on if the boxes were ticked the samsung galaxy would be displayed as a result. So i need some help understanding how to make this.

Some1 gave me the code below in attempt to help me (im not sure it works or not) but im not sure how fully use it, ie what pages i need to make and how i create the connection to the mysql database, and how to use the query that they wrote to display the results

thanks

code:
Code: [Select]
<form action="?do=filter" method="post">
<table cellspacing="0" cellpadding="3" border="1">
<tr>
<td>GPS<input type="checkbox" name="gps" value="checked"></td>
<td>Wifi<input type="checkbox" name="wifi" value="checked"></td>
<td>Bluetooth<input type="checkbox" name="bluetooth" value="checked"></td>
</tr>
<tr><td><input type='submit' name='filter' value='Filter'></td></tr>
</table>
</form>
</html>
<?php
function filterMe($filter){
if(isset($_POST[$filter])){
return "Yes";
}else{
return "No";
}
}

if(isset($_POST['filter'])){
echo "Gps - " . filterMe('gps');
echo "
Wifi - " . filterMe('wifi');
echo "
Bluetooth - " . filterMe('bluetooth');
}
?>


All you need to do is use a query something like
SELECT name,gps,wifi,bluetooth FROM `product` WHERE `gps`='".filterMe('gps')."' AND `wifi`='".filterMe('wifi')."' AND `bluetooth`='".filterMe('bluetooth')."'

(Another quite newbie...)
I have already an online booking form. The Form works fine now and I would like to add on one more issue, but the code ignores what I want to check. I have 4 fields: arrival, departure, no. of persons and comments to check.

Scenario 1:

All field mentioned above are emtpty: Workes fine and message appears: "You have not provided any booking details".

Scenario 2:

If arrival (date_start) and departure (date_end) is entered, there should be at least an entry either in the field "comment", or in the field "pax". If not, there should be a message: "You have not provided sufficient booking details".

INSTEAD: The booking request is sent, which should not be the case.

The code is currently:

      # all fields empty : arrival, departure, pax and comments - error

if(empty($data_start) && empty($data_end) && empty($pax)&& empty($comment)){
    exit("You have not specified any booking details to submit to us.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}
      #If arrival  and departure date is entered, there should be at least an entry

either in the field "comment", or in the field "pax".
      
if(!isset($data_start) && !isset($data_end) && empty($pax) && empty($comment)){
    exit("You have not provided sufficient booking details.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}

The form can be tested at http://www.phuket-beachvillas.com/contact-own/contact-it.php

Can someone please check and tell me what's wrong with the code ? Thanks to anyone for any hint.

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 I have a form that is popluated from the database now I am trying to get the switch case to be based on the option the user selects is this possible to make a case a variable popluated by the drop down if so can someone show me what am i missing?
the value I am trying to get from the form to the switch case is the ( $val->slug) but the value not been set help please

here the form
Code: [Select]
                                       <form method="post">
                                           <select name="deal-locations" onChange="this.form.submit()">
                                             <?php
                                              while(list($key,$val) = each($locations)) {
                                             ?><option value="<?php echo $val->slug; ?>"><?php echo $val->slug; ?></option><?php
                                                 }
                                              ?>
                                           </select>
                                           <input type="submit" value="submit">
                                       </form>
Here the switch case
Code: [Select]
switch ($_POST['deal-locations'])
   {
       case " $val->slug": echo "<h3>deal-locations: ASC</h3>";
           $args = array(
                 's' => $_GET['s'],
                 'post_type' => 'deals',
                 'deal-locations' => ' $val->slug',
                 'where' => ' $val->slug',
                 'paged' => 'paged'
                );
           break;
}

I have a code which I made just up
  Code: [Select]
<?php if ($product->title == '01'); print "Earring"; ?>
<?php if ($product->title == '02'); print "Necklace"; ?>
<?php if ($product->title == '03'); print "Necklace"; ?>
<?php if ($product->title == '04'); print "Ring"; ?>I just want to check the product titles first 2 characters and print according to that.
Example: If $product->title is "01DSE32" print Earring. This checking must be strgn  or something like that which I don't remember. I would appreciate some feedback.

Ok so i have registration page on my webs but i didn't work on empty fields so how could i check all fields?
Code: [Select]
//if no name
if(!$name){
$error = "Username missing.";
}
//if no pass
if($pass == false){
$error = "$error,Password missing";
}
//if no pass conf
if($pass_conf == false) {
$error = "$error,Pass conf missing.";
}
//if no email
if($email == false){
$error = "$error,Email missing.";
}
//pass conf
if($pass != $pass_conf){
$error = "$error,Passwords do not match.";
    }
    echo "<script>alert('$error');</script>;";
//header("Location: register.php");
 My script gives same results every time (even if i fill any of fields)...also if i un-comment header command it wont show alert..it just reloads the page

So can anyone help me with this?
Thanks..

I have this script running:


<?php
$query = mysql_query("SELECT * FROM jobs WHERE event = 'Yes' ORDER BY title");
while ($row = mysql_fetch_array($query)) {
?>


How do I check if a field is empty and NOT display it...?

For instance it has a 'applied' field, if that is empty I dont want it to display, however I still  need the event = 'Yes' part.

Hi there once again, sry for previous wrong section, i guess this time i'm on the right place ;p

Well i need following:

I have few forms (input fields) with requested informations, also i have other .php file which i'm calling to send a form. Now i need to know how can i do a check for those fields if they are empty or not. If they are, i need to STOP submiting the form (calling the other .php).

Codes:

Form:
Code: [Select]
<form name="f1" form method="post" action="posalji.php"/>Field:
Code: [Select]
<input type="text" name="hp1" size="20"/>Submit:
Code: [Select]
<input name="f1" type="image" src="registruj.png" onclick="if(f1.hp1.value.length==0) alert('Error: field can't be empty'); else f1.submit(); if(f1.hp2.value.length==0) alert('Error: field can't be empty'); else f1.submit();"/>There are more than one field, that's why you can see more errors in submit. Well all i need is "die" or "stop" calling the "posalji.php" from action above.

Sry 4 poor english.

so I have this code:
Code: [Select]
<input type='checkbox' name='title8' value='$title8' /></td><td><strong>$title8</strong> <br /> $date8 <br />$ $price8<input type='hidden' name='price8' value='$price8'> how do I make is so that the hidden field is only going to submit if the checkbox is checked........

Pehaps this is kidstuff but i'm a kid at heart.

I have only 1 form field on a form
User enters a special code in the form.
Once submitted the form is queried against a mysql database to see if the code exists.
If code does not exist it must be reentered.
If code exists then redirected.

basically its like "get to the next page if you have the code"

thanks

Hello everybody, i try to check if the unique field inventar exists or not before i insert new record. if the inventar exits the user should get error message. but i dont know how to do this.   thank you very much for your help. Rafal   here is my code

<?php
include("123.php");
$inventar = $link1->real_escape_string($_POST["inp_inventar"]);
$product = $link1->real_escape_string($_POST["inp_product"]);
$price = $link1->real_escape_string($_POST["inp_price"]);

$link1 = new mysqli("$hoster", "$nameuser", "$password", "$basedata") or die ("Connection Error!"); error_reporting (0);
$check_inventar = mysqli_query($link1, "SELECT inventar FROM products WHERE inventar='$inventar'");
$check_inventar_num = mysqli_num_rows($check_inventar);
if (isset($_POST['inp_submit']) AND $check_inventar_num = 0)
{
$query1 = "INSERT INTO products
(inventar, product, price)
VALUES ('$inventar', '$product', '$price')";
$result1 = $link1->query($query1) or die("Database Error!");
if ($result1 == true)
{
header ( 'Location:insert.php' );
}
}
else { echo "there is already product with same inventar id!"; }
mysqli_close($link1);
?>

Hello there,

My current song request form process looks like:

<?php
                if(isset($_POST['submit'])) {
                $to = 'address@website.com' ;  
$name = trim($_POST['name']);
                $message = trim($_POST['message']);
                $artist = trim($_POST['artist']);
                $song = trim($_POST['song']);
$subject="Name:$name - Message:$message - Artist:$artist - Song:$song";
                $headers  = 'MIME-Version: 1.0' . "\r\n";
                $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
                $message = "<table>
                <tr><td>Name</td><td>".$_POST['name']."</td></tr>
                <tr><td>Message</td><td>".$_POST['message']."</td></tr>
                <tr><td>Artist</td><td>".$_POST['artist']."</td></tr>
                <tr><td>Song</td><td>".$_POST['song']."</td></tr>
                </tr></table>" ;
                mail($to, $subject, $message, $headers);
                header('Location: song-requests-success.php');
               }
?>

I'm currently using Javascript for blank validation, however, people seem to be getting through it somehow.

I'm looking to implement PHP checkers that will output back to the request form with something like: Name field blank.

Would this method work?

$name = trim($_POST['name']);
$artist = trim($_POST['artist']);
$song = trim($_POST['song']);
if(empty($name)){
$name1 .= "<br>Name is empty.";
}
if(empty($artist)){
$artist1 .= "<br>Artist is empty.";
}
if(empty($song)){
$song1 .= "<br>Song is empty.";
}

On form:

<?php if(!empty($name)){ echo "".($name1).""; } ?>
<?php if(!empty($artist)){ echo "".($artist1).""; } ?>
<?php if(!empty($song)){ echo "".($song1).""; } ?>

Would recalling the trim's be nessessary as they have already been specified for the email title. Would this need to be implemented into 'isset'.

Many thanks.

I am building a system where people are able to choose a food menu, they can modify each dish if needed and then say how many of each item they need for the order.

So when they pick the breakfast menu, it selects all starters, mains and desserts.  Should something need to be edited (sausages changed to vegitarian sausages) the user should be able to overtype what has been populated from the select statement)

When the form is submitted, the order needs to be linked to the current job which is in a field ssm_job.job_id but the changes to the menu items need to be stored somewhere for the current order only.  This obviously needs to be accessile later so further changes can be made if needed.  I am not sure of the best way to go about this as i am trying not to save every item in another database (just trying to be tidy)

Any advise on this would be greatly appreciated.

I have had help on this project in relation to an sql and the background can be found below, the help has been amazing but as this is a very different question i thought i would start a new thread.

 

Kind Regards

Now this one is a bit of a shit head. I am using a really comprehensive class i found on on the web for upload / re-size / crop but i want to be able to override it's error handling and i am not good enough to start modifying the code in the class with out fucking it up.

Firstly i will show you how i have invoked the class.
Code: [Select]
if( isset($_FILES['image'] ) ) {

//Class includes
include("../scrips/php/cms/database.insert.class.php");
include ("../scrips/php/cms/img.upload.resize.crop.class.php.php");


//----------|Start: upload, resize & save
$your_image = new _image;

//----------| Upload orginal image
$your_image->uploadTo = 'uploads/';
$upload = $your_image->upload($_FILES['image']);


//----------| Resize and upload small thumbnail
$your_image->newPath = 'thums/';
$your_image->newWidth = 50;
$your_image->newHeight = 50;
$resized = $your_image->resize();



//----------| Resize and upload medium thumbnail
$your_image->newPath = 'thums2/';
$your_image->newWidth = 100;
$your_image->newHeight = 100;
$resized = $your_image->resize();
//----------| Getting the image name to insert into the database futher on in the code
$name = $resized;
$img_str = explode("/",$name);
$final_img_name = $img_str['1'];

echo "Article has been added!";

//----------------|end

//----------------| Start database insert (class manipulation)
$table = "blog_posts";
$title = "'".$_POST['ArticleTitle']."',";
$img = "'".$final_img_name."',";
$post = "'".$_POST['ArticleBody']."',";
$aurthor_id = "'1',";
$category_id = "'".$_POST['Category']."',";
$date_posted = "NOW()";


$values = array("$title","$img","$post","$aurthor_id","$category_id","$date_posted");
$fields = array('title,','img,','post,','aurthor_id,','category_id,','date_posted');
$obj= new DatabaseInsert;
$obj->DatabaseConnectionRequire();
$obj->ArticleInsert($values,$fields,$table);
//----------------|end
}


As you can see it's fairly basic. What i want to do is before it runs this script and starts including/invoking the class etc, i want to be able to check to see if there is a value been posted from a FILE FORM OBJECT and if there is to proceed with this script, alternatively i want it to execute another code which will handle it in regards to the concept of my page. A simple javascript alert with be ok providing it reloaded the page to it's default state. If any one can help me here i would appreciate it a lot. Thanks