Forum:

HTML Pages with CSS and JavaScript

Using javascript with PHP

Greenhorn

Posts: 2

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello, I have a form which sends data to my database and it works well in all PHP, but I want to add a popup result and someone suggested javascript. When I use the javascript it does the popup real well but the results do not go to the database. Could someone please look at my code to see where the problem is? Thank you. I'm sure someone will let me know if this is the wrong forum for this type of question

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<script type="text/javascript">
function popsubmit(form) {
var popName = "formPopUp";
var popStyle = "width=300,height=300,location=yes,resizable=yes";
form.action = "newsletter.php";
form.target = popName;
window.open("about:blank",popName,popStyle);
}
</script>
</head>
<body>
<?php
// show everything
error_reporting(E_ALL);

$self =  $_SERVER['PHP_SELF'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$user_email = $_POST['user_email'];
$zip = $_POST['zip'];
//if( !$rs ) {echo ("<p class='style3'>Sign up for our free newsletter!</p>");}

$form = "<form action='".$self."' method='post'>";
$form .= "<p class='style3'>First Name: <br><input type='text' name='first_name' size='10'><br>";
$form .= "Last Name: <br><input type='text' name='last_name' size='10'><br>";
$form .= "Email: <br><input type='text' name='user_email' size='10'><br>";
$form .= "Zip Code: <br><input type='text' name='zip' size='10'><br></p>";
$form .= "<input type='submit' onclick='popsubmit(this.form)'  >";
$form .= "</form>";

echo ($self);

if( $first_name and $last_name and $user_email and $zip)
{
  $conn = mysql_connect( "localhost", "username", "password" ) or die( "Err: Conn<br /><br />" . mysql_error() );

#select the specified database
 $rs = mysql_select_db( "dbname", $conn) or die( "Err: Db<br /><br />" . mysql_error() );

#create the query
 $sql = "insert into newsletter ( first_name, last_name, user_email, zip ) values ( '".$first_name."', '".$last_name."', '".$user_email."', '".$zip."' )";

#execute query
 $rs = mysql_query( $sql );

if( $rs )
 {
   echo( "<p class='style5'>Thank you ".$first_name . " " . $last_name.". Your address ".$user_email." has been added to our newsletter list. We respect your privacy. Your address will not be shared, sold or given away. Hit the back button to remove this message.</p>" );
 }
} else { echo $form; }

if( !$rs ) { echo ("<p class='style6'>Sign up for our free newsletter!</p>"); }
 
?>

</body>
</html>

Wouter Oet

Bartender

Posts: 2700

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Java != Javascript

You could try it here

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.

Jim Robson

Greenhorn

Posts: 2

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Oh... sorry.

David Newton

Author

Posts: 12617

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please read ItDoesntWorkIsUseless.

Maybe he went home and went to bed. And took this tiny ad with him:

free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth

https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter