RSS

Creating a dynamic query using MSSQL and PHP

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Views: 2339 | Replies: 5 | Thread Tools Display Modes

•

Previous Post in Thread

Next Post in Thread

•

Join Date: Oct 2007

Posts: 6

Reputation: daver40 is an unknown quantity at this point

Rep Power: 0

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

(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);

Thanks for the help!

David