odbc_next_result(3) [php man page]

ODBC_NEXT_RESULT(3)							 1						       ODBC_NEXT_RESULT(3)

odbc_next_result - Checks if multiple results are available

SYNOPSIS

       bool odbc_next_result (resource	$result_id)

DESCRIPTION

	Checks	if  there  are	more  result  sets  available  as  well  as  allowing  access  to  the	next  result  set via odbc_fetch_array(3),
       odbc_fetch_row(3), odbc_result(3), etc.

PARAMETERS

	      o $result_id
		- The result identifier.

RETURN VALUES

	Returns TRUE if there are more result sets, FALSE otherwise.

EXAMPLES

       Example #1

	      odbc_next_result(3)

	      <?php
	      $r_Connection = odbc_connect($dsn, $username, $password);

	      $s_SQL = <<<END_SQL
	      SELECT 'A'
	      SELECT 'B'
	      SELECT 'C'
	      END_SQL;

	      $r_Results = odbc_exec($r_Connection, $s_SQL);

	      $a_Row1 = odbc_fetch_array($r_Results);
	      $a_Row2 = odbc_fetch_array($r_Results);
	      echo "Dump first result set";
	      var_dump($a_Row1, $a_Row2);

	      echo "Get second results set ";
	      var_dump(odbc_next_result($r_Results));

	      $a_Row1 = odbc_fetch_array($r_Results);
	      $a_Row2 = odbc_fetch_array($r_Results);
	      echo "Dump second result set ";
	      var_dump($a_Row1, $a_Row2);

	      echo "Get third results set ";
	      var_dump(odbc_next_result($r_Results));

	      $a_Row1 = odbc_fetch_array($r_Results);
	      $a_Row2 = odbc_fetch_array($r_Results);
	      echo "Dump third result set ";
	      var_dump($a_Row1, $a_Row2);

	      echo "Try for a fourth result set ";
	      var_dump(odbc_next_result($r_Results));
	      ?>

	      The above example will output:

	      Dump first result set array(1) {
		["A"]=>
		string(1) "A"
	      }
	      bool(false)
	      Get second results set bool(true)
	      Dump second result set array(1) {
		["B"]=>
		string(1) "B"
	      }
	      bool(false)
	      Get third results set bool(true)
	      Dump third result set array(1) {
		["C"]=>
		string(1) "C"
	      }
	      bool(false)
	      Try for a fourth result set bool(false)

PHP Documentation Group 												       ODBC_NEXT_RESULT(3)

Check Out this Related Man Page

MYSQLND_MS_MATCH_WILD(3)						 1						  MYSQLND_MS_MATCH_WILD(3)

mysqlnd_ms_match_wild - Finds whether a table name matches a wildcard pattern or not

SYNOPSIS

       bool mysqlnd_ms_match_wild (string  $table_name, string	$wildcard)

DESCRIPTION

	Finds whether a table name matches a wildcard pattern or not.

	This  function	is  not of much practical relevance with PECL mysqlnd_ms 1.1.0 because the plugin does not support MySQL replication table
       filtering yet.

PARAMETERS

	      o $table_name
		- The table name to check if it is matched by the wildcard.

	      o $wildcard
		- The wildcard pattern to check against the table name. The wildcard pattern supports the same placeholders as	MySQL  replication
		filters do.  MySQL replication filters can be configured by using the MySQL Server configuration options --replicate-wild-do-table
		and --replicate-wild-do-db. Please, consult the MySQL Reference Manual to learn more about this MySQL Server  feature.	 The  sup-
		ported placeholders are:

		     o % - zero or more literals

		     o _ - one literal

	       Placeholders can be escaped using .

RETURN VALUES

	Returns TRUE table_name is matched by wildcard. Otherwise, returns FALSE

EXAMPLES

       Example #1

	      mysqlnd_ms_match_wild(3) example

	      <?php
	      var_dump(mysqlnd_ms_match_wild("schema_name.table_name", "schema%"));
	      var_dump(mysqlnd_ms_match_wild("abc", "_"));
	      var_dump(mysqlnd_ms_match_wild("table1", "table_"));
	      var_dump(mysqlnd_ms_match_wild("asia_customers", "%customers"));
	      var_dump(mysqlnd_ms_match_wild("funny%table","funny\%table"));
	      var_dump(mysqlnd_ms_match_wild("funnytable", "funny%table"));
	      ?>

	      The above example will output:

	      bool(true)
	      bool(false)
	      bool(true)
	      bool(true)
	      bool(true)
	      bool(true)

PHP Documentation Group 												  MYSQLND_MS_MATCH_WILD(3)

Linux and UNIX Man Pages

odbc_next_result(3) [php man page]

Check Out this Related Man Page