•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 456,552 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,472 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 2118 | Replies: 5
 |
•
•
Join Date: Oct 2007
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Creating a dynamic query using MSSQL and PHP 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:
Thanks for the help!
David
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
•
•
Join Date: Sep 2007
Location: Budapest
Posts: 252
Reputation: 
Rep Power: 0
Solved Threads: 14
Posting Whiz in Training
try this:
$name = $_REQUEST['name'];
$name = $_REQUEST['name'];
Do a favour, leave me alone
•
•
Join Date: Oct 2007
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thanks for the help! I'm going to be testing out the code tomorrow, and I'll let you know if it works.
•
•
Join Date: Oct 2007
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by fatihpiristine 
try this:
$name = $_REQUEST['name'];
It works! Thanks.
•
•
Join Date: Sep 2007
Location: Budapest
Posts: 252
Reputation:
Rep Power: 0
Solved Threads: 14
Posting Whiz in Training
welcome
Do a favour, leave me alone
•
•
Join Date: Nov 2007
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Creating a dynamic query using MSSQL and PHP Just an brief explanation...
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
•
•
•
•
Originally Posted by daver40
...
<form action="ms_sql.php" method="get" name="main">
...
$name = $_POST['name'];
...
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
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Compile PHP (PHP)
- Dynamic query string (Search Engine Optimization)
- mssql_fetch_array or mssql_query is stripping out a space in PHP (PHP)
- Creating a login page in PHP (PHP)
- MSSQL and ASP Query (ASP.NET)
- Googles php and MySQL preferences (Search Engine Optimization)
- php adodb library connect remote mysql (PHP)
- Dynamic Next/Prev Buttons in PHP/MySQL (MySQL)
- Enabling MSSQL Function in the PHP.ini (PHP)
Other Threads in the PHP Forum
- Previous Thread: Problem with creating scheduling program
- Next Thread: Question
