Returning Result from Query with ODBC Connection

Q

How To Receive Returning Result from a Query?

✍: Guest

A

When you execute a SQL SELECT statement with the odbc_exec() function, you can capture the returning result with a result set object with the following syntax:

$result_set = odbc_exec($sql_statement);
#- The returning value could be a Boolean value FALSE, 
#- if the execution failed.

Data rows and field values in the result set object can be retrieved using other ODBC functions as shown in the tutorial PHP script below:

<?php
  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');

  $sql = 'SELECT GETDATE()';
  $res = odbc_exec($con, $sql);
  odbc_fetch_row($res);
  $date = odbc_result($res,1);
  print("Database current time: ". $date ."\n");

  odbc_close($con); 
?>

If you run this script, you will get something like this:

Database current time: 2007-06-02 22:07:05.110

⇒ odbc_fetch_row() - Looping through Result Set Objects

⇐ Turning Off PHP Warning Messages for ODBC Connection

⇑ SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution

⇑⇑ SQL Server Connection Tutorials

2024-07-17, 2150🔥, 1💬

odbc_exec() - Executing SQL Statements
How To Execute a SQL Statement using odbc_exec()? Once you have created an ODBC connection object, you can use the odbc_exec() function to send a SQL statement to the SQL Server linked to the connection object for execution. Here is a simple PHP script that creates a new schema and a new table: &... 2024-06-30, 2496🔥, 0💬

odbc_prepare() - Creating Prepared Statements
How To Create Prepared Statements using odbc_prepare()? If you have a SQL statement that need to executed repeatedly many times with small changes, you can create a prepared statement object with parameters so it can be executed more efficiently. There are two functions you need to use prepare and e... 2024-06-03, 2482🔥, 0💬

Turning Off PHP Warning Messages for ODBC Connection
How To Turn Off Warning Messages during PHP Execution? If don't want see warning messages generated from the PHP engine when executing PHP scripts, you can change the error_reporting setting in the php.ini configuration file. Open php.ini and change the following lines: ;error_reporting = E_ALL &... 2024-06-30, 2280🔥, 0💬

odbc_fetch_row() - Looping through Result Set Objects
How To Loop through Result Set Objects using odbc_fetch_row()? If the returning output of a query statement is captured in a result set object, you can use odbc_fetch_row() to loop through each row in the output. The tutorial PHP script below shows you how to list tables in the database: <?ph... 2024-06-30, 2247🔥, 0💬

odbc_tables() - Listing All Tables in the Database
How To List All Tables in the Database using odbc_tables()? If you want to get a list of all tables in the database, you can use the odbc_tables() function, which can actually be used to list all tables and views in the database. The syntax of odbc_tables() is: $result_set = odbc_tables($connection_... 2024-07-11, 2164🔥, 0💬

odbc_result() - Retrieve Field Values
How To Retrieve Field Values using odbc_result()? After calling odbc_fetch_row(), the field values of the fetched row are available in the result set object. You can use odbc_result() to retrieve the value of any given field with two syntax formats: $value = odbc_result($field_name); #- Retrieving v... 2024-07-11, 2158🔥, 0💬

Returning Result from Query with ODBC Connection
How To Receive Returning Result from a Query? When you execute a SQL SELECT statement with the odbc_exec() function, you can capture the returning result with a result set object with the following syntax: $result_set = odbc_exec($sql_statement); #- The returning value could be a Boolean value FALSE... 2024-07-17, 2151🔥, 1💬

odbc_data_source() - Listing All DSN Entries
How To List All DSN Entries on Your Local Machine using odbc_data_source()? If you are interested to know what DSN entries are available on your local machine, you can use odbc_data_source($con, SQL_FETCH_FIRST) and odbc_data_source($con, SQL_FETCH_NEXT) in a loop to list all DSN entries defined on ... 2024-07-11, 2131🔥, 0💬

odbc_columns() - Listing All Columns in a Table
How To List All Columns in a Table using odbc_columns()? If you want to get a list of all columns in a table, you can use the odbc_columns() function, which can actually be used to list all columns in all tables and views in the database. The syntax of odbc_columns() is: $result_set = odbc_columns($... 2024-06-03, 2111🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.