maxdb_warning_count(3) [php man page]

MAXDB_WARNING_COUNT(3)							 1						    MAXDB_WARNING_COUNT(3)

maxdb_warning_count - Returns the number of warnings from the last query for the given link

       Procedural style

SYNOPSIS

       int maxdb_warning_count (resource  $link)

DESCRIPTION

       Object oriented style
       int$maxdb->warning_count ()

       maxdb_warning_count(3) returns the number of warnings from the last query in the connection represented by the $link parameter.

RETURN VALUES

	Number of warnings or zero if there are no warnings.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

	      /* check connection */
	      if (maxdb_connect_errno()) {
		 printf("Connect failed: %s
", maxdb_connect_error());
		 exit();
	      }

	      $maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");

	      /* a remarkable city in Wales */
	      $query = "INSERT INTO temp.mycity (zip, name) VALUES('11111',
		     'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch')";

	      $maxdb->query($query);

	      printf ("Number of warning: %d
", $maxdb->warning_count);

	      /* close connection */
	      $maxdb->close();
	      ?>

       Example #2

	      Procedural style

	      <?php
	      $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

	      /* check connection */
	      if (maxdb_connect_errno()) {
		 printf("Connect failed: %s
", maxdb_connect_error());
		 exit();
	      }

	      maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");

	      /* a remarkable long city name in Wales */
	      $query = "INSERT INTO temp.mycity (zip, name) VALUES('11111',
		     'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch')";

	      maxdb_query($link, $query);

	      printf ("Number of warning: %d
", maxdb_warning_count($link));

	      /* close connection */
	      maxdb_close($link);
	      ?>

       The above example will output something similar to:

       Warning: maxdb_query(): -8004 POS(62) Constant must be compatible with column type and length <...>
       Number of warning: 0

SEE ALSO

       maxdb_errno(3), maxdb_error(3), maxdb_sqlstate(3).

PHP Documentation Group 												    MAXDB_WARNING_COUNT(3)

MAXDB_THREAD_ID(3)							 1							MAXDB_THREAD_ID(3)

maxdb_thread_id - Returns the thread ID for the current connection

       Procedural style

SYNOPSIS

       int maxdb_thread_id (resource  $link)

DESCRIPTION

       Object oriented style
       int$maxdb->thread_id ()

	The  maxdb_thread_id(3)  function  returns the thread ID for the current connection which can then be killed using the maxdb_kill(3) func-
       tion. If the connection is lost and you reconnect with maxdb_ping(3), the thread ID will be other. Therefore you should get the	thread	ID
       only when you need it.

       Note

	       The  thread  ID	is  assigned on a connection-by-connection basis. Hence, if the connection is broken and then re-established a new
	      thread ID will be assigned.

RETURN VALUES

       maxdb_thread_id(3) returns the Thread ID for the current connection.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

	      /* check connection */
	      if (maxdb_connect_errno()) {
		 printf("Connect failed: %s
", maxdb_connect_error());
		 exit();
	      }

	      /* determine our thread id */
	      $thread_id = $maxdb->thread_id;

	      /* Kill connection */
	      $maxdb->kill($thread_id);

	      /* This should produce an error */
	      if (!$maxdb->query("CREATE TABLE mycity LIKE hotel.city")) {
		 printf("Error: %s
", $maxdb->error);
		 exit;
	      }

	      /* close connection */
	      $maxdb->close();
	      ?>

       Example #2

	      Procedural style

	      <?php
	      $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

	      /* check connection */
	      if (maxdb_connect_errno()) {
		 printf("Connect failed: %s
", maxdb_connect_error());
		 exit();
	      }

	      /* determine our thread id */
	      $thread_id = maxdb_thread_id($link);

	      /* Kill connection */
	      maxdb_kill($link, $thread_id);

	      /* This should produce an error */
	      if (!maxdb_query($link, "CREATE TABLE mycity LIKE hotel.city")) {
		 printf("Error: %s
", maxdb_error($link));
		 exit;
	      }

	      /* close connection */
	      maxdb_close($link);
	      ?>

       The above example will output something similar to:

       Warning: maxdb_query(): -10821 Session not connected <...>
       Error: Session not connected

SEE ALSO

       maxdb_kill(3).

PHP Documentation Group 													MAXDB_THREAD_ID(3)