php-windows Digest 9 May 2007 14:59:52 -0000 Issue 3221
Topics (messages 27844 through 27858):
Re: How to access a DLL compiled in VC++ in PHP?
27844 by: bedul
PHP AND Upgrade
27845 by: Gustav Wiberg
problems with PHP
27846 by: Gustav Wiberg
Re:PHP - MSSQL -5.2.2?
27847 by: Chetan Graham
27848 by: Gustav Wiberg
27849 by: Gustav Wiberg
27851 by: Chetan Graham
Dynamically update mysql field
27850 by: sam rumaizan
27852 by: Alf Stockton
27853 by: Aleksandar Vojnovic
27854 by: sam rumaizan
27855 by: Alf Stockton
27857 by: Aleksandar Vojnovic
Error With fsocketopen() Call
27856 by: James Crow
Problem With Pear::DB
27858 by: Jody Williams
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 ---
interesting.
----- Original Message -----
From: "Raghavendra V. Kulkarni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2007 7:20 PM
Subject: [PHP-WIN] How to access a DLL compiled in VC++ in PHP?
> Hello,
>
> Please provide pointers to access a DLL compiled by us (so, we have
> access to the source code) in VC++ in PHP pages.
>
> Regards,
> Raghu
can u describe why you have to use DLL.. if the function you looking for are
in PHP, don't waste time to use the DLL.
can i ask?
1. what function u use?
2. are u said about PHP for web or PHP for aplication.. like Perl
--- End Message ---
--- Begin Message ---
Hej!
Felaktig syntax för filnamn, katalognamn eller volymetikett... Anyone who knows
what WHY this message appear? Tried to install PHP5.2 from 5.0.1...
Best regards
/Gustav Wiberg
--- End Message ---
--- Begin Message ---
Hi!
I can only view html-files.. PHP don't seem to work?
Windows 2003 Server, IIS 6... PHP 5.2...
/Gustav
--- End Message ---
--- Begin Message ---
Gustav Wiberg says:
>MSSQL and PHP. Should I upgrade from PHP 5.0.1 to 5.2.2 for getting the
>connection to MSSQL-database to work correctly?
>Best regards
>/Gustav Wiberg
Yesterday, I decided to update PHP521 to 522 and update the MySQL
server/client to the latest as I was having strange connection problems.
In the end the decision turned out to be just right.
It took me several tries to delete the existing copy of MySQL in order to
do a clean install.
However, I now know what one has to do to remove the 'root' of MySQL
program from Windows2000, he, he.
PHP installs just fine with out doing a clean install. Just install right
into the PHP directory. I had to fix the confused php.ini from the
install, (numerous extensions where copied right on top of the others so I
had double of the same extension many times. Path statements where placed
in strange places as well.
This was a small adjustment as anyone using PHP in time gets to know the
.ini file very well.
Hope this helps,
Blessings,
Chetan
--- End Message ---
--- Begin Message ---
Hi there!
Thanx all!
The problem is solved. The MSI Windows installer added an extra \ to the path!?
...
/Gustav
-----Original Message-----
From: Chetan Graham [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 8:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Re:PHP - MSSQL -5.2.2?
Gustav Wiberg says:
>MSSQL and PHP. Should I upgrade from PHP 5.0.1 to 5.2.2 for getting the
>connection to MSSQL-database to work correctly?
>Best regards
>/Gustav Wiberg
Yesterday, I decided to update PHP521 to 522 and update the MySQL
server/client to the latest as I was having strange connection problems.
In the end the decision turned out to be just right.
It took me several tries to delete the existing copy of MySQL in order to
do a clean install.
However, I now know what one has to do to remove the 'root' of MySQL
program from Windows2000, he, he.
PHP installs just fine with out doing a clean install. Just install right
into the PHP directory. I had to fix the confused php.ini from the
install, (numerous extensions where copied right on top of the others so I
had double of the same extension many times. Path statements where placed
in strange places as well.
This was a small adjustment as anyone using PHP in time gets to know the
.ini file very well.
Hope this helps,
Blessings,
Chetan
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi there!
Thanx all!
The problem is solved. The MSI Windows installer added an extra \ to the path!?
...
/Gustav
-----Original Message-----
From: Chetan Graham [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 8:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Re:PHP - MSSQL -5.2.2?
Gustav Wiberg says:
>MSSQL and PHP. Should I upgrade from PHP 5.0.1 to 5.2.2 for getting the
>connection to MSSQL-database to work correctly?
>Best regards
>/Gustav Wiberg
Yesterday, I decided to update PHP521 to 522 and update the MySQL
server/client to the latest as I was having strange connection problems.
In the end the decision turned out to be just right.
It took me several tries to delete the existing copy of MySQL in order to
do a clean install.
However, I now know what one has to do to remove the 'root' of MySQL
program from Windows2000, he, he.
PHP installs just fine with out doing a clean install. Just install right
into the PHP directory. I had to fix the confused php.ini from the
install, (numerous extensions where copied right on top of the others so I
had double of the same extension many times. Path statements where placed
in strange places as well.
This was a small adjustment as anyone using PHP in time gets to know the
.ini file very well.
Hope this helps,
Blessings,
Chetan
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
>Gustav says:
>Anyone experienced trouble connecting to a MSSQL - Server but not every
>time? (About every third time the connection succeeds, fourth time,
fitfh >time and so on ...)(IIS + PHP + Win2003 Server)
>Best regards
>/Gustav Wiberg
Gustav says:
>
> Thanx all!
>
> The problem is solved. The MSI Windows installer added an extra \ to the
> path!? ...
>
> /Gustav
>
> Gustav Wiberg says:
>
>>MSSQL and PHP. Should I upgrade from PHP 5.0.1 to 5.2.2 for getting the
>>connection to MSSQL-database to work correctly?
>
>>Best regards
>>/Gustav Wiberg
Chetan says:
> Yesterday, I decided to update PHP521 to 522 and update the MySQL
> server/client to the latest as I was having strange connection problems.
>
> In the end the decision turned out to be just right.
> It took me several tries to delete the existing copy of MySQL in order to
> do a clean install.
> However, I now know what one has to do to remove the 'root' of MySQL
> program from Windows2000, he, he.
>
> PHP installs just fine with out doing a clean install. Just install right
> into the PHP directory. I had to fix the confused php.ini from the
> install, (numerous extensions where copied right on top of the others so I
> had double of the same extension many times. Path statements where placed
> in strange places as well.
> This was a small adjustment as anyone using PHP in time gets to know the
> .ini file very well.
>
> Hope this helps,
> Blessings,
> Chetan
>
One other note about inconsistensy in connection to DB, in the above
upgrading with both PHP and MySQL I also dnloaded the latest ODBC
connector and then dnloaded the latest "MySQL ODBC 3.51 driver" and my
connections are consistent now. I also checked the TCP/IP & MySQL
services on IIS.
The Wininstaller for PHP522 misstyped the c:\\php\ext;;" in my environment
variables path statement.
One does in time learn every place the PHP/SQL installation is connecting
and talking, and may check and make fixes.
Too bad it takes much time spent in pain and frustration to get there.
And I am still a baby in this big wide world of the Web and applications.
Blessings,
Chetan
--- End Message ---
--- Begin Message ---
Dynamically update mysql field
I have a function that will populate the table cells (TD) with data
(information) from mysql database.
What I need to do is to allow the user to update the cell information
(information was pulled from mysql database) from the table cells (TD) then the
data get updated in mysql. So when I pull the data again I can see the new
information.
Is there any way to do this using PHP?
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
--- End Message ---
--- Begin Message ---
sam rumaizan wrote:
Dynamically update mysql field
I have a function that will populate the table cells (TD) with data (information) from mysql database.
What I need to do is to allow the user to update the cell information
(information was pulled from mysql database) from the table cells (TD) then the
data get updated in mysql. So when I pull the data again I can see the new
information.
Is there any way to do this using PHP?
Yes I am sure that this can be done but we need more information before
recommending a solution.
--
Regards,
Alf Stockton www.stockton.co.za
The human race has one really effective weapon, and that is laughter.
-- Mark Twain
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--- End Message ---
--- Begin Message ---
Of course it can be done, but please be more specific about what you
wish to achieve.
Aleksander
sam rumaizan wrote:
Dynamically update mysql field
I have a function that will populate the table cells (TD) with data (information) from mysql database.
What I need to do is to allow the user to update the cell information
(information was pulled from mysql database) from the table cells (TD) then the
data get updated in mysql. So when I pull the data again I can see the new
information.
Is there any way to do this using PHP?
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
--- End Message ---
--- Begin Message ---
Copy and paste my code in your editor and run it then you will understand what
I need
<------------------------------------------------start code
--------------------------------------->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>data</TITLE>
</HEAD>
<BODY>
<H1> <font color ="red">You can change the information in any cell and submit
it to mysql to update the original database.
Basically when the user views his/her information he/she should have the
option to change the information.</font>
</H1>
<form>
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
<TR ALIGN="CENTER">
<TH>NAME</TH>
<TH>JOB TITLE</TH>
<TH> COLOR</TH>
<TH>ADDRESS</TH>
<TH>PHONE NO</TH>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>SAM <br><input type="submit" name="update"
value="update this cell"><br><font color ="red">You can change the information
and submit it to mysql to update the original database.</font> </TD>
<TD> data form mysql :<br><b>ENGENEER </TD>
<TD> data form mysql :<br><b>RED </TD>
<TD> data form mysql :<br><b>OKLAHOMA </TD>
<TD> data form mysql :<br><b>405-12452 </TD>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>JOHN </TD>
<TD> data form mysql :<br><b>DESIGNER <br><input type="submit" name="update"
value="update this cell"><br><font color ="red">You can change the information
and submit it to mysql to update the original database.</font> </TD>
<TD> data form mysql :<br><b>BLUE </TD>
<TD> data form mysql :<br><b>COLORADO </TD>
<TD> data form mysql :<br><b>303-5458 </TD>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>MIKE</TD>
<TD> data form mysql :<br><b>STUDENT </TD>
<TD> data form mysql :<br><b>GREEN<br><input type="submit" name="update"
value="update this cell"><br><font color ="red">You can change the information
and submit it to mysql to update the original database. </font> </TD>
<TD> data form mysql :<br><b>UTAH </TD>
<TD> data form mysql :<br><b>504-5670 </TD>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>JULI</TD>
<TD> data form mysql :<br><b>TEACHER</TD>
<TD> data form mysql :<br><b>PINK<br><input type="submit" name="update"
value="update this cell"><br><font color ="red">You can change the information
and submit it to mysql to update the original database.</font> </TD>
<TD> data form mysql :<br><b>TEXES </TD>
<TD> data form mysql :<br><b>405-6364 </TD>
</TR>
</TABLE>
</form>
</BODY>
</HTML>
<------------------------------------------------End code
--------------------------------------->
Aleksandar Vojnovic <[EMAIL PROTECTED]> wrote:
Of course it can be done, but please be more specific about what you
wish to achieve.
Aleksander
sam rumaizan wrote:
> Dynamically update mysql field
>
> I have a function that will populate the table cells (TD) with data
> (information) from mysql database.
> What I need to do is to allow the user to update the cell information
> (information was pulled from mysql database) from the table cells (TD) then
> the data get updated in mysql. So when I pull the data again I can see the
> new information.
> Is there any way to do this using PHP?
>
>
>
>
>
>
> ---------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check outnew cars at Yahoo! Autos.
>
---------------------------------
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
--- End Message ---
--- Begin Message ---
sam rumaizan wrote:
Copy and paste my code in your editor and run it then you will understand what
I need
Why do all your field definitions contain 'name="update"' ?
--
Regards,
Alf Stockton www.stockton.co.za
Fame is a vapor; popularity an accident; the only earthly certainty is
oblivion.
-- Mark Twain
My email disclaimer is available at www.stockton.co.za/disclaimer.html
--- End Message ---
--- Begin Message ---
Sorry I still don't understand. Do you wish to display/reload the data
on some timeout (ala AJAX) or you actually wish to update the data from
this form into the MySQL?
Aleksander
sam rumaizan wrote:
*Copy and paste my code in your editor and run it then you will
understand what I need*
*<------------------------------------------------start code
--------------------------------------->*
*<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>data</TITLE>*
*</HEAD>*
*<BODY>*
*<H1> <font color ="red">You can change the information in any cell
and submit it to mysql to update the original database.*
*Basically when the user views his/her information he/she should have
the option to change the information.</font>
</H1>
<form>
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
<TR ALIGN="CENTER">
<TH>NAME</TH>
<TH>JOB TITLE</TH>
<TH> COLOR</TH>
<TH>ADDRESS</TH>
<TH>PHONE NO</TH>
</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>SAM <br><input type="submit"
name="update" value="update this cell"><br><font color ="red">You can
change the information and submit it to mysql to update the original
database.</font> </TD>
<TD> data form mysql :<br><b>ENGENEER </TD>
<TD> data form mysql :<br><b>RED </TD>
<TD> data form mysql :<br><b>OKLAHOMA </TD>
<TD> data form mysql :<br><b>405-12452 </TD>*
*</TR>
<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>JOHN </TD>
<TD> data form mysql :<br><b>DESIGNER <br><input type="submit"
name="update" value="update this cell"><br><font color ="red">You can
change the information and submit it to mysql to update the original
database.</font> </TD>
<TD> data form mysql :<br><b>BLUE </TD>
<TD> data form mysql :<br><b>COLORADO </TD>
<TD> data form mysql :<br><b>303-5458 </TD>*
*</TR>*
*<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>MIKE</TD>
<TD> data form mysql :<br><b>STUDENT </TD>
<TD> data form mysql :<br><b>GREEN<br><input type="submit"
name="update" value="update this cell"><br><font color ="red">You can
change the information and submit it to mysql to update the original
database. </font> </TD>
<TD> data form mysql :<br><b>UTAH </TD>
<TD> data form mysql :<br><b>504-5670 </TD>*
*</TR>*
*<TR ALIGN="CENTER" HEIGHT="80" >
<TD> data form mysql :<br><b>JULI</TD>
<TD> data form mysql :<br><b>TEACHER</TD>
<TD> data form mysql :<br><b>PINK<br><input type="submit"
name="update" value="update this cell"><br><font color ="red">You can
change the information and submit it to mysql to update the original
database.</font> </TD>
<TD> data form mysql :<br><b>TEXES </TD>
<TD> data form mysql :<br><b>405-6364 </TD>*
*</TR>
</TABLE>*
**
* *
*
</form>*
* *
*</BODY>
</HTML>
*
*<------------------------------------------------End code
--------------------------------------->*
* *
*
/Aleksandar Vojnovic <[EMAIL PROTECTED]>/* wrote:
Of course it can be done, but please be more specific about what you
wish to achieve.
Aleksander
sam rumaizan wrote:
> Dynamically update mysql field
>
> I have a function that will populate the table cells (TD) with
data (information) from mysql database.
> What I need to do is to allow the user to update the cell
information (information was pulled from mysql database) from the
table cells (TD) then the data get updated in mysql. So when I
pull the data again I can see the new information.
> Is there any way to do this using PHP?
>
>
>
>
>
>
> ---------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check outnew cars at Yahoo! Autos.
>
------------------------------------------------------------------------
Get your own web address.
<http://us.rd.yahoo.com/evt=49678/*http://smallbusiness.yahoo.com/domains/?p=BESTDEAL>
Have a HUGE year through Yahoo! Small Business.
<http://us.rd.yahoo.com/evt=49678/*http://smallbusiness.yahoo.com/domains/?p=BESTDEAL>
--- End Message ---
--- Begin Message ---
Hello all,
I am having a problem sending an email from PHP 4.1.3/IIS 5.0. I am using a
PHP Class called phpmailer. The problem occurs when the mailer tries to open
a socket to my SMTP server. I can get the same error with this little bit of
code:
// Begin test code
$fp = fsockopen("smtp.example.com", 25, $errno, $errstr, 30);
if($errno == 0 && !$fp){
// error occurred before the socket was opened
print "Error occurred before connect() call";
}elseif(!$fp){
// error opening socket
print "$errstr ($errno)<br>\n";
}else{
print "socket opened";
}
// End test code
When I run the code above, this is the output:
Bad file descriptor (9)
Can anyone tell me what this error means?
The server is provided by my ISP so I have no control over it.
Thanks,
James
--
James Crow
IT Manager
ULTRATAN, Inc.
15 Santuck St.
Greenville, SC 29611
--- End Message ---
--- Begin Message ---
I have a situation where I am unable to connect to a Microsoft SQL
2005 Database from Windows Server 2003 (IIS + PHP 5.0.4).
here is the code:
<?php
require_once 'DB.php';
$dsn = "mssql://aspj_transfer:[EMAIL PROTECTED]/transfer_station";
$db = DB::connect($dsn);
if (DB::isError($db))
{
die ($db->getMessage().'<br>'.$db->getUserInfo());
}
// no useful info. just trying to return something.
$query = "select [name] as n from sysobjects order by [name]";
$data =& $db->query($query);
while ($row = $data->fetchRow())
{
echo $row[0]."<br>";
}
$db->disconnect();
?>
Here is the error:
[DB Error: connect failed] **
mssql://aspj_transfer:[EMAIL PROTECTED]/transfer_station
From my workstation, this can connect just fine (Windows XP, IIS, PHP 5.0.4).
There aren't any firewalls between the machines.
Any suggestions?
Jody
--- End Message ---
