php-windows Digest 14 May 2002 18:46:20 -0000 Issue 1144
Topics (messages 13739 through 13768):
ini problem
13739 by: Tomator
Re: how do I get a user name?
13740 by: Shrock, Court
Session - Cannot recall variable
13741 by: Donny Hariady
13742 by: Aziz Durmaz
13745 by: Rasmus Lerdorf
server variables
13743 by: KovacsIst.otpbank.hu
13744 by: Stuart Dallas
13758 by: KovacsIst.otpbank.hu
13760 by: Rasmus Lerdorf
Need help with compressed uplaod problem...
13746 by: Svensson, B.A.T. (HKG)
13747 by: R.S. Herhuth
13748 by: Asendorf, John
13749 by: Svensson, B.A.T. (HKG)
13752 by: Hugh Bothwell
php 4.2 and database conn
13750 by: Nicole Amashta
13759 by: Rasmus Lerdorf
13763 by: Maurice Kevenaar
13764 by: Nicole Amashta
13766 by: Leon
13767 by: Maurice Kevenaar
Making extension
13751 by: Alberto. Sartori
Re: mail() problem
13753 by: Mike Eynon
Connection to SQL Server on remote machine
13754 by: Nicole Amashta
13755 by: Scott St. John
13761 by: Nicole Amashta
PEAR Library?
13756 by: Ben Fogt
13765 by: Nicola Delbono
String replacement...
13757 by: R.S. Herhuth
13762 by: Nicole Amashta
Re: php_gd.dll and Windows XP
13768 by: Alan Hale
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 ---
"Peter" <[EMAIL PROTECTED]> write in message:
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Check to see how many copies of php.ini are on your system. Although it
> shouldn't affect the module version, the php.ini in the c:\php (or
whatever)
> folder is read by the CGI executable instead of the one in c:\windows
Unfortunatelly this does not work. I have only one copy of php.ini in my
system. It does not work neither in c:\winnt, c:\windows nor c:\php.
Phpinfo() says it should be in folder c:\winnt, but editing it gives
absolutely no effect :-[
--- End Message ---
--- Begin Message ---
I have been using $_SERVER['AUTH_USER'] and $_SERVER['AUTH_PASSWORD']....
IIS 4
> -----Original Message-----
> From: toby z [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 13, 2002 10:50 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] how do I get a user name?
>
>
>
> anyone know how to do that for iis .... ?????
>
> or does the same thing works for it too ?????
>
> plz do let me know ....
>
> thnx a billion ....
>
> toby.....
>
>
>
>
> On 13 May 2002 at 17:21, Mauricio wrote:
> > I am using apaches' authentication.
> > How do i do for get user name and password in PHP?
>
>
> > PHP 4.1.x or later: $_SERVER['PHP_AUTH_USER'] and
> > $_SERVER['PHP_AUTH_PW']
> >
> > Earlier PHP: $PHP_AUTH_USER and $PHP_AUTH_PW
> >
> > --
> > Stuart
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
This is my first experience with PHP session manager. I try the following code:
session_start();
print($counter);
$counter++;
session_register("counter");
I found that PHP writes a sess_something file in its save_path directory.
When I refresh my browser, PHP updates this file but my browser still empty
and the content of the file is unchanged. I cannot recall my saved variable!
Somebody help me please... :(
Donny Hariady <[EMAIL PROTECTED]>
UIN: 16782504
... General Brain Failure ! (A)bort, (R)etry, (I)gnore, (O)h
--- End Message ---
--- Begin Message ---
try this;
-------------------------------------------------
session_start();
session_register("counter");
print($counter[num]);
$counter[num]++;
-------------------------------------------------
-----Original Message-----
From: Donny Hariady [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Session - Cannot recall variable
This is my first experience with PHP session manager. I try the following
code:
session_start();
print($counter);
$counter++;
session_register("counter");
I found that PHP writes a sess_something file in its save_path directory.
When I refresh my browser, PHP updates this file but my browser still empty
and the content of the file is unchanged. I cannot recall my saved variable!
Somebody help me please... :(
Donny Hariady <[EMAIL PROTECTED]>
UIN: 16782504
... General Brain Failure ! (A)bort, (R)etry, (I)gnore, (O)h
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Turn on register_globals in your php.ini file.
On Tue, 14 May 2002, Donny Hariady wrote:
> This is my first experience with PHP session manager. I try the following code:
>
> session_start();
> print($counter);
> $counter++;
> session_register("counter");
>
> I found that PHP writes a sess_something file in its save_path directory.
> When I refresh my browser, PHP updates this file but my browser still empty
> and the content of the file is unchanged. I cannot recall my saved variable!
>
> Somebody help me please... :(
>
>
> Donny Hariady <[EMAIL PROTECTED]>
> UIN: 16782504
>
> ... General Brain Failure ! (A)bort, (R)etry, (I)gnore, (O)h
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Hi,
I am using Win2K, IIS5 and PHP4.12.
When an SSL connection with client certificate established, IIS owns some
server variables containing information about client certificate (CERT_xxx
or HTTPS_xxx). Although PHP does not registers them. So the question is: how
can I access these server variables from PHP script?
Thanks in advance
Istvan Kovacs
--- End Message ---
--- Begin Message ---
[EMAIL PROTECTED] wrote:
> I am using Win2K, IIS5 and PHP4.12.
> When an SSL connection with client certificate established, IIS owns
> some server variables containing information about client certificate
> (CERT_xxx or HTTPS_xxx). Although PHP does not registers them. So the
> question is: how can I access these server variables from PHP script?
http://www.php.net/getenv
--
Stuart
--- End Message ---
--- Begin Message ---
Thanks, but it was not help, because PHP run on ISAPI mode,
and as manual says, getenv cannot be used in this mode.
Additionaly: phpinfo() shows this variables in its ISAPI section.
Regards,
Istvan Kovacs
> [EMAIL PROTECTED] wrote:
> > I am using Win2K, IIS5 and PHP4.12.
> > When an SSL connection with client certificate established, IIS owns
> > some server variables containing information about client
> certificate
> > (CERT_xxx or HTTPS_xxx). Although PHP does not registers
> them. So the
> > question is: how can I access these server variables from
> PHP script?
>
> http://www.php.net/getenv
>
> --
> Stuart
>
--- End Message ---
--- Begin Message ---
Put a phpinfo() tag on a page and look through the available variables.
Chances are it is in $HTTP_SERVER_VARS['CERT_XXX']
On Tue, 14 May 2002 [EMAIL PROTECTED] wrote:
> Thanks, but it was not help, because PHP run on ISAPI mode,
> and as manual says, getenv cannot be used in this mode.
> Additionaly: phpinfo() shows this variables in its ISAPI section.
>
> Regards,
>
> Istvan Kovacs
>
> > [EMAIL PROTECTED] wrote:
> > > I am using Win2K, IIS5 and PHP4.12.
> > > When an SSL connection with client certificate established, IIS owns
> > > some server variables containing information about client
> > certificate
> > > (CERT_xxx or HTTPS_xxx). Although PHP does not registers
> > them. So the
> > > question is: how can I access these server variables from
> > PHP script?
> >
> > http://www.php.net/getenv
> >
> > --
> > Stuart
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Hi all!
I tried this question before at alt.developers.www.ignorant.lunatics
but nobody was able to help me, so in despair I now ask this list.
I trying to upload an compressed duck to a receipt web page,
but the duck just refuses to cooperate with the upload process.
First I had a problem to catch the bloody duck, once that was
achieved, the duck just start to refused to negotiate with the
upload procedure. I have tried to squeeze it trough the keyboard,
but my office were so filed with feeders so I had to resume that
strategic. Anything I tried so far has failed. :(
Has anybody else had similar experience and can tell me how
they solved this problem?
Thanks for your time and participation.
//Anders
--
Anders
Ignorant Developers Association (IDA):
mailto:[EMAIL PROTECTED]
http://www.eerh.programming?.void
--- End Message ---
--- Begin Message ---
Anders,
What you need to do is Zip him first and then insert him in the
automatic cup holder (it looks like a CD-Rom tray) you will then find
him on your C drive. You may then include him as an attachment.
Hope this helps,
RSH
"Svensson, B.A.T. (HKG)" wrote:
>
> Hi all!
>
> I tried this question before at alt.developers.www.ignorant.lunatics
> but nobody was able to help me, so in despair I now ask this list.
>
> I trying to upload an compressed duck to a receipt web page,
> but the duck just refuses to cooperate with the upload process.
>
> First I had a problem to catch the bloody duck, once that was
> achieved, the duck just start to refused to negotiate with the
> upload procedure. I have tried to squeeze it trough the keyboard,
> but my office were so filed with feeders so I had to resume that
> strategic. Anything I tried so far has failed. :(
>
> Has anybody else had similar experience and can tell me how
> they solved this problem?
>
> Thanks for your time and participation.
>
> //Anders
>
> --
> Anders
> Ignorant Developers Association (IDA):
> mailto:[EMAIL PROTECTED]
> http://www.eerh.programming?.void
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi Anders,
There are a couple of possibilities. First, in the php.ini file you must
make sure you've turned on the extention for what you're trying to do.
Uncomment the line,
;php_poultry.dll
Then you'll have access to the compression and upload schemas for poultry.
Although this extension is rather foul, you'd be chicken not to give it a
try.
Next you'll need to make sure that you're properly compressing the uploaded
file. It sounds as if you are currently using the simple crush_waterfowl
($duck); command. Sometimes this will lead to major problems. I would try
the process ($duck , SQUARE); the SQUARE flag will help make sure $duck is
processed similarly to fish at McDonalds with that nice square shape.
I think this will make a difference, like the difference between light and
dark!
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
> -----Original Message-----
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 14, 2002 8:11 AM
> To: Php Win32 list
> Subject: [PHP-WIN] Need help with compressed uplaod problem...
>
>
> Hi all!
>
> I tried this question before at alt.developers.www.ignorant.lunatics
> but nobody was able to help me, so in despair I now ask this list.
>
> I trying to upload an compressed duck to a receipt web page,
> but the duck just refuses to cooperate with the upload process.
>
> First I had a problem to catch the bloody duck, once that was
> achieved, the duck just start to refused to negotiate with the
> upload procedure. I have tried to squeeze it trough the keyboard,
> but my office were so filed with feeders so I had to resume that
> strategic. Anything I tried so far has failed. :(
>
> Has anybody else had similar experience and can tell me how
> they solved this problem?
>
>
> Thanks for your time and participation.
>
> //Anders
>
> --
> Anders
> Ignorant Developers Association (IDA):
> mailto:[EMAIL PROTECTED]
> http://www.eerh.programming?.void
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
> What you need to do is Zip him first and then insert him in the
> automatic cup holder (it looks like a CD-Rom tray) you will then find
> him on your C drive. You may then include him as an attachment.
I haven't been trying out the Zip utility yet. What I did before
was to use this free Zap utility from www.maim.everyting.net, but it
was a hell of a job to get the duck, and secondly it really changed
the ventilation in the office in a way which neither is in accordance
with the original blueprints nor in line with any know design ideas
about ventilation. So we had to surrender that approach to. :( By the
way; anybody who have some extra spare fire logs for me?
//Anders
P.S. I am starting to run out of duck now, so I am really desperate. D.S.
--- End Message ---
--- Begin Message ---
"B.A.T. Svensson" <[EMAIL PROTECTED]> wrote in message
001301c1fb4e$95c4d450$[EMAIL PROTECTED]">news:001301c1fb4e$95c4d450$[EMAIL PROTECTED]...
> > What you need to do is Zip him first and then insert him in the
> > automatic cup holder (it looks like a CD-Rom tray) you will then find
> > him on your C drive. You may then include him as an attachment.
>
> I haven't been trying out the Zip utility yet. What I did before
> was to use this free Zap utility from www.maim.everyting.net, but it
> was a hell of a job to get the duck, and secondly it really changed
> the ventilation in the office in a way which neither is in accordance
> with the original blueprints nor in line with any know design ideas
> about ventilation. So we had to surrender that approach to. :( By the
> way; anybody who have some extra spare fire logs for me?
Have you tried uploading an openChicken
(the "free-as-in-beer" pre-compressed duck)?
--- End Message ---
--- Begin Message ---
I have recently installed PHP 4.2 on a server running win2k. There is no
SQL Server database running on this particular machine. I want to
connect to an SQL Server DB on another machine on the same network.
Now, do I need to have atleast the client tools installed in order to do
this? Or, can I just setup an ODBC source? Because they (my coworkers)
don't want to install SQLServer2k on the machine (running the PHP). (I
have the php_mssql.dll enabled).
Any suggestions to get around not having to install any additional files
in order to connect to an SQLServer2k database?
I notice I am also having trouble connecting to MySQL which is on the
same machine as PHP4.2. I have register globals on.
I'm used to PHP 4.0.6. But I need to get up to speed with the last PHP.
I just need to know if I am overlooking something in the PHP.ini file.
Thanks in advance for any ideas!
Nicole
www.aeontrek.com
--- End Message ---
--- Begin Message ---
ODBC support is built-into the Windows version of PHP. You should be able
to simply create a DSN and connect to that.
For MySQL, make sure you uncomment the extension=mysql.dll in your php.ini
file and it should work just fine.
-Rasmus
On Tue, 14 May 2002, Nicole Amashta wrote:
> I have recently installed PHP 4.2 on a server running win2k. There is no
> SQL Server database running on this particular machine. I want to
> connect to an SQL Server DB on another machine on the same network.
>
> Now, do I need to have atleast the client tools installed in order to do
> this? Or, can I just setup an ODBC source? Because they (my coworkers)
> don't want to install SQLServer2k on the machine (running the PHP). (I
> have the php_mssql.dll enabled).
>
> Any suggestions to get around not having to install any additional files
> in order to connect to an SQLServer2k database?
>
> I notice I am also having trouble connecting to MySQL which is on the
> same machine as PHP4.2. I have register globals on.
>
> I'm used to PHP 4.0.6. But I need to get up to speed with the last PHP.
> I just need to know if I am overlooking something in the PHP.ini file.
>
> Thanks in advance for any ideas!
>
> Nicole
> www.aeontrek.com
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
try this:
$connect = mssql_connect($db_server_name, $db_user_name, $db_user_passwd);
You can use ODBC too, but (in my exp. it's slower)
--
Maurice
"Nicole Amashta" <[EMAIL PROTECTED]> schreef in bericht
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have recently installed PHP 4.2 on a server running win2k. There is no
> SQL Server database running on this particular machine. I want to
> connect to an SQL Server DB on another machine on the same network.
>
> Now, do I need to have atleast the client tools installed in order to do
> this? Or, can I just setup an ODBC source? Because they (my coworkers)
> don't want to install SQLServer2k on the machine (running the PHP). (I
> have the php_mssql.dll enabled).
>
> Any suggestions to get around not having to install any additional files
> in order to connect to an SQLServer2k database?
>
> I notice I am also having trouble connecting to MySQL which is on the
> same machine as PHP4.2. I have register globals on.
>
> I'm used to PHP 4.0.6. But I need to get up to speed with the last PHP.
> I just need to know if I am overlooking something in the PHP.ini file.
>
> Thanks in advance for any ideas!
>
> Nicole
> www.aeontrek.com
>
--- End Message ---
--- Begin Message ---
Thanks, but I'm not trying to write the scripts. I already wrote them.
I just wanted connectivity without having SQLServer installed on the
PHP box.
Thanks! :)
nicole
www.aeontrek.com
Maurice Kevenaar wrote:
> try this:
>
> $connect = mssql_connect($db_server_name, $db_user_name, $db_user_passwd);
>
> You can use ODBC too, but (in my exp. it's slower)
>
> --
>
> Maurice
>
> "Nicole Amashta" <[EMAIL PROTECTED]> schreef in bericht
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>>I have recently installed PHP 4.2 on a server running win2k. There is no
>>SQL Server database running on this particular machine. I want to
>>connect to an SQL Server DB on another machine on the same network.
>>
>>Now, do I need to have atleast the client tools installed in order to do
>>this? Or, can I just setup an ODBC source? Because they (my coworkers)
>>don't want to install SQLServer2k on the machine (running the PHP). (I
>>have the php_mssql.dll enabled).
>>
>>Any suggestions to get around not having to install any additional files
>>in order to connect to an SQLServer2k database?
>>
>>I notice I am also having trouble connecting to MySQL which is on the
>>same machine as PHP4.2. I have register globals on.
>>
>>I'm used to PHP 4.0.6. But I need to get up to speed with the last PHP.
>>I just need to know if I am overlooking something in the PHP.ini file.
>>
>>Thanks in advance for any ideas!
>>
>>Nicole
>>www.aeontrek.com
>>
>
>
>
--- End Message ---
--- Begin Message ---
You need atleast the SQL Server Client in your PHP server. PHP installs all
the rest you need.
----- Original Message -----
From: "Nicole Amashta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 11:35 AM
Subject: [PHP-WIN] php 4.2 and database conn
> I have recently installed PHP 4.2 on a server running win2k. There is no
> SQL Server database running on this particular machine. I want to
> connect to an SQL Server DB on another machine on the same network.
>
> Now, do I need to have atleast the client tools installed in order to do
> this? Or, can I just setup an ODBC source? Because they (my coworkers)
> don't want to install SQLServer2k on the machine (running the PHP). (I
> have the php_mssql.dll enabled).
>
> Any suggestions to get around not having to install any additional files
> in order to connect to an SQLServer2k database?
>
> I notice I am also having trouble connecting to MySQL which is on the
> same machine as PHP4.2. I have register globals on.
>
> I'm used to PHP 4.0.6. But I need to get up to speed with the last PHP.
> I just need to know if I am overlooking something in the PHP.ini file.
>
> Thanks in advance for any ideas!
>
> Nicole
> www.aeontrek.com
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
You can to set the $db_server_name to SQLBox (or it's ip)
--
maurice
"Nicole Amashta" <[EMAIL PROTECTED]> schreef in bericht
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Thanks, but I'm not trying to write the scripts. I already wrote them.
> I just wanted connectivity without having SQLServer installed on the
> PHP box.
>
> Thanks! :)
> nicole
> www.aeontrek.com
>
> Maurice Kevenaar wrote:
> > try this:
> >
> > $connect = mssql_connect($db_server_name, $db_user_name,
$db_user_passwd);
> >
> > You can use ODBC too, but (in my exp. it's slower)
> >
> > --
> >
> > Maurice
> >
> > "Nicole Amashta" <[EMAIL PROTECTED]> schreef in bericht
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> >
> >>I have recently installed PHP 4.2 on a server running win2k. There is no
> >>SQL Server database running on this particular machine. I want to
> >>connect to an SQL Server DB on another machine on the same network.
> >>
> >>Now, do I need to have atleast the client tools installed in order to do
> >>this? Or, can I just setup an ODBC source? Because they (my coworkers)
> >>don't want to install SQLServer2k on the machine (running the PHP). (I
> >>have the php_mssql.dll enabled).
> >>
> >>Any suggestions to get around not having to install any additional files
> >>in order to connect to an SQLServer2k database?
> >>
> >>I notice I am also having trouble connecting to MySQL which is on the
> >>same machine as PHP4.2. I have register globals on.
> >>
> >>I'm used to PHP 4.0.6. But I need to get up to speed with the last PHP.
> >>I just need to know if I am overlooking something in the PHP.ini file.
> >>
> >>Thanks in advance for any ideas!
> >>
> >>Nicole
> >>www.aeontrek.com
> >>
> >
> >
> >
>
--- End Message ---
--- Begin Message ---
Hi guys, I wanna ask you a simply questions. If I would make a .dll extensions,
basically what I've to do? what kind of tools I need? thanks!
Alberto Sartori - Developer
Hard Programming Dep.
-----------------------------------------------
CELL NETWORK ITALIA S.p.A
Via Correggio, 19
20149 Milano - Italy
Phone +39 02.46.90.551
Fax +39 02.46.91.700
E-Mail: [EMAIL PROTECTED]
Internet Site: http://www.cellnetwork.it
-----------------------------------------------
--- End Message ---
--- Begin Message ---
This could be a PHP or COM question... not sure.
I am calling a custom COM object from php. I am seeing a memory leak happen
when I build my variant in C++ and then return it out to the PHP calling
into the COM.
I am using the following piece of code to take a simple C++ array of strings
and load it into a Variant:
void ComUtils::CreateCOMStrArray(VARIANT* pOut, BSTR* bsArray, int iLen)
{
SAFEARRAYBOUND bounds = { iLen , 0 } ;
SAFEARRAY* pSA = SafeArrayCreate (VT_VARIANT , 1 ,
&bounds);
VARIANT* pVarArray;
// lock the array
SafeArrayAccessData(pSA , (void **)&pVarArray);
// put all strings into variants
for (int i=0;i<iLen;i++) {
VARIANT vTmp;
VariantInit(&vTmp);
vTmp.vt = VT_BSTR;
vTmp.bstrVal = bsArray[i]; // DANGER DANGER DANGER!!!!
VariantCopy(&pVarArray[i], &vTmp);
vTmp.bstrVal = NULL; vTmp.vt = VT_EMPTY; // give up string ownership
VariantClear(&vTmp);
}
// unlock the array
SafeArrayUnaccessData(pSA);
VariantInit(pOut);
V_VT(pOut) = VT_ARRAY | VT_VARIANT;
// put the array in the output variant
V_ARRAY(pOut) = pSA;
}
Unfortunately, I don't have any COM books, and the VC++ help files don't
seem to have what I am looking for (or at least I am looking in the wrong
spot).
Its pretty obvious to me that the assignment, "vTmp.bstrVal = bsArray[i];"
is not the way I shoudl be doing this. PHP doesn't seem to know to free
this memory since it was alloc'd outside its realm.
So... Is there a PHP fix for this, or is this a COM thing? If it is COM, (I
know this is not a COM list) could someone point me in the right direction
there?
Thanks.
// Mike Eynon
// www.MikeEynon.com
// 1366 Bulb Ave.
// Santa Cruz, CA 95062
// [EMAIL PROTECTED]
// 831.588.2388
--- End Message ---
--- Begin Message ---
Has anyone any luck connecting to an SQL Server 2k database on a remote
machine over the local network?
This works with ODBC, but not using the php mssql functions. I have a
similar setup on another machine where this works - but the client tools
are installed.
I have everything necessary setup on the machines. I have apache running
as a user service. I have that user allowed to run on the remote machine
where sql server is running.
I have ntwdblib.dll in winnt\system32. I have the correct php_mssql.dll.
I get no errors other than "can't connect to the host" that I am trying
to connect to. The same script works off my machine - but I have SQL
Server installed on my machine.
I am down to thinking that I have to have the client tools in order to
access the database; however, the snip of text below leads me to believe
that I should be able to connect with just the ntwdblib.dll and
php_mssql.dll files alone:
<snip source="http://www.php.net/manual/en/ref.mssql.php";>
These functions allow you to access MS SQL Server database. The
extension requires the MS SQL Client Tools to be installed on the system
where PHP is installed. The Client Tools can be installed from the MS
SQL Server CD or by copying ntwdblib.dll from \winnt\system32 on the
server to \winnt\system32 on the PHP box. Copying ntwdblib.dll will only
provide access. Configuration of the client will require installation of
all the tools.
The MSSQL extension is enabled by adding extension=php_mssql.dll to
php.ini.
</snip>
This line "Copying ntwdblib.dll will only provide access." is what lets
me think I can do this.
Any one? Help, please. Thanks! :)
Nicole
www.aeontrek.com
--- End Message ---
--- Begin Message ---
Nicole-
I would try using the IP address instead of the machine name to see if
that works. If it does not you might have to install the client tools.
In our LAN I have to also go into the Client Network Utility and
create an alias to port 1433.
-Scott
On Tue, 14 May 2002, Nicole Amashta wrote:
> Has anyone any luck connecting to an SQL Server 2k database on a remote
> machine over the local network?
> This works with ODBC, but not using the php mssql functions. I have a
> similar setup on another machine where this works - but the client tools
> are installed.
>
> Any one? Help, please. Thanks! :)
>
> Nicole
> www.aeontrek.com
>
>
>
--
--- End Message ---
--- Begin Message ---
Thanks, I got it. I just installed the minimum stuff from the Client
tools. That worked.
I appreciate your help. ;)
-Nicole
www.aeontrek.com
Scott St. John wrote:
> Nicole-
>
> I would try using the IP address instead of the machine name to see if
> that works. If it does not you might have to install the client tools.
> In our LAN I have to also go into the Client Network Utility and
> create an alias to port 1433.
>
> -Scott
>
> On Tue, 14 May 2002, Nicole Amashta wrote:
>
>
>>Has anyone any luck connecting to an SQL Server 2k database on a remote
>>machine over the local network?
>>This works with ODBC, but not using the php mssql functions. I have a
>>similar setup on another machine where this works - but the client tools
>>are installed.
>>
>>Any one? Help, please. Thanks! :)
>>
>>Nicole
>>www.aeontrek.com
>>
>>
>>
>
>
--- End Message ---
--- Begin Message ---
Is there a particular directory that is considered the PEAR library in the
PEAR piece of PHP? I'm getting an error in Horde that says that my PEAR
library path might be missing from include_path.
Ben Fogt
--- End Message ---
--- Begin Message ---
try
c:/php4/PEAR
>Is there a particular directory that is considered the PEAR library in the
Nicola Delbono
///////////////////////////////////////////
Il notiziario dei notiziari
http://www.notiziarioweb.it/
///////////////////////////////////////////
www.smscitta.com | www.musicalbox.it
www.filosofo.it | www.bollicine.com
--- End Message ---
--- Begin Message ---
I have a situation where I will be pulling back an article that may
contain none or several references to link IDs in the following format:
<a href="javascript:void(FILELINK('226'))"></a>
The rest of the article is basically text in the format of a news
article. What I need to do is to extract the ID (the #226 in this
example) and run a query returning it's value and replacing the 226 with
the link. I can't change the database to meet my needs unfortunately.
I am using MSSQL Server 2000.
So the flow looks like this (as I see it):
1. Run a query bringing back the article as a string. (I've built this already)
2. Search the string for the pattern above which will always be the same
except the ID value will of course be different in each occurance, and
store the IDs in an array. (I have no idea how to do this)
3. I will then run a query returning the actual links and search for the
ID and replace the ID number with the associated link. (I should be able
to figure this out.
Can anyone offer a suggestion on how to do this? Does my logic flow
seem solid?
Thanks for any help,
Ron
--- End Message ---
--- Begin Message ---
Do you want to create a javascript array of the file names? Do the file
names exist on the server? If so, just generate and populate a
javascript array with the id and matching name, then load the article
when the link is clicked.
-Nicole
www.aeontrek.com
R.S. Herhuth wrote:
> I have a situation where I will be pulling back an article that may
> contain none or several references to link IDs in the following format:
> <a href="javascript:void(FILELINK('226'))"></a>
>
> The rest of the article is basically text in the format of a news
> article. What I need to do is to extract the ID (the #226 in this
> example) and run a query returning it's value and replacing the 226 with
> the link. I can't change the database to meet my needs unfortunately.
> I am using MSSQL Server 2000.
>
> So the flow looks like this (as I see it):
>
> 1. Run a query bringing back the article as a string. (I've built this already)
>
> 2. Search the string for the pattern above which will always be the same
> except the ID value will of course be different in each occurance, and
> store the IDs in an array. (I have no idea how to do this)
>
> 3. I will then run a query returning the actual links and search for the
> ID and replace the ID number with the associated link. (I should be able
> to figure this out.
>
>
> Can anyone offer a suggestion on how to do this? Does my logic flow
> seem solid?
>
> Thanks for any help,
> Ron
--- End Message ---
--- Begin Message ---
Thanks Jeff, but that's not it - php_gd2.dll did not come with the
installation (I did in fact try downloading a copy into my extensions dir,
and editing php.ini accordingly, but this worked no better).
----- Original Message -----
From: "Jeff Waldock" <[EMAIL PROTECTED]>
To: "'Alan Hale'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 7:33 PM
Subject: RE: [PHP-WIN] php_gd.dll and Windows XP
> Alan
> I think the dll has been re-named to php_gd2.dll. Just rename the
> extension in your php.ini to this and re-start the web server and you
> should find it works.
> Jeff
>
> |-----Original Message-----
> |From: Alan Hale [mailto:[EMAIL PROTECTED]]
> |Sent: 13 May 2002 18:24
> |To: [EMAIL PROTECTED]
> |Subject: [PHP-WIN] php_gd.dll and Windows XP
> |
> |
> |I've recently upgraded to XP Pro from Windows Me. I previously
> |had PHP running with the gd extension on Omnihttpd server, but
> |found with the same configuration gd would not work (Error
> |messages: First: " The procedure entry point add_assoc_long
> |could not be located in the dll php4ts.dll" Then: "Unable to
> |locate dll 'c:\httpd\php\php_gd.dll' - the specified procedure
> |could not be found".
> |
> |I've also tried installing with Easywindows on IIS - again, gd
> |does not work (though no helpful error messages).
> |
> |So I'm coming to the conclusion there some incompatability
> |between XP and the php_gd.dll. Does anyone have this working
> |on XP? Can anyone suggest how I can fix this?
> |
> |Many thanks
> |
> |Alan Hale
> |
> |
>
--- End Message ---
