PHP - Php Form , Do Not Post Blank Fields

Hi.  I've been doing tutorials all day on checking for blank fields and I have wrote a function to do so.  For now I am only checking one field to see if it works.  If I miss that field out (first name)  It works great and displays the correct error message.  Problem I have is if I fill in the whole form and send it I get an Inturnal server error.  I will post my code to show you.  can anyone see whats going wrong?  I have \\     some of the code for now because I my keep it if I cant do this error check.


session_start();  
$validation_id = strval(time());





if(isset($_POST['submit'])) {




$first_name = check_input($_POST['first_name'],"Please enter a first name");
 $last_name = check_input($_POST['last_name']);
   $DOB = check_input($_POST['DOB']);
    $sex = check_input($_POST['sex']);
 $email = check_input($_POST['email']);
  $username = check_input($_POST['username']);
   $password = check_input($_POST['password']); 
   $agree = check_input($_POST['agreed']);
    $creation_date = check_input($_POST['creation_date']);
$user_type = check_input($_POST['member_type']);
 $access_level = check_input($_POST['access_level']);
  $validation = check_input($_POST['validation_id']);
     $club_user =check_input($_POST['user_type']);


//    $first_name = mysql_real_escape_string($_POST['first_name']);
//  $last_name = mysql_real_escape_string($_POST['last_name']);
//   $DOB = mysql_real_escape_string($_POST['DOB']);
 //   $sex = mysql_real_escape_string($_POST['sex']);
//  $email = mysql_real_escape_string($_POST['email']);
//   $username = mysql_real_escape_string($_POST['username']);
//    $password = mysql_real_escape_string($_POST['password']); 
//    $agree = mysql_real_escape_string($_POST['agreed']);
//     $creation_date = mysql_real_escape_string($_POST['creation_date']);
// $user_type = mysql_real_escape_string($_POST['member_type']);
//  $access_level = mysql_real_escape_string($_POST['access_level']);
//   $validation = mysql_real_escape_string($_POST['validation_id']);
//      $club_user = mysql_real_escape_string($_POST['user_type']);
  
$insert_member= "INSERT INTO Members (`first_name`,`last_name`,`DOB`,`sex`,`email`,`username`,`password`,`agree`,`creation_date`,`usertype`,`access_level`,`validationID`) 
VALUES 
('".$first_name."','".$last_name."','".$DOB."','".$sex."','".$email."','".$username."','".$password."','".$agree."','".$creation_date."','".$user_type."','".$access_level."', '".$validation."')";

$insert_member_now= mysql_query($insert_member) or die(mysql_error());

$url = "thankyou.php?name=".$_POST['username'];
header('Location: '.$url);


and the form
<form method="POST" name="member_accounts" id="member_accounts">
<input name="first_name" type="text" class="form_fields" value="<?php echo $_POST['first_name'];?>" size="20" />
<input name="last_name" type="text" class="form_fields" value="<?php echo $_POST['last_name'];?>" size="20" />
<input name="submit" type="submit" class="join_submit" id="submit_member" value="Create Account" />


 <?  function check_input($data, $problem='')
{
$data= trim($data);
$data= stripslashes($data);
$data= htmlspecialchars($data);
if ($problem && strlen($data) ==0)
{
die($problem);
}
return $data;

}   ?>

Hello,

I'm using the below code to determine whether fields have been left blank, however, it only a standard sentence, i'd like to customise it, like: "Email has been left blank" or The email and message has been left blank. My best preference would be to bullet point each line. IE:

Email has been left blank. Message has been left blank.

$name = $_POST['name'];
$visitor_email = $_POST['email'];
        $user_message = $_POST['message'];
if(empty($name)|| empty($visitor_email)|| empty($user_message))
{
$errors .= "\n Some of the above fields have not been filled in.<br><br> ";
}


Many thanks.

Hi all,

I am trying to write a script that finds the blank $_POST values and add them to a $blank_array.

All I get is a blank page - any ideas?

Also is there some code I can put at the top of every php page to show exactly what the errors are? - I have tried a few scripts but have not found one to work universally.


include("cxn.php");

$reg = "G-".strtoupper($_POST['reg']);
$sql = "SELECT * FROM sales WHERE reg='$reg'";
$result = mysqli_query($cxn,$sql)
or die ("Couldn't execute query");

$num = mysqli_num_rows($result);
if ($num >0) // Listing Already Found 
{
echo "The aircraft '$reg' is already listed!";
echo $_SESSION['logname'];
}

foreach ($_POST as $value)
{
if ($value == "")
{
$blank_array[] = $field;
}
if (@sizeof($blank_array) > 0) // blank fields are found 
{
$error = "Please fill in all the form.<br>";
include ("../sell-your-reg.php");
}
}
?>

HI,

I have a user form on a modal.

The user can be updated from this modal but on the second tab is where the users password can be updated.

The update button commits all changes including the password update.

If the New Password field is blank i do not want it to be updated.

I am using a prepared statement and am not sure how to ommit a field if it is blank.

In actual fact there is a new password and a confirm password field which must be the same before the password field is updated.

if ($_SERVER['REQUEST_METHOD']=='POST'){
	$uid = $_POST['UM-uid'];
	$fname = $_POST['UM-firstName'];
	$lname = $_POST['UM-lastName'];
	$email = $_POST['UM-emailAddress'];
	$accountlevel = $_POST['UM-accountLevelId'];
	$mobile = $_POST['UM-mobileNumber'];
	$roleid = $_POST['UM-roleId'];
	$newpass = password_hash($_POST['UM-pass'], PASSWORD_DEFAULT);


	if(!empty($_POST['UM-firstName'])){
		// prepare stmt
		$stmt = $conn->prepare("
			UPDATE ssm_user 
			SET 
			user_password=?,
			user_email=?,
			user_firstname=?,
			user_lastname=?,
			user_account_level_id=?,
			user_mobile=?,
			user_role_id=?
			WHERE user_id = ?
			");

		$stmt->bind_param('sssssssi', $newpass, $email, $fname, $lname, $accountlevel, $mobile, $roleid, $uid);
    	$stmt->execute();
    	$_SESSION['user']=$fname." ".$lname;
    	$_SESSION['updateUser']="has been successfully updated";
    	$_SESSION['actionstatus']="success";

I am sure i will be able to work out the password confirmation part, its just the omitting password from being part of the update if blank.

I've managed to isolate a problem I'm having with my php script. It would seem the script randomly restarts itself with blank post data while it's running.

I've managed to mimick the problem using a very basic php script which just pauses and writes to a log:

<?php

$q = $_POST['q'];

if ($q==""){
  writelog ("MISFIRE!!!");
  die;
}

writelog("\n*** Error check started ***");

for ($i = 1; $i <= 50; $i++) {
   writelog ($i);
     sleep(rand(2,20));
}

 function writelog($towrite)
{
  $tdate=date('d/m/Y H:i:s');
  $file = 'log/testlog.txt';
  $current = $towrite." --- ".$tdate."\n";
  file_put_contents($file, $current, FILE_APPEND);
}

writelog("*** Error check ended ***");
?>

To rule out any problems with my AJAX htmlhttp requests, I simply send the script some irrelevant post data using Chrome's Advanced Restful client.

This is the ouput of the log from an example test run:

*** Error check started *** --- 05/06/2014 18:27:30

1 --- 05/06/2014 18:27:30
2 --- 05/06/2014 18:27:44
3 --- 05/06/2014 18:27:49
4 --- 05/06/2014 18:27:59
5 --- 05/06/2014 18:28:04
6 --- 05/06/2014 18:28:22
7 --- 05/06/2014 18:28:33
8 --- 05/06/2014 18:28:39
9 --- 05/06/2014 18:28:52
10 --- 05/06/2014 18:29:08
11 --- 05/06/2014 18:29:22
12 --- 05/06/2014 18:29:30
13 --- 05/06/2014 18:29:43
MISFIRE!!! --- 05/06/2014 18:29:46
14 --- 05/06/2014 18:29:56
15 --- 05/06/2014 18:30:07
16 --- 05/06/2014 18:30:09
17 --- 05/06/2014 18:30:15
18 --- 05/06/2014 18:30:32
19 --- 05/06/2014 18:30:52
20 --- 05/06/2014 18:30:54

Note the logged "Misfire" after the 13th entry.  This shows the script tried to run again with blank post data, the same problem I'm having in my more complex script.

Why could this be happening? It's not anyone else calling the script, nobody knows about the site and I've ruled it out by logging the IP in my real script.
Edited by holdorfold, 05 June 2014 - 02:29 PM.

Hey guys I have a form, but on the form you are able to add extra fields. My question is how would I POST those extra fields? The way I always do it is $_POST['field_name'], however how would I know if theyve added new fields. Here is an image of what the field looks like so you get a better idea of what im talking about.

Hi

I have a form that is to input data from input fields to a table.
The form is as follows:

                            $query = $DB->query("SELECT country_code, country_id, IF(country_code = '".$country_code."', '', '') AS sel FROM exp_sme_countries WHERE site_id='".$this->settings['site_id']."' ORDER BY country_name ASC");
                            foreach ($query->result as $row)
                            {
                               $options .= '<label>' . 'Phrase for ' . $this->settings['countries'][$row['country_code']] . '</label>' . '<br />';
                               $options .= '<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="country_id[]"  />' . '<br /><br />';
                               $options .= '<input type="hidden"  name="country_data[' . $row['country_id'] . ']" value="'.$row['country_id'].'"  />';
                            }


This outputs:
Code: [Select]
<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="country_id[]"  />
<input type="hidden"  name="country_data[68]" value="68"  />

<input style="width: 100%; height: 5%;" id="country_data" type="text"  name="country_id[]"  />
<input type="hidden"  name="country_data[28]" value="28"  />

What I need to do, is get the values from the input fields and then match them with the correct hidden field value

So if in the first input field, I typed in 'Test data' and the second input, i typed 'This is great'

On the POST, I need to find the the value ('Test data') and also the value from the hidden field.

So something like:
Quote

The text you entered is: Test data with hidden value of 68
The text you entered is: This is great with hidden value of 28


I'd rather not use $_GET as this is a form that inserts data into a database.

Could someone point my in the right direction or provide an example?

...added to an error log? Currently, my coding is as follows:

Form to gather data:
Code: [Select]
<html><head><title>Car Accident Report Form</title></head>
<form action="errorlog.php" method="post">
First Name: <br><input type="text" name="name"><br>
Surname:<br> <input type="text" name="surname"><br>
Age: <br><input type="text" name="age"><br>
Weeks Since Accident: <br><input type="text" name="weeks"><br>
<input type="submit" value="Submit">
</form>

Coding for error log:
Code: [Select]
<html><head><title>Validating Car Accident Report Form Details</title></head>
<?php
$name=$_POST["name"];
$surname=$_POST["surname"];
$age=$_POST["age"];
$weeks=$_POST["weeks"];
$subtime = strftime('%c');
$pass = "The details uploaded are fine<br><br>";
if ((((trim($name)="" && trim($surname)="" && trim($age)="" && trim($weeks)=""))))
{
echo "It seems that you have not entered a value for the Name, Surname, Age or Weeks fields. This has been added to the error log.<br><br>";
error_log("<b><u>Error</b></u><br>The user has not entered any values", 3, "C:/xampp/htdocs/errorlog.txt");
}
if (($age<18)&& ($weeks<=1))
{
echo "It seems that you have entered an invalid age and number of weeks since the accident. This has been added to the error log.<br><br>";
error_log("<b><u>Error</b></u><br>The user has entered an age that is below 18 and the number of weeks since the accident is equal to or under 1 week!<br>Age entered:" . $age . "<br>Number Of Weeks Since Accident entered:" . $weeks . "<br>Time that form was submitted:" . $subtime . "<br><br>", 3, "C:/xampp/htdocs/errorlog.txt");
} 
else if ($age<18)
{
echo "It seems that you have entered an invalid age. This has been added to the error log.<br><br>";
error_log("<b><u>Age Error</b></u><br>The user has entered an age that is below 18!<br>Age entered:" . $age . "<br>Time that form was submitted:" . $subtime . "<br><br>", 3, "C:/xampp/htdocs/errorlog.txt");
}
else if ($weeks<=1)
{
echo "It seems that you have entered an invalid age number of weeks since the accident. This has been added to the error log.<br><br>";
error_log("<b><u>Week Error</b></u><br>The user has entered a number of weeks since the accident that is equal to or under 1 week!<br>Number Of Weeks Since Accident entered:" . $weeks . "<br> Time that form was submitted:" . $subtime . "<br><br>", 3, "C:/xampp/htdocs/errorlog.txt");
}
else
{
echo $pass;
}
echo "Car Accident Report Form details have been sent<br>";
echo "<a href='readlog.php'>Read Error Log</a>"
?>

</html>

How can I get it so that if a user presses the space bar in a field, then the trim function sees that there's no white space and then this gets added to the error log?

Any help is appreciated!

Hey Guys. I am working with a form that shows the grand total on the checkout page. The value of the grand total is inside a hidden field. When click on  submit, the _POST array doesn't get back the last value of the grand total. I need to hit the button twice to get the last value. The weird thing is when I  echo the value of the grand total it display the latest value, but not with the POST array   For example. If the grand total is $10.00 and I click on submit. It will show the POST['grand_total'] as empty. If I click on submit again it will show the grand total of $10.00. Below is my code that I am working with. Any help would be really appreciated.

if(isset($_POST['submit'])) {
/* Doesn't show if i put it after if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}

}

//A bunch of other html/php code. Another class calculates the subtotal assigns it the variable $subtotal



$cart_totals = new cartTotals($subtotal, $discounted_amount,$post_values->tip); // Cart class is shown below

/* Doesn't show if i put it before if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}
echo  "<input name='grand_total' type='hidden' value='$cart_totals->grand_total'  />"; // Shows the grand total after second from submission
echo "$cart_totals->grand_total"; // Shows grand total after the first submission

Cart Totals Class

class cartTotals  {

	public $subtotal;
	public $sales_tax;
        public $tip;
	public $grand_total;
        public $discount_amount;
	public $href_page;
	public $invalidCouponMessage;
	const  TEST_ENVIORMENT = FALSE;


	/**
	 * [ Function gets constructed in the order summary where the [$discount_amount= ""]  arg does need to be passed.
     * But does get passed in when called on the checkout.php page. Therefore we set the default value to an empty string.]
	 * @param [float] $subtotal   [subtotal get passed in from the parent class coreCartFunction]
	 * @param string $discount_amount [The class checkCouponCode calculates this discount amount based on the
     * subtotal and the discount amount. It gets instantiated on the clients side and passed is this construction function.
     * This is all done on the checkout page.]
	 */

    /*The way the construct function works is by invoking all the methods the passed arguments
    When the methods get invoked the do all the work and set the properties its values. The properties then get echoed out
    on the client side.  */
	
    function __construct($subtotal="", $discount_amount= "", $tip=""){
    
    $this->subTotal($subtotal, $discount_amount);//SubTotal method takes the discount amount and subtracts it from the subtotal.
    $this->salesTax($subtotal, $discount_amount);
    $this->tip = $tip;
    $this->grandTotal();
	}

    private function subTotal($subtotal,$discount_amount) {

            $rounded_subtotal = round($subtotal-$discount_amount,2);
            $money_format_subtotal =  money_format('%i',$rounded_subtotal);
            $this->subtotal = $money_format_subtotal;
    }


    private function salesTax($subtotal, $discount_amount =""){
	$sales_tax = (STORE_SALES_TAX)?(float)STORE_SALES_TAX:8.875;
	$sales_tax =(($this->subtotal)*$sales_tax)/100;
	$sales_tax = round($sales_tax,2);
	$this->sales_tax = $sales_tax;
	}


	public function Tip() {
    //global $post_values;
    //$last_tip_selected = $post_values->tip > 0 ? $post_values->tip : "" ;
	$tip_output = "<select id='tip' name='tip'>";
 	for($tip=0.00; $tip<=11.75; $tip+=0.25){
 	if( $tip == "2") {$selected = " selected";} else {$selected ="";}
       $formatted_tip =  money_format('%i',$tip);

	$tip_output .= "<option {$selected} id='selected_tip' value='$formatted_tip'>"."$".$formatted_tip ."</option>".PHP_EOL;
		}

		$tip_output .= "</select>";
		return $tip_output;

    }

    private function grandTotal(){
        $grand_total = round($this->sales_tax+$this->subtotal+$this->tip,2);
        $grand_total_formatted =  money_format('%i',$grand_total);
        $this->grand_total = $grand_total_formatted;

    }

Login.php

Code: [Select]
<?php
    session_start();
    mysql_connect("localhost","root") or die(mysql_error());
    mysql_select_db("cute") or die(mysql_error());
    $username = $_POST['username'];
    $password = $_POST['pass'];
    if (isset($_POST["submit"]))
    {
     $log = "SELECT * FROM regis WHERE username = '$username'";
     $login = mysql_query($log);  
     $row = mysql_fetch_array($login);
     $number = mysql_num_rows($login);
     if ($number == 0)
     {
      print "That user does not exist in our database. <a href=registration.php><input type='button' value='Register'></a>";
     }
      if ($number > 0)
     {

        if ($password == $row['password'])
       {
        $_SESSION['username'] = $row['username'];
        $_SESSION['userlevel'] = $row['userlevel'];
        $_SESSION['is_logged_in'] == 1;
         
        if($_SESSION['userlevel']==1)
       {
        $_SESSION['is_logged_in'] == 1;
        echo "<meta http-equiv='refresh' content='0; url=form2.php'>" ;

       }
        else if($_SESSION['userlevel']==0)
       {
        echo "<meta http-equiv='refresh' content='0; url=registration.php'>";
       }
     }
     }
    }

    else
    {


?>
<html>
<head>
<script type="text/javascript">
 function a()
{
   var x = document.login.username.value;
   var y = document.login.pass.value;

   if(x==""&& y=="")
   {
    alert("Please insert all message!");
    return false;
   }
   if(x=="")
   {
     alert("Please insert an username!");
     return false;
   }
   if(y=="")
   {
     alert("Please insert an password!");
     return false;
   }
}
</script>
</head>



 <body>
 <table border="0">
 <form name="login" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" onsubmit="return a()">
 <tr><td colspan=2><h1>Login</h1></td></tr>
 <tr><td>Username:</td>
 <td><input type="text" name="username" maxlength="40"></td></tr>
 <tr><td>Password:</td>
 <td><input type="password" name="pass" maxlength="50"></td></tr>
 <tr><td><input type="submit" name="submit" value="Register"></a></td>
 <td><input type="submit" name="submit" value="Login"></td></tr>
 </form>
 </body>
 <?php

  }

 

 ?> </html>

after im redo my code and after im login there nothign happen but only blank page im wondering why

Ok I dont understand why my php form keeps sending me blank emails. Because I have a checker with java script. Did I do something wrong in my coding with the php forms or is it just the javascript on the sites problem?

Here is the php form code:
Code: [Select]

<script language="JavaScript">
function checkForm()
{

var cname, caddress, cphone, cemail, ccontact;
with(window.document.msgform)
{
cname    = name;
caddress = address;
cphone = phone;
cemail    = email;
ccontact   = contact;

}


   if(trim(cname.value) == '')
   {
      alert('Please enter your name');
      cname.focus();
      return false;
   }
   else if(trim(caddress.value) == '')
   {
      alert('Please enter your address');
      cemail.focus();
      return false;
   }
   else if(trim(cphone.value) == '')
   {
      alert('Please enter your phone number');
      cemail.focus();
      return false;
   }
   else if(!isEmail(trim(cemail.value)))
   {
      alert('Email address is not valid');
      cemail.focus();
      return false;
   }
   else if(trim(ccontact.value) == '')
   {
      alert('Please enter your contact person');
      cemail.focus();
      return false;
   }
   
   
else
{
cname.value    = trim(cname.value);
caddress.value = trim(caddress.value);
cphone.value = trim(cphone.value);
cemail.value   = trim(cemail.value);
ccontact.value   = trim(ccontact.value);
return true;
}


}


/*
Strip whitespace from the beginning and end of a string
Input : a string
*/
function trim(str)
{
return str.replace(/^\s+|\s+$/g,'');
}

/*
Check if a string is in valid email format.
Returns true if valid, false otherwise.
*/
function isEmail(str)
{
var regex = /^[-_.a-z0-9]+@(([-a-z0-9]+\.)+(ad|ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm|zw)|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5]))$/i;
    //regex = /^[-_.abcdefghijklmnopqrstuvwxyz0123456789]+@(([-abcdefghijklmnopqrstuvwxyz0123456789]+\.)+(ad|ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm|zw)|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5]))$/i;
return regex.test(str);
}
</script>

<form name="msgform" action="thankyou.php" method="post" >
<table width="95%" border="0" cellspacing="1" class="tablestyle" cellpadding="1" align="center">

<tr><td>Name:</td>
<td><input type="text" name="name" size="27">
</td>
</tr>

<tr><td>Address:</td>
<td><input type="text" name="address" size="27">
</td>
</tr>

<tr>
<td>Phone: </td>
<td>
<input type="text" name="phone" size="27">
</td>
</tr>

<tr>
<td>Email: </td>
<td>
<input type="text" name="email" size="27">
</td>
</tr>

<tr>
<td>Contact Person: </td>
<td>
<input type="text" name="contact" size="27">
</td>
</tr>

<tr>
<td valign=top>I would like to participate at the: </td>
<td valign=top>
 
<input type="radio" name="level" value="5000">Platinum<BR>
<input type="radio" name="level" value="2500">Gold<BR>
<input type="radio" name="level" value="1000">Silver<br>
<input type="radio" name="level" value="500">Bronze <br><br>

</td>
</tr>

<tr>
<td>

<input type="radio" name="level" value="1250"option5<br>

</td>
</tr>



<tr><td colspan="2"><input type="submit" value="submit" name="submit" onClick="return checkForm();"><input type="reset" value="Reset"></td></tr>
</table></form>


Here is the php process code:
Code: [Select]

<?php
$con = mysql_connect(""); //Replace with your actual MySQL DB Username and Password
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("sponsorship", $con); //Replace with your MySQL DB Name
$name=mysql_real_escape_string($_POST['name']); //This value has to be the same as in the HTML form file
$address=mysql_real_escape_string($_POST['address']); //This value has to be the same as in the HTML form file
$phone=mysql_real_escape_string($_POST['phone']); //This value has to be the same as in the HTML form file
$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file
$contact=mysql_real_escape_string($_POST['contact']); //This value has to be the same as in the HTML form file
$level=mysql_real_escape_string($_POST['level']); //This value has to be the same as in the HTML form file
$sql="INSERT INTO sponsorship (name,address,phone,email,contact,level) VALUES ('$name','$address','$phone','$email','$contact','$level')"; /*form_data is the name of the MySQL table where the form data will be saved.
name and email are the respective table fields*/
if (!mysql_query($sql,$con)) {
 die('Error: ' . mysql_error());
}
?>




<?php

$name = $_POST["name"];
$address = $_POST["address"];
$phone = $_POST["phone"];
$email = $_POST["email"];
$contact = $_POST["contact"];
$level = $_POST["level"];




echo "Name: ". $name . " <br />";
echo "Address: ". $address . " <br />";
echo "Phone: ". $phone . " <br />";
echo "Email: ". $email . " <br />";
echo "Contact: ". $contact . " <br />";
echo "Level: ". $level . " and up. <br />";

$recipient = "my email";
$subject   = " subject ";
$message   = " 


'. name: .'$name

'. contact: .' $contact

'. address: .' $address 

'. phone: .' $phone 

'. email: .' $email

'. level: .' $level


";

mail($recipient, $subject, $message);

?>


i keep thinking its the javascript fault but i have a navigation menu which is made from javascript and it works fine. So it leaves me to think its something i did wrong with the form or php?

Can someone help me please? Thank you!

Hi People.

Does anyone have any idea why this form is showing as a blank page on my site?  Can you see what I've missed?

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Stranded Flyer</title>
</head>

<body>

<?php

$host = 'localhost';
$usr = "the_user";
$password = 'thepassword';
$db_name = 'thedbname';

//connect to database
mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error());
mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error());

$surname = mysql_real_escape_string($_POST['surname']);
$firstname = mysql_real_escape_string($_POST['firstname']);
$phone1 = mysql_real_escape_string($_POST['phone1']);
$phone2 = mysql_real_escape_string($_POST['phone2']);
$location = mysql_real_escape_string($_POST['location']);
$qualifications = mysql_real_escape_string($_POST['qualifications']); 
$expertise = mysql_real_escape_string($_POST['expertise']);
$assistance = mysql_real_escape_string($_POST['assistance']);
$languages = mysql_real_escape_string($_POST['languages']);
$e-mail = mysql_real_escape_string($_POST['e-mail']);
$consent = mysql_real_escape_string($_POST['consent']);
$published = mysql_real_escape_string($_POST['published']);
$comments = mysql_real_escape_string($_POST['comments']); 
$other_info = mysql_real_escape_string($_POST['other_info']);



$errorstring = ""; // default value of errorstring

function makeSafe($value)
{
    if (get_magic_quotes_gpc())
    {
        $value = stripslashes($value); 
    }
    
    $value = mysql_real_escape_string($value);
    
    return $value;
}

if(isset($_POST['submit'])) {
// Validate all the code inputs

// Captcha Validation

require_once('recaptchalib.php');
$privatekey = "6Ld2xscSAAAAADwh3mCFkTObSHLAEKUAcU3ocpSv";
$resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

 if (!$resp->is_valid) {
    // What happens when the CAPTCHA was entered incorrectly
    $errorstring = $errorstring. "Invalid CAPTCHA, please try again";
  } else {

if ($surname =="")
$errorstring = $errorstring. "Surname<br>";
if ($phone1 =="")
$errorstring = $errorstring. "phone1<br>";
if ($phone2 =="")
$errorstring = $errorstring. "phone2<br>";
if ($location =="")
$errorstring = $errorstring. "location<br>";
if ($qualifications =="")
$errorstring = $errorstring. "qualifications<br>";
if ($assistance =="")
$errorstring = $errorstring. "assistance<br>";
if ($languages =="")
$errorstring = $errorstring. "languages<br>";
if ($e-mail =="")
$errorstring = $errorstring. "e-mail<br>";
if ($consent =="")
$errorstring = $errorstring. "consent<br>";
if ($published =="")
$errorstring = $errorstring. "published<br>";
if ($comments =="")
$errorstring = $errorstring. "comments<br>";
if ($other_info =="")
$errorstring = $errorstring. "other info<br>";

// does the errorstring = "nothing"?

}
// Figure out which error message to show i.e. field validation or CAPTCHA
if ($errorstring !="")
   if (strstr($errorstring,"CAPTCHA")) echo $errorstring;
  else echo "You have not put anything in the following fields: <br><br> $errorstring";
//echo "If you have nothing to put in the box please type the word \"None\" or \"N\/A\"";
//die ("Please try again, ensuring that you fill out all the fields!");
else 
{


//echo "Your data has been saved";


$insert_query = "INSERT INTO HelperFormData (surname, firstname,phone1, phone2, location, qualifications, expertise, assistance, languages, e-mail, consent, published, comments, other_info,) VALUES ('$surname', '$firstname', '$phone1','$phone2', '$location', '$qualifications', '$expertise', '$assistance', '$languages', '$e-mail', '$consent', '$published', '$comments', '$other_info')";
$insert_action = mysql_query($insert_query) or die ('Error During Insert :<br>'.mysql_error().'<br><br>Error occured running the following code :<br>'.$insert_query);

$id = mysql_insert_id();

echo "Thank you, Your details have been submitted.";
//include "resultcard.php";

// Output what the form looks like

// End of how the form looks 

}
}

if(!isset($_POST['submit']) || (isset($_POST['submit']) && !empty($errorstring)))
{
?>

<form name = "form1" method ="post" action="">
<table width="700" border="0" cellspacing="5" cellpadding="5" bgcolor = "#dddddd">
  <caption>
    Submit Your  Details
  </caption>
  <tr>
    <td width = "50">&nbsp;</td>
    <td width = "240">&nbsp;</td>
    <td width = "250">&nbsp;</td>
    <td width = "160"><b>Example Input</b></td>
  </tr>
 
  <tr>
    <td>&nbsp;</td>
    <td>Surname</td>
    <td><input type='text' name='surname' size = '40' maxlength='30' value = '<?php echo $surname; ?>'></td>
    <td>Smith</td>
  </tr>
 
  <tr>
    <td>&nbsp;</td>
    <td>First Name</td>
    <td><input type='text' name='firstname' size = '40' maxlength='30' value = '<?php echo $firstname; ?>'></td>
    <td>Bill</td>
  </tr>
 
  <tr>
    <td>&nbsp;</td>
    <td>Phone 1</td>
    <td><input type='text' name='phone1' size = '40' maxlength='30' value = '<?php echo $phone1; ?>'></td>
    <td>07777 777777</td>
  </tr>
 
 
 
  <tr>
    <td>&nbsp;</td>
    <td>Phone 2</td>
    <td><input type='text' name='phone2' size = '40' maxlength= '30'value = '<?php echo $phone2; ?>'></td>
    <td>0118 123 4567</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Location</td>
    <td><input type='text' name='location' size = '40' maxlength='40'value = '<?php echo $location; ?>'></td>
    <td>52.289071,-1.952004</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Qualifications</td>
    <td><input type='text' name='qualifications'  size = '40' maxlength='30' value = '<?php echo $qualifications; ?>'></td>
    <td>Electrician</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Expertise</td>
    <td><input type='text' name='qualifications'  size = '40' maxlength='30' value = '<?php echo $expertise; ?>'></td>
    <td>Flexwings</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Assistance Offered</td>
    <td><input type='text' name='assistance' size = '40' maxlength='50' value = '<?php echo $assistance; ?>' /></td>
    <td>Trailer and Tow Car</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Language Skills</td>
    <td><input type='text' name='published' size = '40' maxlength='50' value = '<?php echo $language; ?>' /></td>
    <td><p>English / Spanish</p></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>E-Mail</td>
    <td><input type='text' name='comments' size = '40' maxlength='50' value = '<?php echo $e-mail; ?>' /></td>
    <td><p>example@mail.net</p></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Consent</td>
    <td>
      <select name = "surface">
        <option value = "Yes" <?php if ($_POST['consent'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option>
        <option value = "No" <?php if ($_POST['consent'] == 'No') { echo 'selected="selected"'; } ?>>No</option>
       
     
  </select>
     
      </td>
    <td>Yes</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Published</td>
    <td>
   
     <select name = "food">
     <option value = "Yes" <?php if ($_POST['published'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option>
        <option value = "No" <?php if ($_POST['published'] == 'No') { echo 'selected="selected"'; } ?>>No</option>
</select>
   
    </td>
    <td>Yes</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Comments</td>
    <td><textarea name= "remarks" input type = 'text' rows = "5" cols = "29" /><?php echo $remarks; ?></textarea></td>
    <td>As much info as possible 500 characters max</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Other Info</td>
    <td><textarea name= "warnings" input="input" type = 'text' rows = "5" cols = "29" /><?php echo $warnings; ?></textarea></td>
    <td>As much info as possible 500 characters max</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input type='submit' name='submit' value='Submit Your Info' /></td>
    <td colspan="2">
      <? require_once('recaptchalib.php');
  $publickey = "6Ld2xscSAAAAAH3_KiJoRLR4sEWFFQR4yAr5F1xi"; // you got this from the signup page
  echo recaptcha_get_html($publickey);?></td>
  </tr>
</table>
</form>


</body>
</html>
<?php } ?>

Hi-
the code below lets me upload a CSV file to my database if I have 1 field in my database and 1 column in my CSV.
I need to add to my db "player_id" from the CVS file and "event_name" and "event_type" from the form... any ideas???

here's the code:
Code: [Select]
<?php
$hoststring =""; 
$database = "";
$username = "";
$password = "";
$makeconnection = mysql_pconnect($hoststring, $username, $password);
?>
<?php
ob_start();
mysql_select_db($database, $makeconnection);
$sql_get_players="
SELECT * 
FROM tabel 
ORDER BY player_id ASC";
//
$get_players = mysql_query($sql_get_players, $makeconnection) or die(mysql_error());
$row_get_players = mysql_fetch_assoc($get_players);
//
$message = null;
$allowed_extensions = array('csv');
$upload_path = '.'; //same directory

if (!empty($_FILES['file'])) {

if ($_FILES['file']['error'] == 0) {
// check extension
$file = explode(".", $_FILES['file']['name']);
$extension = array_pop($file);

if (in_array($extension, $allowed_extensions)) {

if (move_uploaded_file($_FILES['file']['tmp_name'], $upload_path.'/'.$_FILES['file']['name'])) {

if (($handle = fopen($upload_path.'/'.$_FILES['file']['name'], "r")) !== false) {
$keys = array();
$out = array();
$insert = array();
$line = 1;

while (($row = fgetcsv($handle, 0, ',', '"')) !== FALSE) {

foreach($row as $key => $value) {    

if ($line === 1) {
$keys[$key] = $value;       
} else {       
$out[$line][$key] = $value;              
}       
}                
$line++;          
}        

fclose($handle);            

if (!empty($keys) && !empty($out)) {        
$db = new PDO(
'mysql:host=host;dbname=db', 
'user', 
'pw');   

$db->exec("SET CHARACTER SET utf8");        

foreach($out as $key => $value) {        
$sql  = "INSERT INTO `table` (`";
$sql .= implode("`player_id`", $keys);    
$sql .= "`) VALUES (";    
$sql .= implode(", ", array_fill(0, count($keys), "?"));    
$sql .= ")";    
$statement = $db->prepare($sql);    
$statement->execute($value);       
}      

$message = '<span>File has been uploaded successfully</span>';      
}
}
}
} else {
$message = '<span>Only .csv file format is allowed</span>';
}
} else {
$message = '<span>There was a problem with your file</span>';
}
}
ob_flush();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>CSV File Upload</title>
</head>
<body>

<form class="form" action="" method="post" enctype="multipart/form-data">
<h3>Select Your File</h3>
<p><?php echo $message; ?></p>
<input type="file" name="file" id="file" size="30" />
<br/>
<label>Event Name:</label><input name="event_name" type="text" value="" />
<br/>
<label>Event Type:</label><input name="event_type" type="text" value="" />
<br/>
<input type="submit" id="btn" class="button" value="Submit" />
</form>

<br/>
<h3>Results:</h3>
<?php do { ?>
<p><?php echo $row_get_players['player_id'];?></p>
<?php } while ($row_get_players = mysql_fetch_assoc($get_players)); ?>
</body>
</html>

Hello, I've looked around at some previous posts and can't seem to get them to work for me.
I'm occasionally receiving blank emails from my contact form,
i.e.
Name:
Email:
Subject:
Message:
with no fields filled out.
No doubt the cause is my form.
It has validation, and I'm aware that with JS turned off, the validation won't work, but I find it hard to believe that people are just submitting blank forms, I'm confused, and am worried that I'm getting emails and not realizing it!

My code is below, if you can point me in the right direction or point out the problem area that would be great!
website is:    www.ed-yu.com

Code: [Select]
    <div id="contact_box">
<h3>Questions?<br />Comments?<br />Just get in touch.</h3><p>(use the form below, or email edward@ed-yu.com)</p>
<form id="contact" method="post" class="form" action="js/contactengine.php">
<p class="name">
<input type="text" name="Name" id="Name" />
                <label for="Name">Name</label>
</p>
                <p class="email">
<input type="text" name="Email" id="Email" />
<label for="Email">Email</label>
</p>
                <p class="Subject">
        <select name="Subject" id="Subject">
                <option value="000" selected="selected"> - Choose -</option>
                <option value="General Question">General Question</option>
                <option value="Photography Inquiry">Photography Inquiry</option>
                <option value="Web-design Inquiry">Web-design Inquiry</option>
                <option value="Love Letter">Love Letter</option>
                <option value="Hate Mail">Hate Mail</option>
                <option value="Website Feedback">Website Feedback</option>
        </select>
                <label for="Subject">Subject</label>
</p>
                <p class="Message">
<label for="Message"> </label><br />
<textarea name="Message" rows="20" cols="20" id="Message"></textarea>
</p>
                <p class="Submit">
<input type="Submit" name="Submit" value="Send Email" class="submit-button" />
                </p>
</form>
</div><!--contact_box-->

Code: [Select]
<?php

$EmailFrom = "ED-YU.com";
$EmailTo = "eddytheflow@gmail.com";
$Subject = "A new ".mb_strtolower($_POST['Subject'])." from ".$_POST['Name']." ";
$Name = Trim(stripslashes($_POST['Name'])); 
$Tel = Trim(stripslashes($_POST['Tel'])); 
$Email = Trim(stripslashes($_POST['Email'])); 
$Message = Trim(stripslashes($_POST['Message'])); 


// validation
$validationOK=true;
if (!$validationOK) {
  print "<meta http-equiv=\"refresh\" content=\"0;URL=error.htm\">";
  exit;
}

// prepare email body text
$Body = "";
$Body .= "Name: ";
$Body .= $Name;
$Body .= "\n";
$Body .= "Email: ";
$Body .= $Email;
$Body .= "\n";
$Body .= "Subject: ";
$Body .= $Subject;
$Body .= "\n";
$Body .= "Message: ";
$Body .= $Message;
$Body .= "\n";

// send email 
$success = mail($EmailTo, $Subject, $Body, "From: <$EmailFrom>");

// redirect to success page 
if ($success){
  print "<meta http-equiv=\"refresh\" content=\"0;URL=contactthanks.php\">";
}
else{
  print "<meta http-equiv=\"refresh\" content=\"0;URL=error.htm\">";
}
?>

Hey all. I'm a noob so bare with me. Just started studying php and have an assignment due. At this phase of the project I have to create a form where a user can register data and I should retrieve that data and store it in my database. Now I have already created the form (student_reg.php) and a separate file with php code (demo.php)

My database is name "registration" and I am trying to put this info in the "student" table. It has about 15 fields but for now I am only trying trying to insert the 1 field of data to test if it works. Dont know if that may cause problems?

So far my demo.php connects to the database successfully. The problem I am having is the information I submit does not showing in the database field. However, I have an id field in my case a student number field which is set to auto increment so it automatically updates (1,2,3,4) with each new sumbitted info. When I submit the info the id field gets updated each time with a new row ( so i assume some information is somehow going through ) however the info I entered will remain blank in its field. :banghead:

Heres my form (student_reg.php)

Code: [Select]
<div id="apdiv3">

<FORM action = "demo.php" method ="post ">

<p>Course name:</p>
<INPUT TYPE = "text"  name="input"/>
<INPUT TYPE = "Submit" VALUE = "Submit"/>
</div>
</FORM>

and heres my php code to retrieve the form info

Code: [Select]
<?PHP


include 'includes/config.php';

//connect to database
$link=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);



//error check
if (!$link)
{
die('could not connect: ' . mysql_error());
}

$db_selected=mysql_select_db(DB_NAME, $link);



// error check
if (!$db_selected)
{
die('can\t use ' . DB_NAME . ': ' . mysql_error());
}
// Connected to database



// retrieve form data
$value=(isset($_POST['input']));

$sql = "INSERT INTO student (sname) VALUES ('$value')";


if (!mysql_query($sql))
{
die ('Error: ' . mysql_error());
}
mysql_close();


?>

I also recieved a notice "undefined index" or something like that from this part of the code "$value=(isset($_POST['input']));" before I inserted "isset" to the code. I'm not sure if what I did fixed the problem or only hid it, or whether that notice was related to the problem I'm having of not retrieving the info.

Haha sorry guys know this is probably childs play for you but I just started out and really need to fix this so I can catch up with this project. Feel free to add tips and comments on other areas. Thanks :mrgreen: