php-windows Digest 29 Aug 2002 11:37:38 -0000 Issue 1313

Topics (messages 15571 through 15583):

Re: PHP MSSQL versions
        15571 by: David Hollister

Re: Sharing news or other data
        15572 by: David Hollister

Re: Is there a PHP-WIN FAQ?
        15573 by: Christoph Grottolo
        15583 by: Svensson, B.A.T. (HKG)

Re: ISAPI (was: [PHP-WIN] PHP MSSQL versions)
        15574 by: Christoph Grottolo

how to do an html include on Windows?
        15575 by: M. Hockings
        15577 by: Ross Fleming

PHP/MySQL/APache on CD
        15576 by: Asendorf, John

Re: mail() I get crazy from this...
        15578 by: Manuel Lemos
        15579 by: Manuel Lemos
        15581 by: leo g. divinagracia iii

moving data from dbf to mysql
        15580 by: Marlene Burckhalter
        15582 by: Seairth Jacobs

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 ---
Apart from my short-term memory loss about the use of ntwdblib.dll in MSSQL
PHP functions, I've had no trouble using it with CGI.  What's your specific
problem?  Post da code man.  Lay it out.  

-----Original Message-----
From: Brian McGarvie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 3:04 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] PHP MSSQL versions

I was having trouble using the mssql functions...

I believe it was because i was running it as CGI (shhhh - i know) i am now
running it as ISAPI (yes I am unfortinatley an IIS user untill Apache2/PHP
combination is deemed ready for use on a production server).

As I am now ISAPI, the functions should work?

"Christoph Grottolo" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Yes. You'll find the file in the dll folder in your php distribution. Copy
> it to your windows\system32 directory. See also
> http://ch.php.net/manual/en/ref.mssql.php
>
> Christoph
>
> David Hollister wrote:
> > Can someone confirm this?  I don't think you need anything beyond the
> > php_mssql.dll to use MSSQL specific functions.  I'm pretty sure I've
> > done that in the past.  I'm curious now.
> >
> >> Also, you need to make sure that you have the ms_sql client
> >> libraries installed on the local machine where php resides. It needs
> >> these libraries to connect to SQL server.
> >
> > -----Original Message-----
> > From: Flint Doungchak [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, August 27, 2002 11:38 AM
> > To: Bob Hiller -1; PHP Mail List
> > Subject: RE: [PHP-WIN] PHP MSSQL versions
> >
> > Bob,
> >
> > From what I understand, I don't understand it all that much, you need
> > to make sure that the correct version of PHP runs with the correlated
> > version of the module (for all modules not just mssql). When you
> > download PHP from php.net (at least when you download the zipped
> > version), the mssql module comes with the package and is located in
> > the ./extensions directory.
> >
> > Make sure your .ini files contains the line:
> >
> > extension_dir = ./extensions
> >
> > And that you have uncommented the line:
> >
> > extension=php_mssql.dll
> >
> > Also, you need to make sure that you have the ms_sql client libraries
> > installed on the local machine where php resides. It needs these
> > libraries to connect to SQL server. Just install the client tools off
> > the SQL server CD.
> >
> > That should do it. I think this version matching things is really
> > important as of 4.2.0 but has always been the situation between 3.x
> > and 4.x. In any case, if any else knows the technical details, please
> > fill us in.
> >
> > Hope that helps.
> >
> > -Flint
> >
> > -----Original Message-----
> > From: Bob Hiller -1 [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 26, 2002 1:25 PM
> > To: PHP Mail List
> > Subject: [PHP-WIN] PHP MSSQL versions
> >
> >
> > I download php_mssql.dll and added it to php.ini.
> >
> > When I open any php page I get this error
> >
> > MSSQL Unable to initialize module
> >
> > Module Compiled with Debug=0 Thread Safety=1 Module API=20020429
> >
> > PHP Compiled with Debug=0 Thread Safety=1 Module API=20010901
> >
> > These option must match
> >
> > What do I need to do to make the Module API's match.
> >
> > Thanks,
> > Bob Hiller
> >
> >
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>



--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
PHP cares more about making a connection to the database than about how many
sites you have.  

Server 1: store news in database
Server 2: request news from database and present that news in HTML
Server 3: request news from database and present that news in HTML

What are your specific questions?  

-----Original Message-----
From: Steen Rabol [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:19 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Sharing news or other data

Hi

Iv'e been searching the net for a few hours without any luck....

Let's say that I have 3 sites one site have a database with news/articles.
On the 2 others I would like to show headlines/news/articles from the
database.

How can I do that ?

Thanks in advance
Steen



--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Ross Fleming wrote:
> Lo folks,
>
> Maybe I've just never seen it, but is there an official php-win faq
> circulating?  I'm sure regular readers like me will have noticed the
> assault of questions that keep occurring time and time again?  If
> there isn't a faq, what does everyone think about starting one?

+1 for a php-win faq.

What about using http://www.boesch-it.de/sw/faqengine.php to implement it?
The tool is powerful, multilingual and easy to administrate in a multi user
environnment.

Christoph

--- End Message ---
--- Begin Message ---
Sound like a good idea (I haven't seen an FAQ either), and included can also be some 
helpful tips about additional reading about
things that are not directly related, but close to php, like database issues, etc.

Anyhow, many answers to question in this list, I would believe, could be
found at the www.php.net/manul site. Couldn't that be refereed to as a FAQ
in some sense?


> -----Original Message-----
> From: Ross Fleming [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 28, 2002 5:02 PM
> To: PHP Windows mailing list
> Subject: [PHP-WIN] Is there a PHP-WIN FAQ?
>
>
> Lo folks,
>
> Maybe I've just never seen it, but is there an official php-win faq
> circulating?  I'm sure regular readers like me will have noticed the assault
> of questions that keep occurring time and time again?  If there isn't a faq,
> what does everyone think about starting one?
>
> Questions I can think of are:
> (.) How do I get mail() to work?
> (.) I have a script that doesn't print out the variables I POST to it...
> (.) I have an error saying "Headers already sent", what does that mean?
>
> What does everyone think?
>
> Cheers
>
> Ross
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Flint Doungchak wrote:
> Brian,
>
> As far as I know, as of 4.2.2, I'm not so certain that ISAPI is more
> stable than CGI. However, I'd like to know. We've been using the
> IIS/CGI combination since 3.0x and we'd really like to get the ISAPI
> modulus working.

The developers are actually talking about making ISAPI more stable - see
http://marc.theaimsgroup.com/?l=php-dev&m=103037920624678&w=2 and
follow-ups. Maybe we can expect something for 4.3.0...

Christoph

--- End Message ---
--- Begin Message ---
Hello,

I'm trying to mimic the setup that is out on my webspace locally on my 
laptop so that I can develop and test without having to publish a test 
tree to the web space.

Part of the code on the web is in PHP.  I have written a servlet for 
Enhydra that allows me to serve my PHP pages just like on the web except 
that it won't include remote html.  That is, if I have a piece of code like:

<?

file = "http://server-name/dir-name/my-file.jsp

include (file);

?>


Then I just get a message saying that it can't include the file.  Now, 
after some research I see that the http:  type include does not work on 
the Windows port of PHP (why is that anyway??).  So, this brings me to 
my question.  For a PHP non-expert like myself how can I code the same 
function in a way that will work with both relative (local) and remote 
(http) address?  Ideally I'd like the request, even if relative, to go 
back to the web-server as includes like JSP's  require processing before 
the resultant stream is included.

Kind regards,

Mike


--- End Message ---
--- Begin Message ---
I posted this not 24 hours ago that does this

-----Original Message-----
From: Ross Fleming [mailto:[EMAIL PROTECTED]]
Sent: 27 August 2002 11:19
To: Rudolf Staribacher; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] include() and file() on remote files


So far as I know, Linux etc does not have any problem with a statement such
as include("http://www.yahoo.com";);

However it is fairly simple to work around in Windows, I do it all the time.
The following code will produce the same output:
<?
$fp = @fopen("http://www.yahoo.com","r";);

while(!feof($fp) && $fp) {
  echo fread($fp, 4096);
}
@fclose($fp);
?>

HTH

Ross

> -----Original Message-----
> From: Rudolf Staribacher [mailto:[EMAIL PROTECTED]]
> Sent: 26 August 2002 22:16
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] include() and file() on remote files
>
>
> the include function does not work on Win32 platforms on remote files
> (http). I faced also problems with nested!!! file function on remote files
> (http). Does anybody know, if the lack of remote access of include() and
> file() could also occure on other OS?
>
> thx,
> Rudolf
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>


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



--- End Message ---
--- Begin Message ---
I thought a couple of weeks ago I saw someone working on a PHP/MySQL/Apache
(all running from a CD) on here.  Does anyone remember who that was?

Thanks,

John

---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
--- End Message ---
--- Begin Message ---
Hello,

On 08/28/2002 08:57 AM, Peter wrote:
> Hello,
> I repeat: my PHP mail() function does not work. Apache tells me it can 
> not connect.
> I have XP, Netscape, Apache, PHP, MYSQL. I have not the faintest idea 
> where my smpt server is. I use Netscape for reading my e-mail.I have 
> only a raw line to the internet.
> I have installed a firewall.
> 
> What must I do to discover what my smpt server is? I must have one. 
> Otherwise I could not go to netscape and send mail, to hotmail etc.

If you do not have a SMTP server running in your machine, install one or 
use your ISP SMTP server.

Alternatively you may want to try this SMTP sending class that can 
operate in direct delivery mode, ie, it sends messages directly to the 
recipients SMTP server address. Since you use Windows, you will need 
also a DNS resolver class that emulates the function GetMXRR() that is 
disabled under Windows, but that is mentioned in this page:

http://www.phpclasses.org/smtpclass

You will probably have some dificulties because this is not a trivial 
issue. Just reply to this message if you need further help.


-- 

Regards,
Manuel Lemos

--- End Message ---
--- Begin Message ---
Hello,

On 08/28/2002 08:57 AM, Peter wrote:
> Hello,
> I repeat: my PHP mail() function does not work. Apache tells me it can 
> not connect.
> I have XP, Netscape, Apache, PHP, MYSQL. I have not the faintest idea 
> where my smpt server is. I use Netscape for reading my e-mail.I have 
> only a raw line to the internet.
> I have installed a firewall.
> 
> What must I do to discover what my smpt server is? I must have one. 
> Otherwise I could not go to netscape and send mail, to hotmail etc.

If you do not have a SMTP server running in your machine, install one or 
use your ISP SMTP server.

Alternatively you may want to try this SMTP sending class that can 
operate in direct delivery mode, ie, it sends messages directly to the 
recipients SMTP server address. Since you use Windows, you will need 
also a DNS resolver class that emulates the function GetMXRR() that is 
disabled under Windows, but that is mentioned in this page:

http://www.phpclasses.org/smtpclass

You will probably have some dificulties because this is not a trivial 
issue. Just reply to this message if you need further help.


-- 

Regards,
Manuel Lemos

--- End Message ---
--- Begin Message ---
if you have a server yourself, then download the freebie STMP server 
from pegasus mail's creator.

i'm using since our days with a novell box.  now my win2k box runs the 
mercury smtp server strickly for php duties...

http://www.pmail.com

he has both clients and server for win32...

Peter wrote:
> Hello B.A.T.,
> If so, I must organise. By sheer luck I got a cheap fast ADSL line, 
> guaranteed 115 kilobytes a second. Now, I understand, I must target to 
> be an ISP. I have a fixed IP-address. I have a server and PHP, MYSQL. 
> You tell me that other SMPT servers will not accept my e-mail unless I 
> am an ISP provider.
> Well than, where/how can I become ISP provider? Because I want to be 
> independent.
> with friendly greetings,
> Peter van Summeren
> 
> B.A.T. Svensson wrote:
> 
>>> Thanks for this answer. No, I do not have an ISP. I only have a raw
>>> line: fast ADSL without any whatever, but guaranteed fast.
>>> I do not understand your kind of english, but it seems to me from 
>>> your last sentence that I should give up.
>>
>>
>>
>> You MUST necessarily have an ISP (Internet Service provider),
>> unless you are an ISP your self, which I doubt. ;)
>>
> 
> 



-- 
Leo G. Divinagracia III
[EMAIL PROTECTED]

--- End Message ---
--- Begin Message ---
hi
how would i go about moving data from a dbf to mysql with php?

if the php documentation help covers this, what phrase do i key in to search?

marlene
--- End Message ---
--- Begin Message ---
My experience (I'm one of them there VFP programmer types) with dbfs is that
it's often easier to export to a more general format (CSV, tab-delimited,
DIF, etc) than to try to do anything with DBFs directly.

One method is to export the DBF to a comma-delimited file, then use:

LOAD DATA ...  (chapter 6.4.9 in MySQL docs)

Of course, the above method depends on what sort of access you have to the
MySQL server.  If you can conect to the server directly, then you may want
to consider using mysqlimport (chapter 4.8.7 in MySQL docs) instead.

Another method would be to upload a comma-delimited version of the file, and
parse each record into a series of INSERT... statements.  This does not
require direct access to the server, but is also much slower.  Note that you
can insert more than one record at a time with a single INSERT statement in
MySQL (which is not the case for VFP's INSERT...).  This would speed up your
import process by reducing the number of requests being sent to the MySQL
server.  You could probably find such a script (or something close) by
looking through the various PHP code archives available all over the Web...

Also note that there is a dBase module for PHP, but most installations do
not have it installed by default.  Also, even if you did have it installed,
you would still need the same level of access as the first option above.  As
a result, if you have this sort of access, just use the first option...

---
Seairth Jacobs
[EMAIL PROTECTED]


"Marlene Burckhalter" <[EMAIL PROTECTED]> wrote in message
001301c24eea$5710ae60$6401a8c0@MarleneGateway">news:001301c24eea$5710ae60$6401a8c0@MarleneGateway...
hi
how would i go about moving data from a dbf to mysql with php?

if the php documentation help covers this, what phrase do i key in to
search?

marlene



--- End Message ---

Reply via email to