PHP - If [form Validated] Submit Form1 Else Submit Form2?

Can anybody see as to why, if any, this form takes forever to execute?
Code: [Select]
<?php
if(isset($_POST['submitted'])){
    $z = $_POST['zipcode'];
    $r = $_POST['radius'];
    
    $sql = mysql_query("SELECT DISTINCT m.LocAddZip, m.MktName,m.LocAddSt,m.LocAddCity,m.LocAddState,m.x1,m.y1,z1.lat,z2.long
    FROM mrk m, zip z1, zip z2
    WHERE m.LocAddZip = z1.zipcode
    AND z2.zipcode = $z
    AND ( 3963 * acos( truncate( sin( z2.lat / 57.2958 ) * sin( z1.lat / 57.2958 ) + cos( z2.lat / 57.2958 ) * cos( z1.lat / 57.2958 ) * cos( z1.long / 57.2958 - z2.long / 57.2958 ) , 8 ) ) ) <= $r ")
    
    or die(mysql_error());
        while($row = mysql_fetch_array( $sql )) {
            $store = $row['MktName']."<br />";
            $store .= $row['LocAddSt']."<br />";
            $store .= $row['LocAddCity'].", ".$row['LocAddState']." ".$row['LocAddZip'];
            $lat1 = $row['lat'];
            $lon1 = $row['long'];
            $lat2 = $row['y1'];
            $lon2 = $row['x1'];
            $dis = distance($lat1, $lon1, $lat2, $lon2);
     
            echo "<p>".$store."</p>";        
            echo ceil($dis) . " mile(s) away";
            echo "<hr/>";
        }
}
?>

I get a timeout error sometimes, and sometimes I don't.
Is it the form, or would it be on the server?

Thanks in advance

Hi,
I want to submit a form using ajax ans jquery with two fields input text and file.

Code: [Select]
<script>
$(document).ready(
function()
{


$('#basicinfofrm').ajaxForm(function() {
url: ''+PN+'.php',
type:'POST',
data:'action=yes&'+frmFeilds,
success: function(html)
{ 
 alert(html);

}

    }).submit();
</script>
<form action='' method='post'>
    <label>name</label>
    <input type='text' name='txtname' />
    <input type='file' name  = 'txtfile' />
   <input type='submit' value='save' />
</form>

but is is not working...
can anyone tell me how to?
i don't want to refresh my page
Thanks

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.

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

hello everyone, I have a php form, everything works, I do not carry any header() at the end of the form because I have to stay on the same page and because I feel it wipes out the message you sent the form successfully, but for this though if reloading  the page shows me the popup asking me to resend the form.  how can i solve?  I found a function in js with replacestate but I saw that it doesn't work with mobile Safari.

if ( window.history.replaceState ) { window.history.replaceState( null, null, window.location.href ); }

 

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>

I have a form on my website and when the user submits it I want all the server processing to be done using AJAX so the page doesn't refresh.  I was wondering what the best way to do this is because if your form has a submit button doesn't that automatically refresh the page?

Thanks for any help. 

Right now i got the code posted below.
It works alright, but it has 1 problem. When i press the submit button the form resets, but what i want is that the checkboxes which were checked remain checked and the values selected in the dropdown box keep that value.
How can you do this? Is it even possible with php or am i going to need js?


<?php
$verhuur = 60.00;
$Totaal = 0;

$Averhuur = "";

if (isset($_POST['Averhuur'])) {
$Averhuur = $_POST['Averhuur'];
}

if (isset($_POST['verhuur'])) {
$verhuur = $verhuur * $Averhuur;
$Totaal = $Totaal + $verhuur;
}

?>

<form action="test.php" method="post">
<table>
<tr>
<td> <input type="checkbox" name="verhuur" value="" /></td>
<td>Verhuur</td>
<td>&euro; 60,00</td>
<td> 
<select name="Averhuur">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</td>
</tr>
<tr>
<td> </td>
<td><strong>Totaal:</strong></td>
<td>
<strong>
<?php
$formatnumber = number_format($Totaal, 2, ',', '');

echo "&euro; ";

if($Totaal!=0){
echo $formatnumber;
} else {
echo "0,00";
}
?>
</strong>
</td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="Bereken" /></td>
</tr>
</table>
</form>

I'm a bit new to PHP and I'm getting my feet wet with mvc with code igniter. I'm having a bit of trouble with my view accessing a function from my controller. If anyone has seen CodeIgniter from Scratch Day 4, it's that tutorial - i've created an email newsletter signup.   In my my view (newsletter.php), my submit button is not working and isn't able to access a function from my controller (email.php). The inaccessible function is called function send(). Instead, I get a 404 error. I'll post the code from both the view and controller, but I highly suspect the error is contained within the view because my controller loads the view, but my view can't call a function from the controller. Any help you can provide would be greatly appreciated. Thanks.   Here's the code from my view (newsletter.php):   <html lang='en'>

I've got a form that submits values to itself and the user input values are saved into the database in a table with an auto incrementing ID. After SUBMIT is clicked, it reloads the page and all the values are gone, I'm wondering how I can get it to keep the values so that the user can make a single change and resubmit again.

I know I can save all the values into the session or in the URL or pass them through $_POST in an array but I'm wondering what is the proper way to do this. Thanks.

Hi Guy,

First Post ..so please help!

I have rows returning from a mYSQL Database which  I put in a form which is php generated and im sending this form to the next page with a SUBMIT button. I want PHP/Javascript to do this automatically when the data is loaded from the MYSQL Table

Ive tried fsockpen and document.form.submit() but it doesnt seem to work

Any help.
Thanks in Adv,
Hittesh Ahuja
<?php session_start();
if(isset($_POST['submit']))
{
header("Location: http://localhost/PHP/brk_plan.php");
}
?>
<!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>Untitled Document</title>
</head>

<body>

<p>
  <?php 
require_once('connect.php');
$email=$_SESSION['email'];

$query="SELECT glycemic_index.gi_id,glycemic_index.value FROM food_preference JOIN glycemic_index ON glycemic_index.gi_id=food_preference.gi_id WHERE food_preference.email='$email' and glycemic_index.value >= 55 " or die("Update not Possible");
$result=mysql_query($query);

$session_array=array();
echo "<form method='post' action='brk_plan.php' name='recommend'>";
echo "<p>This area is filtered from the user's table showing values only > 55</p>";
while($row=mysql_fetch_array($result))
{


echo "Instead of: ".$row[0]."-".$row[1]."<br/>";




$one=$row[0];

 $one_trimmed=substr($one,2,strlen($one)-5);

 $one_search="%".$one_trimmed."%";


$query2="SELECT glycemic_index.gi_id,glycemic_index.value,glycemic_index.food FROM glycemic_index WHERE glycemic_index.gi_id LIKE '$one_search' AND glycemic_index.value <55 AND glycemic_index.gi_id!='$row[0]' ORDER BY RAND() LIMIT 1  ";
$result2=mysql_query($query2);

while($row2=mysql_fetch_array($result2))
{


echo "<input type='hidden' value='$row2[2]' name='fields[]'></input>";
echo "<p>You can have ".$row2[2].": ".$row2[0]."-".$row2[1]."</p>";

}



}

echo "<input type='submit' name='submit' value='dikha!'></input>";
echo "</form>";










//$_SESSION['higher_gi']=$session_array;
//foreach($session_array as $value)
 //{
// echo $value."<br/>";

 //}
?>
</p>
<p></p>
<p></p>

<p></p>
<p></p>
<p>&nbsp;</p>
</body>
</html>

I have a Feedback form that I use to get peoples input. So far it works But I have 2 Problems

Here is the Code:
Code: [Select]
<?php
include "includes/config.php";
$date   = date('jS \of F  h:i A');



$sql="INSERT INTO news (name, email, comments, date)
VALUES
('$_POST[Name]', '$_POST[email]', '$_POST[comments]', '$date')";

header( 'Location: thanks.php' );

mysql_close($con)
?>
I'm making a VB.net Feedback form and I want to imput like this

http://mysite.com/feedback.php?name=Mike&email=test@test.net&comments=comment&date=20th of April  12:30 AM

But so far from my testing it doesn't register the values and says that there is a Duplicate value for email ".

I'd like it to register values somehow and if there is a duplicate email entered then have it update it or write over it.

Any help appreciated,
Thanks!

hi i hv a form to submit on this url

http://localhost/site/index.php?action=search

and in my html
<form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
// my code
</form>

// i also tried 
//http://localhost/site/index.php?action=search&
// but did not helped

now problem is i wants to go that URL so after submit it should look a like this as i am loading search page with action.
http://localhost/site/index.php?action=search&searchstring=word

but it keeps me redirecting to
http://localhost/site/index.php?searchstring=word

how can i make it work so it will goto this URL
http://localhost/site/index.php?action=search&searchstring=word

Thanks for help.

I have a form which people can submit information to and then creates a unique ID number.  I then echo the form results onto another page.  I also want to use the unique id within a link however it echos every id in the database and not just the unique id of the newly submitted form.

For example, on 100th submit:

For Submit: hello my name is Tom.

Echo:          $comment      hello my name is Tom.
                   $id                 1009998979695949392919089.................

Can anyone advise how I can get it so echo just the id number which refers to this submission. IE "hello my name is Tom"