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.; php-windows@lists.php.net
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: php-windows@lists.php.net
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
