ODBC prepared statements in PHP

by

Try removing the single quotes from the query string and adding them to the parameter value itself:

$pstmt=odbc_prepare($odb_con,"select * from configured where param_name=?");
$res=odbc_execute($pstmt,array(" 'version'"));
var_dump($res);  //bool(true)
$row = odbc_fetch_array($pstmt);
var_dump($row);  //bool(false)

The single space character at the beginning of the parameter value is very important–if the space is not there, it will treat the variable as a path to a file.

From http://www.php.net/manual/en/function.odbc-execute.php:

If you wish to store a string which
actually begins and ends with single
quotes, you must add a space or other
non-single-quote character to the
beginning or end of the parameter,
which will prevent the parameter from
being taken as a file name.

More Related Contents:

  1. Can I bind an array to an IN() condition in a PDO query?
  2. Use an array in a mysqli prepared statement: `WHERE .. IN(..)` query [duplicate]
  3. Call to a member function bind_param() on a non-object [duplicate]
  4. How to use mysqli prepared statements?
  5. MySQLi prepared statements error reporting [duplicate]
  6. How to bind mysqli bind_param arguments dynamically in PHP?
  7. Call to a member function prepare() on a non-object PHP Help
  8. MySQL Prepared statements with a variable size variable list
  9. LIMIT keyword on MySQL with prepared statement [duplicate]
  10. mysqli: can it prepare multiple queries in one statement?
  11. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  12. Is mysql_real_escape_string() broken?
  13. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  14. pdo prepared statements with wildcards
  15. PHP UPDATE prepared statement
  16. Get last insert id after a prepared insert with PDO
  17. PHP PDO::bindParam() data types.. how does it work?
  18. CodeIgniter MSSQL connection
  19. MySQLi prepared statements with IN operator [duplicate]
  20. Is mysql_real_escape_string() necessary when using prepared statements?
  21. Which tokens can be parameterized in PDO prepared statements?
  22. How to avoid code repetition with PHP SQL prepared statements?
  23. Retrieve (or simulate) full query from PDO prepared statement
  24. PDO error: SQLSTATE[HY000]: General error: 2031
  25. Using fetch_assoc on prepared statements
  26. How to prepare statement for update query? [duplicate]
  27. Use of PDO in classes [duplicate]
  28. How to connect PHP with Microsoft Access database
  29. Dynamically bind mysqli_stmt parameters and then bind result
  30. Check to see if an email is already in the database using prepared statements

Leave a Comment