[PHP-DEV] Re: MSSQL DB Connect

[Jerry]

Thanks Jeremy, I finally found the solution:

 0){
 print "Number of rows: $number";
while($i < $number){
 $dateval= mssql_result($result,$i,"dateval");
 echo "$dateval";
 $i++;}
}?>

And it works fine !
Now I'm looking for the same function for IBM DB2 database connection...

Jerry

"Jeremy Reed" <[EMAIL PROTECTED]> wrote:
> What was the error message you received?  Also, when passing the variables
> to the mssql_connect() function, you need not use quotes since you've
> already initialized them to the strings.  Pass them as follows:
$connection
> = mssql_connect($a,$b,$c).  Also, you aren't passing the actual sql string
> to the mssql_query() function.  You have $sql = "blah" but you pass
> $sql_temp.

> Jerry wrote:

> > Hi

> > I have PHP on windows 2000 web server
> > I would like to remote to a MS SQL database on another web server.
> > I tried something like:

> >  > $h = "server adr";
> > $u = "user";
> > $p = "passw";
> > $b = "db";
> > $connexion = mssql_connect("$h", "$u", "$p");
> > mssql_select_db($b);
> > $sql_temp= "select * from test";
> > $result = mssql_query($sql_temp);
> > mssql_close($connexion);
> > ?>

> > But it didn't work. Please help me.

> > Jerry








-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] MS SQL Connection

[Jerry]

Hi,

I'm new in PHP, using more JavaScript.
I would like to know how to connect to a MS SQL DB on a window 2000 server
using my machine as a local web server (window 2000 workstation)
I believed the beginning would be:

But It doesn't seem to work... Then what will I write after that to connect
to a DB called sales ?

Thanks.

Jerry



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] MSSQL DB Connect

[Jerry]

Hi

I have PHP on windows 2000 web server
I would like to remote to a MS SQL database on another web server.
I tried something like:



But it didn't work. Please help me.

Jerry



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] MSSQL connect

[Jerry]

Hi

I have PHP on windows 2000 web server
I would like to remote to a MS SQL database on another web server.
I tried something like:



But it didn't work. Please help me.

Jerry



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] Bug #12728: PHP4DLL project fails to compile

[jerry]

From: [EMAIL PROTECTED]
Operating system: Win32
PHP version:  4.0.6
PHP Bug Type: Compile Failure
Bug description:  PHP4DLL project fails to compile

Using the project files directly from php-4.0.6.tar.gz 
I get the following compilation errors:

Please note that this is true for both Win32 debug and Win32 release
builds

Configuration: php4dll - Win32
Release
Compiling...
cyr_convert.c
..\TSRM\tsrm_win32.h(48) : error C2054: expected '(' to follow 'TSRM_API'
..\TSRM\tsrm_win32.h(48) : error C2085: 'tsrm_win32_startup' : not in
formal parameter list
..\TSRM\tsrm_win32.h(49) : error C2061: syntax error : identifier
'TSRM_API'
..\TSRM\tsrm_win32.h(50) : error C2054: expected '(' to follow 'TSRM_API'
..\TSRM\tsrm_win32.h(50) : error C2085: 'popen' : not in formal parameter
list
..\TSRM\tsrm_win32.h(51) : error C2061: syntax error : identifier
'TSRM_API'
fopen_wrappers.c
..\TSRM\tsrm_win32.h(48) : error C2054: expected '(' to follow 'TSRM_API'
..\TSRM\tsrm_win32.h(48) : error C2085: 'tsrm_win32_startup' : not in
formal parameter list
..\TSRM\tsrm_win32.h(49) : error C2061: syntax error : identifier
'TSRM_API'
..\TSRM\tsrm_win32.h(50) : error C2054: expected '(' to follow 'TSRM_API'
..\TSRM\tsrm_win32.h(50) : error C2085: 'popen' : not in formal parameter
list
..\TSRM\tsrm_win32.h(51) : error C2061: syntax error : identifier
'TSRM_API'
D:\data\download\php\php-4.0.6.tar\php-4.0.6\main\php_network.h(28) : fatal
error C1083: Cannot open include file: 'arpa/inet.h': No such file or
directory
main.c
..\TSRM\tsrm_win32.h(48) : error C2054: expected '(' to follow 'TSRM_API'
..\TSRM\tsrm_win32.h(48) : error C2085: 'tsrm_win32_startup' : not in
formal parameter list
..\TSRM\tsrm_win32.h(49) : error C2061: syntax error : identifier
'TSRM_API'
..\TSRM\tsrm_win32.h(50) : error C2054: expected '(' to follow 'TSRM_API'
..\TSRM\tsrm_win32.h(50) : error C2085: 'popen' : not in formal parameter
list
..\TSRM\tsrm_win32.h(51) : error C2061: syntax error : identifier
'TSRM_API'
cl.exe terminated at user request.
Tool execution canceled by user.

-- 
Edit bug report at: http://bugs.php.net/?id=12728&edit=1


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] PHP 4.0 Bug #8849: open_basedir doesn't apply to function 'copy'

[jerry . zhao]

From: [EMAIL PROTECTED]
Operating system: Solaris 7
PHP version:  4.0.4pl1
PHP Bug Type: *Configuration Issues
Bug description:  open_basedir doesn't apply to function 'copy'

To make "open_basedir" config option more useful for 
filesystem protection, please consider adding 
the function "copy" to the list of functions that take
advantage of it.


-- 
Edit Bug report at: http://bugs.php.net/?id=8849&edit=1



-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] PHP 4.0 Bug #8848: "open_basedir = /dir/incl" validates "/dir/include" and so on

[jerry . zhao]

From: [EMAIL PROTECTED]
Operating system: Solaris 7
PHP version:  4.0.4pl1
PHP Bug Type: *Configuration Issues
Bug description:  "open_basedir = /dir/incl" validates "/dir/include" and so on 

Setting "open_basedir = /dir/incl" allows access to 
"/dir/include" or "/dir/incls" or similar


-- 
Edit Bug report at: http://bugs.php.net/?id=8848&edit=1



-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]