[PHP-DB] Mailing List Question: Outlook Express
There doesn't seem to be a way to get a response from the mailing list owner (you just get an automated Hey are you stupid? response), so I'm posting this here. My appologies. Are there any plans to make your digests work with Outlook Express? Yes, I know it's old. Yes, I know it's broken. But the fact is, I (and a whole lot of other people) use it as their primary email client -- and I have yet to find one that works as well on Windows (including Thunderbird). Every other mailing list that I'm on sends the whole digest as one single text message. It's simple and it works in all email clients. Can you at least provide that as an option? I'd love to contribute to the list, but it makes it hard when you have to click each message as an attachment to read them. Jason
[PHP-DB] Mailing list installation error
Dear friends,
Mailing list installation is giving error,(Php, Mysql)
posted below are
error message
Script of subscribe and unsubscribe
script to send newsletter.
mysql table structure
Also is there any way I put check box on web page against each email, and
those which user or I check only newsletter will be send to those and code
needed
for same.
--
Error message
--
Warning: mysql_connect(): Access denied for user: ' @localhost' (Using
password: YES) in /home2/wwwabcde/public_html/manage.php on line 6
Access denied for user: ' @localhost' (Using password: YES)
--
Script code
--
?php
//set up a couple of functions
function doDB() {
global $conn;
//connect to server and select database; you may need it
$conn = mysql_connect(localhost, , ) or die(mysql_error());
mysql_select_db(wwwabcde_agbook1 ,$conn) or die(mysql_error());
}
function emailChecker($email) {
global $conn, $check_result;
//check that email is not already in list
$check = select id from subscribers where email = '$email';
$check_result = mysql_query($check,$conn) or die(mysql_error());
}
//determine if they need to see the form or not
if ($_POST[op] != ds) {
//they do, so create form block
$display_block =
form method=POST action=\$_SERVER[PHP_SELF]\
pstrongYour E-Mail Address:/strongbr
input type=text name=\email\ size=40 maxlength=150
pstrongAction:/strongbr
input type=radio name=\action\ value=\sub\ checked subscribe
input type=radio name=\action\ value=\unsub\ unsubscribe
input type=\hidden\ name=\op\ value=\ds\
pinput type=submit name=\submit\ value=\Submit Form\/p
/form;
} else if (($_POST[op] == ds) ($_POST[action] == sub)) {
//trying to subscribe; validate email address
if ($_POST[email] == ) {
header(Location: manage.php);
exit;
}
//connect to database
doDB();
//check that email is in list
emailChecker($_POST[email]);
//get number of results and do action
if (mysql_num_rows($check_result) 1) {
//add record
$sql = insert into subscribers values('', '$_POST[email]');
$result = mysql_query($sql,$conn) or die(mysql_error());
$display_block = PThanks for signing up!/P;
} else {
//print failure message
$display_block = PYou're already subscribed!/P;
}
} else if (($_POST[op] == ds) ($_POST[action] == unsub)) {
//trying to unsubscribe; validate email address
if ($_POST[email] == ) {
header(Location: manage.php);
exit;
}
//connect to database
doDB();
//check that email is in list
emailChecker($_POST[email]);
//get number of results and do action
if (mysql_num_rows($check_result) 1) {
//print failure message
$display_block = PCouldn't find your address!/P
PNo action was taken./P;
} else {
//unsubscribe the address
$id = mysql_result($check_result, 0, id);
$sql = delete from subscribers where id = '$id';
$result = mysql_query($sql,$conn) or die(mysql_error());
$display_block = PYou're unsubscribed!/p;
}
}
?
HTML
HEAD
TITLESubscribe/Unsubscribe/TITLE
/HEAD
BODY
h1Subscribe/Unsubscribe/h1
?php echo $display_block; ?
/BODY
/HTML
--
--
script which brings up user interface to send newsletter
--
?php
if ($_POST[op] != send) {
//haven't seen the form, so show it
print
HTML
HEAD
TITLESend a Newsletter/TITLE
/HEAD
BODY
h1Send a Newsletter/h1
form method=\post\ action=\$_SERVER[PHP_SELF]\
PstrongSubject:/strongbr
input type=\text\ name=\subject\ size=30/p
PstrongMail Body:/strongbr
textarea name=\message\ cols=50 rows=10 wrap=virtual/textarea
input type=\hidden\ name=\op\ value=\send\
pinput type=\submit\ name=\submit\ value=\Send It\/p
/FORM
/BODY
/HTML;
} else if ($_POST[op] == send) {
//want to send form, so check for required fields
if (($_POST[subject] ==) || ($_POST[message] == )) {
header(Location: sendmymail.php);
exit;
}
//connect to database
$conn = mysql_connect(localhost, asifqureshi, asif) or
die(mysql_error());
mysql_select_db(wwwabcde_agbook1 ,$conn) or die(mysql_error());
//get emails from subscribers list
$sql = select email from subscribers;
$result = mysql_query($sql,$conn) or die(mysql_error());
//create a From: mailheader
$headers = From: Your Mailing List [EMAIL PROTECTED]\n;
//loop through results and send mail
while ($row = mysql_fetch_array($result)) {
set_time_limit(0);
$email = $row['email'];
mail($email, stripslashes($_POST[subject]),
stripslashes($_POST[message]), $headers);
[PHP-DB] MAILING LIST
Dear Friends, Mailing list isn't able to send email using local host. manipulated ini file didn't fix issue Any guidance, please. - Following is the error -- Warning: mail(): Failed to connect to mailserver at localhost port 25, verify your SMTP and smtp_port setting in php.ini or use ini_set() in C:\HOME\doctorbush\sendmymail.php on line 44 newsletter sent to: [EMAIL PROTECTED] Warning: mail(): Failed to connect to mailserver at localhost port 25, verify your SMTP and smtp_port setting in php.ini or use ini_set() in C:\HOME\doctorbush\sendmymail.php on line 44 newsletter sent to: [EMAIL PROTECTED] Warning: mail(): Failed to connect to mailserver at localhost port 25, verify your SMTP and smtp_port setting in php.ini or use ini_set() in C:\HOME\doctorbush\sendmymail.php on line 44 newsletter sent to: [EMAIL PROTECTED]
[PHP-DB] MAILING LIST QUESTION
Dear Friends,
I am getting error while sending email newsletter from local host using
mailing list application.
Its mentioning
verify your SMTP and smtp_port setting in php.ini or use ini_set() in
Setting of php.ini file I have posted.
Any guidance, please.
error I am receiving
---
Warning: mail(): Failed to connect to mailserver at localhost port 25,
verify your SMTP and smtp_port setting in php.ini or use ini_set() in
C:\HOME\doctorbush\sendmymail.php on line 44
newsletter sent to: [EMAIL PROTECTED]
Warning: mail(): Failed to connect to mailserver at localhost port 25,
verify your SMTP and smtp_port setting in php.ini or use ini_set() in
C:\HOME\doctorbush\sendmymail.php on line 44
newsletter sent to: [EMAIL PROTECTED]
---
code of form which I use to send newsletter
?php
if ($_POST[op] != send) {
//haven't seen the form, so show it
print
HTML
HEAD
TITLESend a Newsletter/TITLE
/HEAD
BODY
h1Send a Newsletter/h1
form method=\post\ action=\$_SERVER[PHP_SELF]\
PstrongSubject:/strongbr
input type=\text\ name=\subject\ size=30/p
PstrongMail Body:/strongbr
textarea name=\message\ cols=50 rows=10 wrap=virtual/textarea
input type=\hidden\ name=\op\ value=\send\
pinput type=\submit\ name=\submit\ value=\Send It\/p
/FORM
/BODY
/HTML;
} else if ($_POST[op] == send) {
//want to send form, so check for required fields
if (($_POST[subject] ==) || ($_POST[message] == )) {
header(Location: sendmymail.php);
exit;
}
//connect to database
$conn = mysql_connect(localhost, , ) or die(mysql_error());
mysql_select_db(b,$conn) or die(mysql_error());
//get emails from subscribers list
$sql = select email from subscribers1;
$result = mysql_query($sql,$conn) or die(mysql_error());
//create a From: mailheader
$headers = From: Your Mailing List [EMAIL PROTECTED]\n;
//loop through results and send mail
while ($row = mysql_fetch_array($result)) {
set_time_limit(0);
$email = $row['email'];
mail($email, stripslashes($_POST[subject]),
stripslashes($_POST[message]), $headers);
print newsletter sent to: $emailbr;
}
}
?
--
--
php ini file setting
-
[PHP]
;;;
; WARNING ;
;;;
; This is the default settings file for new PHP installations.
; By default, PHP installs itself with a configuration suitable for
; development purposes, and *NOT* for production purposes.
; For several security-oriented considerations that should be taken
; before going online with your site, please consult php.ini-recommended
; and http://php.net/manual/en/security.php.
;;;
; About this file ;
;;;
; This file controls many aspects of PHP's behavior. In order for PHP to
; read it, it must be named 'php.ini'. PHP looks for it in the current
; working directory, in the path designated by the environment variable
; PHPRC, and in the path that was defined in compile time (in that order).
; Under Windows, the compile-time path is the Windows directory. The
; path in which the php.ini file is looked for can be overridden using
; the -c argument in command line mode.
;
; The syntax of the file is extremely simple. Whitespace and Lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.
;
; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
;
; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI),
one
; of the INI constants (On, Off, True, False, Yes, No and None) or an
expression
; (e.g. E_ALL ~E_NOTICE), or a quoted string (foo).
;
; Expressions in the INI file are limited to bitwise operators and
parentheses:
; |bitwise OR
; bitwise AND
; ~bitwise NOT
; !boolean NOT
;
; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.
;
; An empty string can be denoted by simply not writing anything after the
equal
; sign, or by using the None keyword:
;
; foo = ; sets foo to an empty string
; foo = none; sets foo to an empty string
; foo = none ; sets foo to the string 'none'
;
; If you use constants in your value, and these constants belong to a
; dynamically loaded extension (either a PHP extension or a Zend extension),
; you may only use these constants *after* the line that loads the extension.
;
; All the values in the php.ini-dist file correspond to the
Re: [PHP-DB] MAILING LIST QUESTION
Sounds like your mailserver isn't running. Have you verified that the
SMTP is running on the local machine? Easy way to verify is open up a
terminal type program and try to connect to localhost 25.
On Mon, 16 Aug 2004 21:55:50 EDT, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Dear Friends,
I am getting error while sending email newsletter from local host using
mailing list application.
Its mentioning
verify your SMTP and smtp_port setting in php.ini or use ini_set() in
Setting of php.ini file I have posted.
Any guidance, please.
error I am receiving
---
Warning: mail(): Failed to connect to mailserver at localhost port 25,
verify your SMTP and smtp_port setting in php.ini or use ini_set() in
C:\HOME\doctorbush\sendmymail.php on line 44
newsletter sent to: [EMAIL PROTECTED]
Warning: mail(): Failed to connect to mailserver at localhost port 25,
verify your SMTP and smtp_port setting in php.ini or use ini_set() in
C:\HOME\doctorbush\sendmymail.php on line 44
newsletter sent to: [EMAIL PROTECTED]
---
code of form which I use to send newsletter
?php
if ($_POST[op] != send) {
//haven't seen the form, so show it
print
HTML
HEAD
TITLESend a Newsletter/TITLE
/HEAD
BODY
h1Send a Newsletter/h1
form method=\post\ action=\$_SERVER[PHP_SELF]\
PstrongSubject:/strongbr
input type=\text\ name=\subject\ size=30/p
PstrongMail Body:/strongbr
textarea name=\message\ cols=50 rows=10 wrap=virtual/textarea
input type=\hidden\ name=\op\ value=\send\
pinput type=\submit\ name=\submit\ value=\Send It\/p
/FORM
/BODY
/HTML;
} else if ($_POST[op] == send) {
//want to send form, so check for required fields
if (($_POST[subject] ==) || ($_POST[message] == )) {
header(Location: sendmymail.php);
exit;
}
//connect to database
$conn = mysql_connect(localhost, , ) or die(mysql_error());
mysql_select_db(b,$conn) or die(mysql_error());
//get emails from subscribers list
$sql = select email from subscribers1;
$result = mysql_query($sql,$conn) or die(mysql_error());
//create a From: mailheader
$headers = From: Your Mailing List [EMAIL PROTECTED]\n;
//loop through results and send mail
while ($row = mysql_fetch_array($result)) {
set_time_limit(0);
$email = $row['email'];
mail($email, stripslashes($_POST[subject]),
stripslashes($_POST[message]), $headers);
print newsletter sent to: $emailbr;
}
}
?
--
--
php ini file setting
-
[PHP]
;;;
; WARNING ;
;;;
; This is the default settings file for new PHP installations.
; By default, PHP installs itself with a configuration suitable for
; development purposes, and *NOT* for production purposes.
; For several security-oriented considerations that should be taken
; before going online with your site, please consult php.ini-recommended
; and http://php.net/manual/en/security.php.
;;;
; About this file ;
;;;
; This file controls many aspects of PHP's behavior. In order for PHP to
; read it, it must be named 'php.ini'. PHP looks for it in the current
; working directory, in the path designated by the environment variable
; PHPRC, and in the path that was defined in compile time (in that order).
; Under Windows, the compile-time path is the Windows directory. The
; path in which the php.ini file is looked for can be overridden using
; the -c argument in command line mode.
;
; The syntax of the file is extremely simple. Whitespace and Lines
; beginning with a semicolon are silently ignored (as you probably guessed).
; Section headers (e.g. [Foo]) are also silently ignored, even though
; they might mean something in the future.
;
; Directives are specified using the following syntax:
; directive = value
; Directive names are *case sensitive* - foo=bar is different from FOO=bar.
;
; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI),
one
; of the INI constants (On, Off, True, False, Yes, No and None) or an
expression
; (e.g. E_ALL ~E_NOTICE), or a quoted string (foo).
;
; Expressions in the INI file are limited to bitwise operators and
parentheses:
; |bitwise OR
; bitwise AND
; ~bitwise NOT
; !boolean NOT
;
; Boolean flags can be turned on using the values 1, On, True or Yes.
; They can be turned off using the values 0, Off, False or No.
;
; An empty string can be denoted by simply not writing anything after the
equal
; sign, or by using the None keyword:
;
; foo = ; sets foo to an
Re: [PHP-DB] MAILING LIST QUESTION
I don't have smtp server running on my computer. Any suggestions for smtp server, please.
RE: [PHP-DB] MAILING LIST QUESTION
-Original Message- I don't have smtp server running on my computer. Any suggestions for smtp server, please. Those settings will depend entirely on your Internet Service Provider. You'll need to call them and ask what you'd use for your outgoing SMTP server for sending email. -Ed -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP-DB Mailing list problem
Hi. Every time I post a new message or reply to a message to this mailing list, an e-mail is sent to me from Mailer-Daemon and says which follows: Sorry. Your message could not be delivered to: mailing list (Mailbox or Conference is full.) Can you see this message? please tell me in order to leave it this way or maybe re-suscribe to the list. Thanx. Cesar Aracena [EMAIL PROTECTED] Neuquen, Argentina
