Re: [PHP-DB] Re: Send formmail data to Email and Database

howard gramer Mon, 24 Nov 2003 06:16:57 -0800

What a sweet way to greet someone on their first post! Nice to meet you too! Some lists want code off the bat and some do not! Now I know it's ok to post it without it being requested.

------------------begin---------------------- <?php require_once('Connections/connGlobal.php'); ?> <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; }

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
 $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO comments (FIRST_NAME, LAST_NAME, EMAIL, COMMENTS) VALUES (%s, %s, %s, %s)", GetSQLValueString($HTTP_POST_VARS['FIRST_NAME'], "text"), GetSQLValueString($HTTP_POST_VARS['LAST_NAME'], "text"), GetSQLValueString($HTTP_POST_VARS['EMAIL'], "text"), GetSQLValueString($HTTP_POST_VARS['COMMENTS'], "text"));

 mysql_select_db($database_connGlobal, $connGlobal);
 $Result1 = mysql_query($insertSQL, $connGlobal) or die(mysql_error());

 $insertGoTo = "insertOK.php";
 if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
   $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
   $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
 }
 header(sprintf("Location: %s", $insertGoTo));
}
?>
<html>

<head> <title>Customer Service</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript">  </script> <link href="Assets/master.css" rel="stylesheet" type="text/css"> </head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('Assets/images/btnCustomerService_on.jpg','Assets/images/btnLocations_on.jpg','Assets/images/btnHome_on.jpg')"> <table width="100%" border="0" cellspacing="0" cellpadding="4"> <tr> <td rowspan="2" bgcolor="#424973"><img src="Assets/images/logo.jpg" alt="Logo" width="235" height="48"></td> <td width="100%" bgcolor="#424973"><div align="right"><font color="#FFFFFF"><b>The International Car Rental Specialists</b></font></div></td> </tr> <tr> <td> <table width="100%" border="0" cellspacing="1" cellpadding="2"> <tr> <td align="center" width="20%" bgcolor="#424973"><a href="index.htm" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('menu1','','Assets/images/btnHome_on.jpg',1)"><img src="Assets/images/btnHome.jpg" alt="Home Button" name="menu1" width="90" height="25" border="0"></a></td> <td align="center" width="20%" bgcolor="#424973"><a href="customerService.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('menu2','','Assets/images/btnCustomerService_on.jpg',1)"><img src="Assets/images/btnCustomerService.jpg" alt="Customer Service Button" name="menu2" width="110" height="25" border="0"></a></td> <td align="center" width="20%" bgcolor="#424973"><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('menu3','','Assets/images/btnLocations_on.jpg',1)"><img src="Assets/images/btnLocations.jpg" alt="Locations Button" name="menu3" width="90" height="25" border="0"></a></td> </tr> </table></td> </tr> </table> <br>

<table width="841" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="618" height="35" valign="top"> <FONT SIZE="+2" COLOR="#FF6600">Customer Service</FONT></td> <td rowspan="3" width="223" align="right" valign="top">  </td> </tr> <tr> <td height="405" valign="top"><p>We value your comments and questions. Please fill out the form below and we'll be sure to answer as quick as possible.</p>

<form action="http://www.friendlyhousebuyers.com/cgi-sys/formmail.pl"; method="POST"> <form method="post" name="form1" action="<?php echo $editFormAction; ?>"> <table align="center"> <tr valign="baseline"> <td nowrap align="right">First Name</td> <td><input type="text" name="FIRST_NAME" value="Enter your first name" size="32"> </td> </tr> <tr valign="baseline"> <td nowrap align="right">Last Name</td> <td><input type="text" name="LAST_NAME" value="Enter your last name" size="32"> </td> </tr> <tr valign="baseline"> <td nowrap align="right">Email Address</td> <td><input type="text" name="EMAIL" value="Enter your email address" size="32"> </td> </tr> <tr valign="baseline"> <td height="81" align="right" nowrap>Comments</td> <td><textarea name="COMMENTS" cols="32">Enter your comments</textarea> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input type="submit" value="Insert Record"> </td> </tr> </table> <input type="hidden" name="MM_insert" value="form1" /> <input type="hidden" name="recipient" value="animals" /> </form> <p> </p> <p> </p> <p> </p> <p> </p>


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

----------------end--------------------------


howard grämer
 New York City
  [EMAIL PROTECTED]

From: Neil Smth <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Send formmail data to Email and Database
Date: Mon, 24 Nov 2003 08:28:25 +0000
Since you didn't feel it necessary to include your form processing code, and as we're not mind readers, we are unable to help you. Sorry, better luck next time.

Cheers - Neil.

At 07:57 24/11/2003 +0000, you wrote:
  PHP List stats since 1997:
    http://zirzow.dyndns.org/html/mlists/
From: "howard gramer" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Sun, 23 Nov 2003 18:49:23 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <[EMAIL PROTECTED]>
Subject: Send formmail data to Email and Database
(newbie alert!)
DWMX, Host: PHP, MySQL, Sendmail, and my own Cgi-Bin
I had the database action working well. But then trying to get the email to work I had to switch their positions in the code. Email now on top and database on bottom. So now the database action is not activated.

How can I get the form data to post to the email and the database?

_________________________________________________________________ Is there a gadget-lover on your gift list? MSN Shopping has lined up some good bets! http://shopping.msn.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Send formmail data to Email and Database

Reply via email to