php-general Digest 28 Jun 2010 12:44:14 -0000 Issue 6820
Topics (messages 306470 through 306474):
Re: mysql case statement
306470 by: Brandon Rampersad
Re: Attachment to email from form.
306471 by: Richard Quadling
306473 by: Gary
306474 by: Brandon Rampersad
Re: Problem with SOAP and authentication? SoapFault exception: [HTTP]
Unauthorized
306472 by: Richard Quadling
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
no
On Sun, Jun 27, 2010 at 8:29 PM, David McGlone <da...@dmcentral.net> wrote:
> On Sunday 27 June 2010 04:08:24 Tanel Tammik wrote:
> > Hello,
> >
> > how to select only if value is present?
> >
> > $query = $db->query("select menus.id, menus.name,
> > case
> > when panels.id is not null then '1'
> > end as hiddenpanel
> >
> > from " . \DB_MENUS . " as menus
> > left join " . \DB_HIDDENPANELS . " as panels on (menus.id =
> > panels.menu_id)
> > where menus.id='" . (int)$id . "'
> > ");
> >
> > i would like to select hiddenpanel only if there is a corresponding value
> > in DB_HIDDENPANELS. At the moment i get NULL if there is no
> corresponding
> > value in HIDDENPANELS table!
>
> I would use an if statement since you only need to determine true or false.
> Something like:
>
> $query = $db->query("select menus.id, menus.name,
> from " . \DB_MENUS . " as menus
> left join " . \DB_HIDDENPANELS . " as panels on (menus.id =
> panels.menu_id)
> where menus.id='" . (int)$id . "'
> ");
>
> if (empty(DB_HIDDENPANELS)) {
> echo "";
>
> }
>
> else {
> echo "hiddenpanel";
>
> }
>
> But I would wait for others to chime in on this one, because I'm very far
> from
> an expert, there's also got to be a much better efficient way to write the
> if
> statement above, but it's what I would do in a case like this until I found
> a
> better way.
>
> --
> Blessings,
> David M.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
A Brandon_R Production
--- End Message ---
--- Begin Message ---
On 26 June 2010 13:14, Gary <gp...@paulgdesigns.com> wrote:
> Richard
>
> Please accept my apology in that my response was sent directly to you and
> not the group, I hit 'Reply" instead of 'Reply to Group'.
>
> Gary
No problem.
Here is an example of my code using the RMail script from phpguru.org.
It was previously known as html_mime_mail5.
<?php
// Create a new message.
$o_Mail = new RMail();
// As we are going to use SMTP to send the email, we need to know
where to send it.
// On my setup, the SMTP ini setting is what I'll be using.
// You can also supply any SMTP AUTH settings needed here.
$o_Mail->setSMTPParams
(
ini_get('SMTP'),
25,
Null,
registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_LOGIN_REQUIRED),
registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_LOGIN),
registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_PASSWORD)
);
// Set the From header
$o_Mail->setHeader('From', '"Richard Quadling" <r...@nowhere.co.uk>');
// Some other useful headers.
// $o_Mail->setHeader('Return-Path', '"Return to me"
<returnt...@nowhere.co.uk>');
// $o_Mail->setHeader('Return-Receipt-To', '"Delivery Receipt"
<deliveryconfirmati...@nowhere.co.uk>');
// $o_Mail->setHeader('Disposition-Notification-To', '"Read or Delete
Notification" <disposit...@nowhere.co.uk>');
// Add the subject.
$o_Mail->setSubject($s_Subject);
// Add the HTML with a location of the images to be added to the email
automatically, rather than relying on internet to provide images
// which is blocked by various security levels of Outlook.
$o_Mail->setHTML($s_HTMLMessage, 'D:/Global Web Documents/images/');
// Let's add an attachment.
// The filename, the mime type, the encoding and the file name to show
the attachment as.
$o_Mail->addAttachment(new fileAttachment('D:/Uploaded/content.zip',
'application/zip', new Base64Encoding(), 'YourContent.zip'));
// If you want to keep copies of your emails, then setCc is the method to use.
$o_Mail->setCc('r...@nowhere.co.uk');
// Finally, send the email to the recipients (held in an array to
allow for multiple addresses) using SMTP.
$o_Mail->send(array('"Your recipient\'s name"
<your_recipient_em...@domain.com>'), 'smtp');
?>
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
--- Begin Message ---
Richard
Thank you again for your kind help.
Gary
"Richard Quadling" <rquadl...@gmail.com> wrote in message
news:aanlktikwujmpbqijd_ee9mbfpxa92ssexjddng2fg...@mail.gmail.com...
> On 26 June 2010 13:14, Gary <gp...@paulgdesigns.com> wrote:
>> Richard
>>
>> Please accept my apology in that my response was sent directly to you and
>> not the group, I hit 'Reply" instead of 'Reply to Group'.
>>
>> Gary
>
> No problem.
>
> Here is an example of my code using the RMail script from phpguru.org.
> It was previously known as html_mime_mail5.
>
> <?php
> // Create a new message.
> $o_Mail = new RMail();
>
> // As we are going to use SMTP to send the email, we need to know
> where to send it.
> // On my setup, the SMTP ini setting is what I'll be using.
> // You can also supply any SMTP AUTH settings needed here.
> $o_Mail->setSMTPParams
> (
> ini_get('SMTP'),
> 25,
> Null,
> registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_LOGIN_REQUIRED),
> registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_LOGIN),
> registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_PASSWORD)
> );
>
>
> // Set the From header
> $o_Mail->setHeader('From', '"Richard Quadling" <r...@nowhere.co.uk>');
>
> // Some other useful headers.
> // $o_Mail->setHeader('Return-Path', '"Return to me"
> <returnt...@nowhere.co.uk>');
> // $o_Mail->setHeader('Return-Receipt-To', '"Delivery Receipt"
> <deliveryconfirmati...@nowhere.co.uk>');
> // $o_Mail->setHeader('Disposition-Notification-To', '"Read or Delete
> Notification" <disposit...@nowhere.co.uk>');
>
> // Add the subject.
> $o_Mail->setSubject($s_Subject);
>
> // Add the HTML with a location of the images to be added to the email
> automatically, rather than relying on internet to provide images
> // which is blocked by various security levels of Outlook.
> $o_Mail->setHTML($s_HTMLMessage, 'D:/Global Web Documents/images/');
>
> // Let's add an attachment.
> // The filename, the mime type, the encoding and the file name to show
> the attachment as.
> $o_Mail->addAttachment(new fileAttachment('D:/Uploaded/content.zip',
> 'application/zip', new Base64Encoding(), 'YourContent.zip'));
>
> // If you want to keep copies of your emails, then setCc is the method to
> use.
> $o_Mail->setCc('r...@nowhere.co.uk');
>
> // Finally, send the email to the recipients (held in an array to
> allow for multiple addresses) using SMTP.
> $o_Mail->send(array('"Your recipient\'s name"
> <your_recipient_em...@domain.com>'), 'smtp');
> ?>
>
>
> --
> -----
> Richard Quadling
> "Standing on the shoulders of some very clever giants!"
> EE : http://www.experts-exchange.com/M_248814.html
> EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
> Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
> ZOPA : http://uk.zopa.com/member/RQuadling
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5233 (20100628) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
__________ Information from ESET Smart Security, version of virus signature
database 5233 (20100628) __________
The message was checked by ESET Smart Security.
http://www.eset.com
--- End Message ---
--- Begin Message ---
fuck no
On Mon, Jun 28, 2010 at 8:23 AM, Gary <gp...@paulgdesigns.com> wrote:
> Richard
>
> Thank you again for your kind help.
>
> Gary
>
>
> "Richard Quadling" <rquadl...@gmail.com> wrote in message
> news:aanlktikwujmpbqijd_ee9mbfpxa92ssexjddng2fg...@mail.gmail.com...
> > On 26 June 2010 13:14, Gary <gp...@paulgdesigns.com> wrote:
> >> Richard
> >>
> >> Please accept my apology in that my response was sent directly to you
> and
> >> not the group, I hit 'Reply" instead of 'Reply to Group'.
> >>
> >> Gary
> >
> > No problem.
> >
> > Here is an example of my code using the RMail script from phpguru.org.
> > It was previously known as html_mime_mail5.
> >
> > <?php
> > // Create a new message.
> > $o_Mail = new RMail();
> >
> > // As we are going to use SMTP to send the email, we need to know
> > where to send it.
> > // On my setup, the SMTP ini setting is what I'll be using.
> > // You can also supply any SMTP AUTH settings needed here.
> > $o_Mail->setSMTPParams
> > (
> > ini_get('SMTP'),
> > 25,
> > Null,
> >
> registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_LOGIN_REQUIRED),
> > registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_LOGIN),
> > registrySettings_V2::read(registrySettings_V2::REG_SMTP_AUTH_PASSWORD)
> > );
> >
> >
> > // Set the From header
> > $o_Mail->setHeader('From', '"Richard Quadling" <r...@nowhere.co.uk>');
> >
> > // Some other useful headers.
> > // $o_Mail->setHeader('Return-Path', '"Return to me"
> > <returnt...@nowhere.co.uk>');
> > // $o_Mail->setHeader('Return-Receipt-To', '"Delivery Receipt"
> > <deliveryconfirmati...@nowhere.co.uk>');
> > // $o_Mail->setHeader('Disposition-Notification-To', '"Read or Delete
> > Notification" <disposit...@nowhere.co.uk>');
> >
> > // Add the subject.
> > $o_Mail->setSubject($s_Subject);
> >
> > // Add the HTML with a location of the images to be added to the email
> > automatically, rather than relying on internet to provide images
> > // which is blocked by various security levels of Outlook.
> > $o_Mail->setHTML($s_HTMLMessage, 'D:/Global Web Documents/images/');
> >
> > // Let's add an attachment.
> > // The filename, the mime type, the encoding and the file name to show
> > the attachment as.
> > $o_Mail->addAttachment(new fileAttachment('D:/Uploaded/content.zip',
> > 'application/zip', new Base64Encoding(), 'YourContent.zip'));
> >
> > // If you want to keep copies of your emails, then setCc is the method to
> > use.
> > $o_Mail->setCc('r...@nowhere.co.uk');
> >
> > // Finally, send the email to the recipients (held in an array to
> > allow for multiple addresses) using SMTP.
> > $o_Mail->send(array('"Your recipient\'s name"
> > <your_recipient_em...@domain.com>'), 'smtp');
> > ?>
> >
> >
> > --
> > -----
> > Richard Quadling
> > "Standing on the shoulders of some very clever giants!"
> > EE : http://www.experts-exchange.com/M_248814.html
> > EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
> > Zend Certified Engineer :
> http://zend.com/zce.php?c=ZEND002498&r=213474731
> > ZOPA : http://uk.zopa.com/member/RQuadling
> >
> > __________ Information from ESET Smart Security, version of virus
> > signature database 5233 (20100628) __________
> >
> > The message was checked by ESET Smart Security.
> >
> > http://www.eset.com
> >
> >
> >
>
>
>
> __________ Information from ESET Smart Security, version of virus signature
> database 5233 (20100628) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
A Brandon_R Production
--- End Message ---
--- Begin Message ---
On 26 June 2010 23:46, robert mena <robert.m...@gmail.com> wrote:
> Hi,
>
> I am trying to access a webservice using php's soapclient but I keep getting
> the error SoapFault exception: [HTTP] Unauthorized
>
> If I try using a web browser I can authenticate using the same credentials
> used by the php code.
>
> I've searched but the only mention that I found led to a 'won't fix' bug
> registered to php 5.1.6. I am using 5.2.10.
>
> Any ideas of what may be causing this? Is there a workaround?
>
> Regards.
>
Can you show the SoapClient construction you are using?
The documentation says that you can supply HTTP authentication [1] ...
"For HTTP authentication, the login and password options can be used
to supply credentials. For making an HTTP connection through a proxy
server, the options proxy_host, proxy_port, proxy_login and
proxy_password are also available. For HTTPS client certificate
authentication use local_cert and passphrase options. An
authentication may be supplied in the authentication option. The
authentication method may be either SOAP_AUTHENTICATION_BASIC
(default) or SOAP_AUTHENTICATION_DIGEST."
There was recent activity on a Soap Authorisation Header bug [2].
If this issue is appropriate, you can try a building your code code
from SVN (no win32 snapshots for a LONG time now).
Regards,
Richard.
[1] http://docs.php.net/manual/en/soapclient.soapclient.php
[2] http://bugs.php.net/bug.php?id=50976
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
