RE: [PHP-DB] MS Access, FoxPro and PHP
Robert, I can not help directly but until you get a helpful response here you could try a Google Groups search. http://groups.google.com/groups?safe=images&ie=UTF-8&oe=UTF-8&as_ugroup=*access*&as_usubject=php%20odbc&lr=&hl=en Go to http://groups.google.com click on Advanced search for Newsgroup enter: *access* Subject enter: php odbc howard grämer New York City [EMAIL PROTECTED] From: Robert Twitty <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] MS Access, FoxPro and PHP Date: Tue, 2 Dec 2003 09:55:08 -0500 (EST) Is anyone using MS Access, FoxPro or any other file-based database via ODBC with PHP? -- bob _ Share holiday photos without swamping your Inbox. Get MSN Extra Storage now! http://join.msn.com/?PAGE=features/es -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: send email
Oh, oh, oh. All is clear now. I did not realize you were talking about the PHP on the page. Thanks a lot for clarifying. Now, anyone, how do you put the code in a config file? I know how to use/configure the FormMail.conf file on my host/server. But to access the file I had to use FormMail.pl in my php code. - Original Message - From: "Jacob A. van Zanen" <[EMAIL PROTECTED]> To: "'howard gramer'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 2:36 AM Subject: RE: [PHP-DB] Re: send email Hi This is PHP code and will be parsed by the webserver before being send out to the browser. All that is displayed in the browser is the non PHP stuff. So the email address is in the source code of the php page but when you click 'view source' in your browser you won't see it. Jack -Original Message- From: howard gramer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 7:57 PM To: Jack van Zanen Prive Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: send email Sorry, I don't understand. I thought the code that you posted was what goes in the HTML page; meaning I thought it was php code. Where does the source code sit? howard grämer New York City [EMAIL PROTECTED] >From: "Jack van Zanen" <[EMAIL PROTECTED]> >To: "howard gramer" <[EMAIL PROTECTED]> >CC: "Php-Db" <[EMAIL PROTECTED]> >Subject: RE: [PHP-DB] Re: send email >Date: Tue, 25 Nov 2003 23:24:43 +0100 > >Hi > > >my example earlier does not show the email address in the source of >the displayed web page. It is in the source code, but you can change >that to be put in a config file >and include this file in the script. > > >Jack > >-Original Message- >From: howard gramer [mailto:[EMAIL PROTECTED] >Sent: dinsdag 25 november 2003 21:09 >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Re: [PHP-DB] Re: send email > > >I am in the same boat, >( I posted a couple of days ago Subject: Re: [PHP-DB] Send formmail >data to Email and Database ), not knowing where to put the Mail() into >my own code. I am working on it but no success yet. > >But, my real question in this topic; with formmail.pl using Sendmail >your able to use "recipients_alias = [EMAIL PROTECTED]" inside of the >FormMail.conf file. So this means you can hide the email address in >the configuration file without it being seen in the page source. > >How do you accomplish the same with Mail()? i.e. hiding the email -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: send email
Sorry, I don't understand. I thought the code that you posted was what goes in the HTML page; meaning I thought it was php code. Where does the source code sit? howard grämer New York City [EMAIL PROTECTED] From: "Jack van Zanen" <[EMAIL PROTECTED]> To: "howard gramer" <[EMAIL PROTECTED]> CC: "Php-Db" <[EMAIL PROTECTED]> Subject: RE: [PHP-DB] Re: send email Date: Tue, 25 Nov 2003 23:24:43 +0100 Hi my example earlier does not show the email address in the source of the displayed web page. It is in the source code, but you can change that to be put in a config file and include this file in the script. Jack -Original Message- From: howard gramer [mailto:[EMAIL PROTECTED] Sent: dinsdag 25 november 2003 21:09 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: send email I am in the same boat, ( I posted a couple of days ago Subject: Re: [PHP-DB] Send formmail data to Email and Database ), not knowing where to put the Mail() into my own code. I am working on it but no success yet. But, my real question in this topic; with formmail.pl using Sendmail your able to use "recipients_alias = [EMAIL PROTECTED]" inside of the FormMail.conf file. So this means you can hide the email address in the configuration file without it being seen in the page source. How do you accomplish the same with Mail()? i.e. hiding the email howard grämer New York City [EMAIL PROTECTED] >From: "Kim Steinhaug" <[EMAIL PROTECTED]> >Reply-To: "Kim Steinhaug" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: [PHP-DB] Re: send email >Date: Tue, 25 Nov 2003 19:57:44 +0100 > >Well this shouldnt be any problem. I suspect you dont >know how to set up the email routine since your asking. > >All you need to do is insert a sendmail script together with the >update of the mySQL database. You could use PHPs internal >functions for this, but Ill recommend you using PHPmailer which >is heavily documentet with tons of examples on how to use. > >The PHPmailer is located at sourceforge and you should find it >right away. It has to be the most elegant way I know of sending >emails from PHP scripts. > >And as a bonus, the PHPmailer is under active development so >you will most likely never run into problems using it, :) > >-- >Kim Steinhaug >--- >There are 10 types of people when it comes to binary numbers: >those who understand them, and those who don't. >--- > > >"Redhat" <[EMAIL PROTECTED]> wrote in message >news:[EMAIL PROTECTED] > > I have created a simple form that dumps input information into a mysql > > database. The person that I created it for said it would be nice if it > > would also notify him by email that an entry was added to the database. > > I have no idea where to begin with that - any ideas? > > thanks, > > DF _ Set yourself up for fun at home! Get tips on home entertainment equipment, video game reviews, and more here. http://special.msn.com/home/homeent.armx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: send email
I am in the same boat, ( I posted a couple of days ago Subject: Re: [PHP-DB] Send formmail data to Email and Database ), not knowing where to put the Mail() into my own code. I am working on it but no success yet. But, my real question in this topic; with formmail.pl using Sendmail your able to use "recipients_alias = [EMAIL PROTECTED]" inside of the FormMail.conf file. So this means you can hide the email address in the configuration file without it being seen in the page source. How do you accomplish the same with Mail()? i.e. hiding the email howard grämer New York City [EMAIL PROTECTED] From: "Kim Steinhaug" <[EMAIL PROTECTED]> Reply-To: "Kim Steinhaug" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: send email Date: Tue, 25 Nov 2003 19:57:44 +0100 Well this shouldnt be any problem. I suspect you dont know how to set up the email routine since your asking. All you need to do is insert a sendmail script together with the update of the mySQL database. You could use PHPs internal functions for this, but Ill recommend you using PHPmailer which is heavily documentet with tons of examples on how to use. The PHPmailer is located at sourceforge and you should find it right away. It has to be the most elegant way I know of sending emails from PHP scripts. And as a bonus, the PHPmailer is under active development so you will most likely never run into problems using it, :) -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. --- "Redhat" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have created a simple form that dumps input information into a mysql > database. The person that I created it for said it would be nice if it > would also notify him by email that an entry was added to the database. > I have no idea where to begin with that - any ideas? > thanks, > DF _ online games and music with a high-speed Internet connection! Prices start at less than $1 a day average. https://broadband.msn.com (Prices may vary by service area.) -- 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
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--
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));
}
?>
Customer Service
<br>
<!--<br>
function MM_swapImgRestore() { //v3.0<br>
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++)
x.src=x.oSrc;<br>
}</tt><br>
<br>
<tt>function MM_preloadImages() { //v3.0<br>
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();<br>
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length;
i++)<br>
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}<br>
}</tt><br>
<br>
<tt>function MM_findObj(n, d) { //v4.01<br>
var p,i,x; if(!d) d=document;
if((p=n.indexOf("?"))>0&&parent.frames.length) {<br>
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}<br>
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++)
x=d.forms[i][n];<br>
for(i=0;!x&&d.layers&&i<d.layers.length;i++)
x=MM_findObj(n,d.layers[i].document);<br>
if(!x && d.getElementById) x=d.getElementById(n); return x;<br>
}</tt><br>
<br>
<tt>function MM_swapImage() { //v3.0<br>
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array;
for(i=0;i<(a.length-2);i+=3)<br>
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc)
x.oSrc=x.src; x.src=a[i+2];}<br>
}<br>
//--><br>
The
International Car Rental Specialists
Customer
Service
We value your comments and questions.
Please
fill out the form below and we'll be sure to answer as quick as
possible.
http://www.friendlyhousebuyers.com/cgi-sys/formmail.pl";
method="POST">
First Name
Last Name
Email Address
Comments
Enter your
comments
end--
howard grämer
New York City
[EMAIL PROTECTED]
From: Neil Smth <[EMAIL P
[PHP-DB] 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? Here is some of the code: http://www.mysite.com/cgi-sys/formmail.pl"; method="POST"> First Name Last Name howard grämer New York City [EMAIL PROTECTED] _ Need a shot of Hank Williams or Patsy Cline? The classic country stars are always singing on MSN Radio Plus. Try one month free! http://join.msn.com/?page=offers/premiumradio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
