PHP - Whenever I Try To Submit A Form Download Process Begins???????////whyyyyyy

The error is "Error: Duplicate entry '' for key 'usr'"

I don't have any fields with that name.

here is the process code.


<?php
$con = mysql_connect("localhost","uname","pw") or die('Could not connect: ' . mysql_error());
mysql_select_db("db") or die(mysql_error());

$FirstName=mysql_real_escape_string($_POST['FirstName']); //This value has to be the same as in the HTML form file
$LastName=mysql_real_escape_string($_POST['LastName']); //This value has to be the same as in the HTML form file
$UserName=mysql_real_escape_string($_POST['UserName']); //This value has to be the same as in the HTML form file
$Password= md5($_POST['Password']); //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
$Zip=mysql_real_escape_string($_POST['Zip']); //This value has to be the same as in the HTML form file
$Birthday=mysql_real_escape_string($_POST['Birthday']); //This value has to be the same as in the HTML form file
$Security=mysql_real_escape_string($_POST['Security']); //This value has to be the same as in the HTML form file
/*
 *  Specify the field names that are in the form. This is meant 
 *  for security so that someone can't send whatever they want 
 *  to the form.
 */
$allowedFields = array(
'FirstName',
'LastName',
'UserName',
'Password',
'email',
'Birthday',
'Zip',
'Security',
);

// Specify the field names that you want to require...
$requiredFields = array(
'FirstName',
'LastName',
'UserName',
'Password',
'email',
'Birthday',
'Zip',
'Security',
);

$errors = array();
foreach($_POST AS $key => $value)
{
// first need to make sure this is an allowed field
if(in_array($key, $allowedFields))
{
$$key = $value;

// is this a required field?
if(in_array($key, $requiredFields) && $value == '')
{
$errors[] = "The field $key is required.";
}
}
}

// were there any errors?
if(count($errors) > 0)
{
$errorString = '<p>There was an error processing the form.</p>';
$errorString .= '<ul>';
foreach($errors as $error)
{
$errorString .= "<li>$error</li>";
}
$errorString .= '</ul>';

// display the previous form
include 'index.php';
}
else
{


$sql="INSERT INTO Profile (`FirstName`,`LastName`,`Username`,`Password`,`email`,`Zip`,`Birthday`,`Security`) VALUES ('$FirstName','$LastName','$UserName','$Password','$email','$Zip','$Birthday','$Security')"; 
if (!mysql_query($sql,$con)) {
 die('Error: ' . mysql_error());
 }
//send email
mail('email@gmail.com','A profile has been submitted!',$FirstName.' has submitted their profile',$body);

// display the thank you page
header("Location: thanks.html");
}

I have this form I am trying to process, but it won't work?
if($count==0){

Code: [Select]
echo "That Bidder Number is NOT logged in, ";
echo "would you like to set this bidder as active?";
echo " Enter 1 for NO or 2 for YES";
echo "<form action= \"process.php\" method= \"POST\">";
echo "<input type =\"text\" name= \"logUser\"/>";
echo "<input type= \"submit\" value = \"Submit\"/>";
$logUser= isset($_POST['logUser']) ? $_POST['logUser'] : '';
header("Location: process.php");
exit();
}

All I want to do is process the users input and either input data into the database or simply redirect the user.
Why the hell is this so complicated for??

I am processing the form on the same page it is displayed.

Here's my procressing
Code: [Select]
if ($logUser= 1) {
header("Location: inprogress.php");
exit();
}

else if ($logUser= 2){
// Add $biddersId and redirect to anypage
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_Query("INSERT INTO bidders (biddersId)
VALUES ('$winningBidder')");

 

mysql_query("INSERT INTO transactions (itemDescription, itemPrice, bidderId, itemQty , totalPrice)
 VALUES('$itemDescription', '$itemPrice','$winningBidder', '$itemQty', '$totalPrice')")
or die(mysql_error());   
header("Location: inprogress.php");
exit();
   }

I am not getting the result I am hoping for. The code below is full code after a form has been submitted containing a member name and amount of credits:

Code: [Select]
<?php
if (isset($t)){
$t = $_GET['t'];}
?>
<?php
$amount = $_POST['amount'];
$member = $_POST['member'];

$sql = ("SELECT vtp_members.name, vtp_members.team_id FROM vtp_members WHERE vtp_members.team_id=".$_GET['t']." AND vtp_members.name='$member' AND teams.team_treasure >= '$amount' ");
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
if($numrows == '1')
{
  $sql2 = "UPDATE vtp_members, teams SET vtp_members.hits=(vtp_members.hits + '$amount'), teams.team_treasure=(teams.team_treasure - '$amount')
WHERE vtp_members.name='$member' AND teams.team_id=".$_GET['t']." ";
$results2 = mysql_query($sql2);
$row2 = mysql_fetch_row($results2);
$tmap2 = $row2[0];

echo "You sent ". $amount . "credits to " . $member . ". ";
}
else
{
echo "The treasure holdings are too low for this transfer<br>(or an error occured)";}

?>
Problem; it returns the else statement although the "teams.team_treasure" is higher or equal to  "$amount"

Can someone please help? I am simply trying to email process a form with checkboxes and then redirect to a thank you page.  It works fine as long as at least one checkbox is checked. It breaks if no checkboxes are checked using the implode function to list the "interests". I'm getting this error (and no redirect to my thank you page): Warning: implode() [function.implode]: Invalid arguments passed...

<?php
if (isset($_REQUEST['submit']))
{
   $email = $_REQUEST['email'];
   $firstName = $_REQUEST['firstName'];
   $lastName = $_REQUEST['lastName'];
   $address = $_REQUEST['address'];
   $city = $_REQUEST['city'];
   $state = $_REQUEST['state'];
   $zipcode = $_REQUEST['zipcode'];
   $homePhone = $_REQUEST['homePhone'];
   $cellPhone = $_REQUEST['cellPhone'];
   $interest = $_REQUEST['interest'];
   $imploded_interest = implode(',',$interest);
   $comments = $_REQUEST['comments'];
   $to  = 'myemailhere@yahoo.com';
   $subject = 'Volunteer Signup';
   $message = "
   <html>
   <head>
   <title>Volunteer Signup</title>
   </head>
   <body>
      <p>Hello,<br/>A visitor has submitted the following information from the volunteer page:</p>
      <p><b>$firstName $lastName</b><br/>
      $address<br/>
      $city, $state $zipcode<br/><br/>
      Home Phone: $homePhone<br/>
      Cell Phone: $cellPhone<br/>
      Email: <strong>$email</strong><br/><br/>
      I would like to help in the following ways:<br/>
      $imploded_interest
      </p><br/>
      <p>$firstName would also like share the following comments:<br/>
      <q><i>$comments</i></q>
      </p>
      </body>
      </html>
      ";
   $headers  = 'MIME-Version: 1.0' . "\r\n";
   $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
   $headers .= 'From: Volunteer Signup <myemailhere@yahoo.com>' . "\r\n";
   mail($to, $subject, $message, $headers);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Volunteer</title>
</head>
<body>
            <form id="VolunteerForm" method="post" action="thankyou.php">
                 <table>
                           <tr>
                               <td style="width:150px;">Email Address:</td>
                                <td><input name="email" type="text" id="email" /></td>
                                <td style="width:320px;" class="padtr"><strong>Ways I can help:</strong></td>
                           </tr>
                                 <tr>
                               <td>First Name:</td>
                                <td><input name="firstName" type="text" id="firstName" /></td>
                                <td class="padtr"><input name="interest[]" value="yard-sign" type="checkbox"/>
                        Put a yard sign in my yard</td>
                            </tr>
                            <tr>
                               <td>Last Name:</td>
                                <td><input name="lastName" type="text" id="lastName" /></td>
                                <td class="padtr"><input name="interest[]" value="fundraiser-at-home" type="checkbox" />
                        Host a fundraiser at my home</td>
                            </tr>
                            <tr>
                               <td>Address:</td>
                                <td><input name="address" type="text" id="address" /></td>
                                <td class="padtr"><input name="interest[]" value="phone-calls" type="checkbox" />
                                Make phone calls to friends and family</td>
                            </tr>
                            <tr>
                               <td>City:</td>
                                <td><input name="city" type="text" id="city" /></td>
                                <td class="padtr"><input name="interest[]" value="mailings" type="checkbox" />
                                Help with mailings</td>
                            </tr>
                            <tr>
                               <td>State:</td>
                                <td><input name="state" type="text" id="state" /></td>
                                <td class="padtr"><input name="interest[]" value="doors-literature" type="checkbox" />
                                  Help knock on doors and distribute literature</td>
                            </tr>
                            <tr>
                               <td>Zip Code:</td>
                                <td><input name="zipcode" type="text" id="zipcode" /></td>
                                <td class="padtr"><input name="interest[]" value="donate" type="checkbox" />
                                  Make a donation</td>
                            </tr>
                            <tr>
                               <td>Home Phone:</td>
                                <td><input name="homePhone" type="text" id="homephone" /></td>
                                <td class="padtr"><input name="interest[]" value="endorsement" type="checkbox" />
                                Use my name as an endorsement</td>
                            </tr>
                            <tr>
                               <td>Cell Phone:</td>
                                <td><input name="cellPhone" type="text" id="cellphone" /></td>
                                <td class="padtr"><input name="interest[]" value="newsletter" type="checkbox" />
                                Sign up for our newsletter</td>
                            </tr>
                            <tr>
                              <td>Comments:</td>
                       <td><textarea name="comments" id="comments" rows="5" cols="17"></textarea></td>
                              <td>&nbsp;</td>
                            </tr>
                            <tr>
                           <td>&nbsp;</td>
                           <td>&nbsp;</td>
                                <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="submit" id="submit" value="Submit Now" />&nbsp; <input type="reset" name="reset" id="reset" value="Clear Form" /></td>
                            </tr>
                        </table>
                        </form>
</body>
</html>

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once.  Is that possible to do? 

Here's my code.

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

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

 

Edited January 13, 2019 by imgrooot

Hi.  Pretty straight forward I guess but as the name suggests am a newbie.  I have a form that requires the user to enter certain parameters.  If the values are blank it submits to itself and loads the error messages.  What I want to do is create PHP code that submits the form to a different url.  What I thought was create two forms (the second with hidden fields replicating the first form), each form having a different url in the action"" code.  What I cant work out is the PHP IF ELSE code to submit form 2 if Form1 is is validated correctly.  This is the PHP code relevant to the form validation.  Help?

<?php
      //If form was submitted
      if ($_POST['submitted']==1) {
          $errormsg = ""; //Initialize errors
          if ($_POST[width]){
             $title = $_POST[width]; //If title was entered
          }
          else{
             $errormsg = "Please enter width";
          }
          if ($_POST[drop]){
             $textentry = $_POST[drop]; //If comment was entered
          }
          else{
             if ($errormsg){ //If there is already an error, add next error
                $errormsg = $errormsg . " & content";
             }else{
                $errormsg = "Please enter drop";
             }
          }
      }

      if ($errormsg){ //If any errors display them
          echo "<div class=\"box red\">$errormsg</div>";
      }

      //If all fields present
      if ($title && $textentry){
         //Do something
          
echo 'THIS IS WHERE I WANT THE CODE TO SUBMIT FORM 2 or SUBMIT FORM 1 TO A DIFFERENT URL';
      }   
      ?>

Hello, i am trying to create a drop down list witch is inside a form and it is dynamicly created. When the user press the download button of the form to automaticly donwload a pdf.But i dont' kown how to do that. Here is the code

This is the form. there us a download button. when it's clicked it goes to pdf.php posting the teuxos id to the pdf.php
Code: [Select]
     <form id="form1" name="form1" method="post" action="pdf.php">
     <label for="teuxos_drop_down"></label>
     <select name="teuxos" id="teuxos_drop_down">
      <?php
while($teuxoi_row = mysql_fetch_array($teuxoi_res)){
echo "<option value=".$teuxoi_row['teuxos_id'].">" .$teuxoi_row["teuxos"]. "</option>";
}
?>
     </select>
     <button> download</button>
   </form>

and here what i have on pdf.php. Insead of downloading the file i have it empbedded. But i want to download automaticly when the user clicks the download button
Code: [Select]
if (isset($_POST['teuxos'])){
$teuxos_id = $_POST['teuxos'];
}else{
$teuxos_id= NULL;
}
$teuxos_res = mysql_query("SELECT * FROM teuxoi WHERE teuxos_id=".$teuxos_id, $connection);
if(!$teuxos_res){
die("Database Query Failed" . mysql_error());
}
$teuxos_row = mysql_fetch_array($teuxos_res);
?>
<?php echo "<embed src='".$teuxos_row['teuxos_link']."' width='1000' height='800'/>";
?>

Hello, first time poster..  I've looked the web over for a long time and can't figure this one out.

- Below is basic code that successfully checks MySQL for a match and displays result.  I was debugging and forced the "height" and "width" to be 24 and 36 to make sure that wasn't the problem.  That's good.. 
- I'd like to give the user ability to select width and height from a form.. and have it do an onchange this.form.submit so the form can be changing as fields are altered (thus the onchange interaction)
- In a normal coding environment I've done this numerous times with no "Page cannot be displayed" problems.  It would simply change one select-option value at a time til they get down the form and click submit...  but in WordPress I'm having trouble making even ONE single onchange work!
- I've implemented the plugins they offer which allows you to "copy+paste" your php code directly into their wysiwyg editor.  That works with basic tests like my first bullet point above.
- I've copied and pasted the wordpress url (including the little ?page_id=123) into the form "action" url... that didn't work...  tried forcing it into an <option value=""> tag.. didn't work.  I'm just not sure. 

I've obviously put xx's in place of private info..

Why does this form give me Page Cannot Be Displayed in WordPress every time?  It won't do anything no matter how simple.. using onchange..

Code..

$con = mysql_connect("xxxx.xxxxxxx.com","xxxxxx","xxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("xxxxxx", $con);
$myprodwidth=24;
$myprodheight=36;
$result = mysql_query("SELECT * FROM product_sizes WHERE prodwidth='$myprodwidth' and prodheight='$myprodheight'");
while($row = mysql_fetch_array($result))
  {
  echo $row['prodprice'];
  }
mysql_close($con);


<form method="post" action="">
<select name="myheight" onchange="this.form.submit();">
<option selected="selected" value="">select height</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">36</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">48</option>
</select>

Hey guys,
I'm going to start working on a simple php/mysql project, and wondering if you guys could point me in the right direction. Here is what I want to do:

1. User is presented with a simple form asking a series of questions (including email address)
2. Based on the answers, a specific download link is emailed to the user
3. store all inputted information in the database.

I'm still not sure if I want the email process to be automated, or "held" until the information is reviewed, then download link sent.

Does anyone know if a script already exist for this? I don't need to create user accounts, I just want to obtain user information every time they want to download something.

Thanks for any help.

Hi all,

What I am trying to achieve is, I thought quite simple!

Basically, a user signs up and chooses a package, form is submitted, details added to the database, email sent to customer, then I want to direct them to a paypal payment screen, this is where I am having issues!

Is their any way in php to submit a form without user interaction? Here is my code for the form process page
Code: [Select]
<?php
include('config.php');
require('scripts/class.phpmailer.php');

$package = $_POST['select1'];
$name = $_POST['name'];
$email = $_POST['email'];
$password = md5($_POST['password']);

$domain = $_POST['domain'];
$a_username = $_POST['a_username'];
$a_password = $_POST['a_password'];


$query=mysql_query("INSERT INTO orders (package, name, email, password, domain, a_username, a_password)
VALUES
('$package', '$name', '$email', '$password', '$domain', '$a_username', '$a_password')");

if (!$query)
{
echo "fail<br>";
echo mysql_error();
}

else
{
$id = mysql_insert_id();
$query1=mysql_query("INSERT INTO customers (id, name, email, password)
values
('$id', '$name', '$email', '$password')");

if (!$query1)
{
echo "fail<br>";
echo mysql_error();
}


if($package=="Reseller Hosting")
{

//email stuff here - all works - just cutting it to keep the code short


if(!$mail->Send())
{
   echo "Message could not be sent. <p>";
   echo "Mailer Error: " . $mail->ErrorInfo;
   exit;
}
?>


<form name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick-subscriptions">
<input type="hidden" name="business" value="subscription@jollyhosting.com">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="item_name" value="Jolly Hosting Reseller Packages">
<input type="hidden" name="no_shipping" value="1">

<!--1st month -->
<input type="hidden" name="currency_code" value="USD"> 
<input type="hidden" name="a3" value="3.00">
<input type="hidden" name="p3" value="1">
<input type="hidden" name="t3" value="M">
<input type="hidden" name="src" value="1">
<input type="hidden" name="sra" value="1">
</form>';


<?php
}

//last
}
//end
?>

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>

Basically I would like to place a link on my website and have the user download a file, but rather than just right clicking and choosing save target as, the link must be clicked, on the next page the file is fetched and then the client can download the file. How would I go about setting this up please?

When the download appears the link that is produced doesn't show the actual download either, so users can't leech of it.

Thanks

Hi, I have setup a basic enquiry form with a Captcha - once the code has been inserted and is correct I want to action the form (submit) in PHP.

<?php

session_start();
if($_SERVER['REQUEST_METHOD'] == 'POST'){
$vResult = '';
if(strtolower($_SESSION['security_code']) != strtolower($_POST['security_code'])){
$vResult = 'Invalid code!';
}
else{
"/enquiry.php"
}
}
?>

I want to submit the form to /enquiry.php - I tried header(Location.. and realised that just redirects, and doesn't submit the form.

Any suggestions or tips would be great.

Cheers,

Paul

I can't submit php form using IE 8.  This works fine on Firefox very well.
I tried following code but none of them is working.   
1.  <button type="submit">Submit</button>

2.  <input type="submit" value="Submit" name="submit">


 I would appreciate if any one help me in this.

Code: [Select]
<?php
 
if (isset($_POST['checking'])) { echo $_POST['checking']; }
if (isset($_POST['test'])) { echo $_POST['test']; }
 
?>
 
 
<form id="testform2" action="testform.php" method="post">
 
<select name="checking" onchange="this.form.submit()"><option value="5">5</option><option value="6">6</option></select>
<input type="text" name"test" id="test">
 <a href="#" onclick="this.form.submit()">submit it!</a>
</form>


It works when I try to submit by selecting a new value from the dropdown box but when I try to click the link it won't display the text field value. That is a test case for a problem I m having in one of my codes.