Member Avatar for daver40

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:

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

  • 3 Contributors
  • 5 Replies
  • 126 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by mandragora
Member Avatar for fatihpiristine

try this:
$name = $_REQUEST;

Member Avatar for daver40

Thanks for the help! I'm going to be testing out the code tomorrow, and I'll let you know if it works.

Member Avatar for daver40

try this:
$name = $_REQUEST;

It works! Thanks.

Member Avatar for fatihpiristine

welcome

Member Avatar for mandragora

Just an brief explanation...

...
<form action="ms_sql.php" method="get" name="main">
...
$name = $_POST;
...

You tried to read data from POST array, but you send your query thru GET array. If you want to do this, use $_REQUEST array as someone said

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.