string for odbc_fetch_array() help

sharijl · #1 (**permalink**) 06-29-07, 10:35 AM

constructing search page and using PHP odbc to connect and query Microsoft SQL. I have my connection but the search string is not working. What am I doing wrong here?

PHP Code:


			
<?php 



if (!isset($_POST['submit'])) 

{

            

  //Collect Form Data

                        

  $string = $_POST['location'];

                        

  //Establish data connection

                        

  $database = "dbname"; 

  $odbc = odbc_connect($database,"user","password");

                        

  //Issue SQL SELECT Statement

                        

  $sql = "SELECT * FROM tablename WHERE location = '$string'";

                        

  $rs = odbc_exec($odbc, $sql);

            }



?>





<!DOCTYPE html PUBLIC "-//W3C/DTD/XHTML 1.0 Transitional//EN"

            "http://www.w3.org/TR/xhtml1/DTD/xhtml11-transitional.dtd">

            

            

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>

<title>search</title>



<style>

  

  body {margin:15px;font:10pt Verdana}

  td {vertical-align:top;border:solid 1px gray}

  input,textarea{border:0px}

  

  </style>

  

 </head>

 

 <body>

 

 <form action="Search.php" method="post">

 <p>&nbsp;</p>

 <table>

 <tr>

 <td colspan="2">&nbsp;</td>

 </tr>

 <td><input type="text" size="15" name="location"/></td>

   <td><input type="submit" value="Search" name="submit"/>

 </tr>

 </table>

 </form>

  

 <div>

 

 <?php

 

 if(!empty($_REQUEST))

 {

            while($row = odbc_fetch_array($rs)) 

            

            {

            

            echo "Name: " .$row['name'] . "  ";

            echo  $row['comments'] . "<br/>";

            }

            

            odbc_close($odbc);

 }          

 ?>

 

 </div>

 </body>

 </html>

error message points to:

PHP Code:


			
while($row = odbc_fetch_array($rs))

as the problem but the issue is with

PHP Code:


			
$sql = "SELECT * FROM tablename WHERE location = '$string'";

$string = $_POST['location'];

because the connection is good.

Here is the exact error message I am concerned with:

PHP Code:


			
Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in E:\Inetpub\wwwroot\Search.php on line 63



Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in E:\Inetpub\wwwroot\Search.php on line 71

Nico · #2 (**permalink**) 06-29-07, 10:36 AM

Topic moved to database.

sharijl · #3 (**permalink**) 06-29-07, 10:40 AM

Don't think this is db issue because I can run the same query directly in SQL and it works fine. I think I need help with the PHP string? What do you think?

Nico · #4 (**permalink**) 06-29-07, 10:49 AM

The errors you get are from ODBC. Plus you posted this in ASP, so I felt like moving it.

UnrealEd · #5 (**permalink**) 06-29-07, 11:05 AM

to debug your code, add odbc_errormsg() after each odbc_exec call:

PHP Code:


			
$rs = odbc_exec ( $odbc, $sql ) or die ( odbc_errormsg() );

and tell us what the outcome is

more information on odbc_errormsg:
http://be2.php.net/manual/en/function.odbc-errormsg.php

sharijl · #6 (**permalink**) 06-29-07, 04:29 PM

Oh .... I understand -- sorry about putting in ASP (thought it was in PHP)

The outcome was this error:

Undefined variable: rs
Undefined variable: odbc

I know the odbc is my connection and rs is the result of the connection and the string. I think I have the search string wrong. The input entered should the string value.

jfulton · #7 (**permalink**) 06-30-07, 01:48 PM

Are you actually getting a successful connection to the database with the odbc_connect() call?

Oh, and moving to php

.

sharijl · #8 (**permalink**) 06-30-07, 03:53 PM

db connections are correct.