php-windows Digest 20 Jun 2008 16:15:33 -0000 Issue 3488
Topics (messages 28942 through 28943):
Re: MSSQL and ODBC Connections with PHP on Windows
28942 by: Wei, Alice J.
Get PHP Errors To Display
28943 by: Wei, Alice J.
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 ---
Hi, Eric:
I use both, although I found that I have only been using Windows Auth when I
log on, since I have not yet figured out how to get the "mssql server auth" to
work. Would this matter with the connection?
What year is this dll file? Last time when I downloaded one from online, (I
am not sure what year it was published), my PHP could no longer wrong. But, I
will give it a shot.
Alice
-----Original Message-----
From: Eric [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 3:32 AM
To: PHP-WINDOWS; Wei, Alice J.
Subject: Re: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows
Please download this newer ntwdblib.dll from here
http://myprojects.srhost.info/download/ntwdblib.zip
and place this file into %systemroot%\system32 folder
Also, do you use intergrated auth. or mixed auth mode of mssql server auth. ?
----- Original Message -----
From: "Wei, Alice J." <[EMAIL PROTECTED]>
To: "Zephaniah ha Levi" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2008 4:47 AM
Subject: RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows
Hi,
Using the mssql connection has so far given me more trouble, and I did use
your code, which only gives me error messages. I did try to telnet it to make
sure that the server exists, and I was in.
Here is the code:
<html>
<head>
<title>PHP SQL Database</title>
</head>
<body>
<?php
echo "<p>hello</p>";
$server = "localhost,1433";
$username = "username";
$password = "pass";
$sqlconnect = mssql_connect($server, $username, $password) or DIE("Can't
Connect to server.");
$sqldb = mssql_select_db("mydb", $sqlconnect);
$SqlSelectData = "select Name from patient";
$results = mssql_query($SqlSelectData);
while($nameresults = mssql_fetch_array($results)){
$Name = $namereults['Name'];
echo "<p>Here are the results:</p>";
echo "<p>$Name<br>";
$n++;
}
mssql_close($sqlconnect);
?>
</body>
</html>
In my php.ini file, extension=php_mssql.dll was downloaded and loaded into
C:/PHP/ext. I have added a line to give me errors, and it does pop up a window
that says mssql was loaded. Therefore, does this mean that my extension is
working? Or, is there is any glitch for me to see additonal error reports to
show what kind of error I may be really getting?
Thanks in advance.
Alice
======================================================
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
[EMAIL PROTECTED]
________________________________________
From: Zephaniah ha Levi [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2008 10:53 AM
To: Wei, Alice J.; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows
Why use odbc?
Why not something like:
$server = "localhost";
$username = "USER";
$password = "Password";
$sqlconnect = mssql_connect($server, $username, $password) or DIE("Can't
Connect to server.");
$sqldb = mssql_select_db("DB", $sqlconnect);
$SqlSelectData = "select * from tablename";
$results = mssql_query($SqlSelectData);
while($nameresults = mssql_fetch_array($results)){
$Name = $namereults(['Name']);
echo "$Name<br>";
}
Mssql_Close($sqlconnect)
Or somethignt like that. You need to make sure that the mssql extension is
loaded in your php.ini.
-----Original Message-----
From: Wei, Alice J. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2008 10:45 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows
Hi,
I am a newbie using the combination of PHP and MSSQL together.
Can anyone tell me which method it might be better as far as using PHP on
Windows with MSSQL database on a single machine? (The PHP and MSSQL database
are not set up remotely on two different servers.
I have set up both, and my ODBC Driver does work when I run it from the
test without using PHP, and yet when I put it in PHP, my entire screen goes
blank.
$dsn="MSSQL";
$username="user";
$password="password";
$sqlconnect=odbc_connect($dsn,$username,$password);
$sqlquery="SELECT title FROM books";
$process=odbc_exec($sqlconnect, $sqlquery);
while(odbc_fetch_row($process)){
$Name = odbc_result($process,"Name");
echo "$Name<br>"; }
odbc_close($sqlconnect);
The similar thing happens when I use the code by using a slight modification
from http://us3.php.net/manual/en/function.mssql-connect.php.
Can anyone please provide me some tips and solutions on what additional
modules or set up I need to get this to work? I was told that if I use
Windows, I may not have to use FreeTDS.
Thanks in advance.
======================================================
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
[EMAIL PROTECTED]
--
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 ---
Hi,
I am wondering if any of you on the list would know if I wanted to see any
PHP errors shown up on the browser screen instead of seeing a blank screen,
like the one below:
PHP Parse error: syntax error, unexpected T_LNUMBER, expecting ',' or ';' in
/root/Desktop/test.php on line 127
How can I get it to show up? (Note: I got the error message above by putting
it on the Solaris system)
I welcome any suggestions.
Alice
======================================================
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
[EMAIL PROTECTED]
--- End Message ---
