Hello,
I have a problem when i try to connect to my MS SQL database. When i go to localhost in my web browser i get this error:
HTTP-fout 500.0 - Internal Server Error
C:\Program Files\PHP\php-cgi.exe - The FastCGI-proces exited unexpectedly
| Module | FastCgiModule |
|---|
| Melding | ExecuteRequestHandler |
|---|
| Handler | PHP_via_FastCGI |
|---|
| Foutcode | 0x000000ff |
|---|
| Aangevraagde URL | http://localhost:80/index.php |
|---|
| Fysiek pad | C:\inetpub\wwwroot\index.php |
|---|
| Aanmeldingsmethode | Anoniem |
|---|
| Aangemelde gebruiker | Anoniem |
|---|
(The FastCGI-proces exited unexpectedly may be wrong translated, but i think you know what i mean?)
Here is my index.php file:
<html>
<head>
<title>Monitor met zoekfunctie</title>
</head>
<body>
<div id="header">
Header
</div>
<br />
<div id="Zoeken">
Zoeken
</div>
<br />
<div id="Monitor">
<?php
$myServer = "SYSADMIN-PC\SQLEXPRESS";
$myUser = "myusername";
$myPass = "mypassword";
$myDB = "cdr";
$conn = mssql_connect($myServer, $myUser, $myPass)
or die ("Kan niet verbinden met $myServer");
$selected = mssql_select_db($myDB, $conn)
or die ("Kan de volgende database niet openen: $myDB");
echo "Je bent verbonden met de database " . $myDB . " op de server " . $myServer . ".";
echo "<br />";
$query = "SELECT TOP 20 CallId FROM Table_1";
$result = mssql_query($query);
while($row = mssql_fetch_array($result))
{
echo $row["CallId"];
echo "<br />";
}
mssql_close($conn);
?>
</div>
</body>
</html>
This DID work but now (a few days after i installed IIS and PHP) i get the error page.
I'm running IIS 7.5 and Windows 7.
I hope someone can help me.