DaniWeb Forum Index > Web Development > PHP

Creating a dynamic query using MSSQL and PHP

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2007

Posts: 6

Reputation: daver40 is an unknown quantity at this point

Solved Threads: 0

daver40

Offline

Newbie Poster

Creating a dynamic query using MSSQL and PHP

Oct 18th, 2007

I'm a bit of a beginning to PHP, so I hope that this question isn't too terribly simple. I'm trying to write a flexible query that will use data from an HTML form to create a SELECT statement for a MSSQL database. I've tried writing a sample query, but I can't seem to get any data out of the database.

Here's my code:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
from sqlmain.html
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
 
<body>
<form action="ms_sql.php" method="get" name="main">
<input name="name" type="text">
<input name="submit" type="submit" value="Submit">
</form>
</body>
</html>
 
from ms_sql.php
 
$host ='mssql.library.univ.edu';
$user = 'LIB_webuser';
$pass ='######';
$db =  'LIB';
 
//Open connection
 
$connection = mssql_connect($host, $user, $pass) or die("Unable to connect");
 
//Select database
 
mssql_select_db($db) or die("Unable to select database");
 
//Create query
 
//$query = "SELECT * FROM dbo.dbd";
$name = $_POST['name'];
 
$query = "SELECT $name FROM bdb";
 
// Execute query
 
$result = mssql_query($query);
 
while($row = mssql_fetch_array($result)){
	echo $row['netid'];
	echo "<br />";
 
//free result set memory
 
mssql_free_result($result);
 
//close connection
 
mssql_close($connection);
from sqlmain.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<form action="ms_sql.php" method="get" name="main">
<input name="name" type="text">
<input name="submit" type="submit" value="Submit">
</form>
</body>
</html>

from ms_sql.php

$host ='mssql.library.univ.edu';
$user = 'LIB_webuser';
$pass ='######';
$db =  'LIB';

//Open connection

$connection = mssql_connect($host, $user, $pass) or die("Unable to connect");

//Select database

mssql_select_db($db) or die("Unable to select database");

//Create query

//$query = "SELECT * FROM dbo.dbd";
$name = $_POST['name'];

$query = "SELECT $name FROM bdb";

// Execute query

$result = mssql_query($query);

while($row = mssql_fetch_array($result)){
	echo $row['netid'];
	echo "<br />";

//free result set memory

mssql_free_result($result);

//close connection

mssql_close($connection);