php-windows Digest 7 Feb 2007 17:08:47 -0000 Issue 3134
Topics (messages 27461 through 27462):
Re: SSL on Windows Server 2003
27461 by: bedul
27462 by: Frank M. Kromann
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
sry i don't understand what writen here
let me repair
----- Original Message -----
From: "Gustav Wiberg" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, February 06, 2007 9:39 PM
Subject: RE: [PHP-WIN] SSL on Windows Server 2003
Hi there guys!
Do you know any way of getting NEXT row based on a specific ID in db?
<?php
$thisRow = $_GET["thisrow"];
$thisID = $_GET["thisID"];
//Get next row (With ID and sortorder-nr from db
//
$sql2 = "SELECT IDPrice, sortOrder FROM tbprices WHERE sortOrder>" . $db ->
safeQuote($thisRow);
$dbArray = $db -> makeArray($sql2);
$dbNextSortOrder = $dbArray["sortOrder"];
$dbNextIDPrice = $dbArray["IDPrice"];
I can't have sortorder> (larger than) BECAUSE the sortorder don't have to be
larger in the actual table. Of course, I can loop through a table but it
doesn't seem so good programming practice
?>
Best regards
/Gustav Wiberg
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
<?
$thisRow = $_GET["thisrow"];
$thisID = $_GET["thisID"];
//repir on this
$sql2 = "SELECT IDPrice, sortOrder FROM tbprices WHERE sortOrder>" . $db ->
safeQuote($thisRow)." AND IDPrice > $thisID ORDER BY `IDPrice` ASC LIMIT
0,1";
$dbArray = $db -> makeArray($sql2);
$dbNextSortOrder = $dbArray["sortOrder"];
$dbNextIDPrice = $dbArray["IDPrice"];
?>
--- End Message ---
--- Begin Message ---
> Good Day To All,
>
> System Config:
> Windows Server 2003
> PHP 5.2
>
> I'm hoping someone can help give me a high level understanding between
> the differences between an SSL certificate installed on my webserver
and
> an SSL module (e.g. OpenSSL) installed on my web server.
>
> 1. My current understanding is that the SSL certificate installed on my
> webserver will encrypt data coming from and going to a client web
> browser if the protocol is HTTPS. So, if on a checkout form at my web
> store the url begins with https, then credit card info, etc. will be
> encrypted and considered safe from sniffers, etc. Is this correct?
Correct, or at least more safe than non encrypted connections.
>
> 2. I become fuzzy then for the need or proper use of an SSL module
> (let's just go with OpenSSL). Specifically, my current webstore has
> VeriSign's Payflow Pro API installed on the webserver, and I have
> written a class that sends payment requests to VeriSign by using the
> Payflow Pro as a COM object. However, this is very slow (taking 30
> seconds per transaction). Recently my company purchased X-Cart
Shopping
> cart software and I am trying to get this configured to use our Payflow
> Pro account using XMLPay. However, I keep getting an error that no SSL
> module could be located for secure transactions. So, why do I need an
> SSL module if I am submitting transaction data to an HTTPS url?
In this case php becomes the client and it needs to know how to encrypt
data send to the gateway (the server) and how to decrypt the data comming
back. This is where OpenSSL comes into play. If you can load the extension
called php_openssl.dll, it requires libeay32.dll and ssleay32.dll you
should be able to communicate with SSL encryptions. You might want to take
a look at the cURL extension as well. It'll do all the encryption and
decryption for you on each request.
- Frank
--- End Message ---
