maxdb_autocommit(3) [php man page]

MAXDB_AUTOCOMMIT(3)							 1						       MAXDB_AUTOCOMMIT(3)

maxdb_autocommit - Turns on or off auto-commiting database modifications

       Procedural style

SYNOPSIS

       bool maxdb_autocommit (resource	$link, bool  $mode)

DESCRIPTION

       Object oriented style
       bool maxdb::auto_commit (bool  $mode)

       maxdb_autocommit(3) is used to turn on or off auto-commit mode on queries for the database connection represented by the $link resource.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Object oriented style

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

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

	      /* turn autocommit on */
	      $maxdb->autocommit(TRUE);

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

       Example #2

	      Procedural style

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

	      if (!$link) {
		 printf("Can't connect to localhost. Error: %s
", maxdb_connect_error());
		 exit();
	      }

	      /* turn autocommit on */
	      maxdb_autocommit($link, TRUE);

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

       The above example will output something similar to:

SEE ALSO

       maxdb_commit(3), maxdb_rollback(3).

PHP Documentation Group 												       MAXDB_AUTOCOMMIT(3)

MAXDB_KILL(3)								 1							     MAXDB_KILL(3)

maxdb_kill - Disconnects from a MaxDB server

       Procedural style

SYNOPSIS

       bool maxdb_kill (resource  $link, int  $processid)

DESCRIPTION

       Object oriented style
       bool maxdb::kill (int  $processid)

	This function is used to disconnect from a MaxDB server specified by the $processid parameter.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

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 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 City")) {
		 printf("Error: %s
", maxdb_error($link));
		 exit;
	      }

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

       The above example will output something similar to:

       Error: Session not connected

SEE ALSO

       maxdb_thread_id(3).

PHP Documentation Group 													     MAXDB_KILL(3)