RE: MSSQL and ODBC Connections with PHP on Windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
ajwei@xxxxxxxxxxx
________________________________________
From: Zephaniah ha Levi [zleviticus@xxxxxxxxxxxxxx]
Sent: Wednesday, June 18, 2008 10:53 AM
To: Wei, Alice J.; php-windows@xxxxxxxxxxxxx
Subject: RE:  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:ajwei@xxxxxxxxxxx]
Sent: Wednesday, June 18, 2008 10:45 AM
To: php-windows@xxxxxxxxxxxxx
Subject:  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
ajwei@xxxxxxxxxxx

--
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



[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux