pg_update(3) [php man page]

PG_UPDATE(3)															      PG_UPDATE(3)

pg_update - Update table

SYNOPSIS

       mixed pg_update (resource  $connection, string  $table_name, array  $data, array  $condition, [int  $options = PGSQL_DML_EXEC])

DESCRIPTION

       pg_update(3)  updates  records  that  matches condition with data. If options is specified, pg_convert(3) is applied to data with specified
       options.

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource.

	      o $table_name
		- Name of the table into which to update rows.

	      o $data
		- An array whose keys are field names in the table $table_name, and whose values are what matched rows are to be updated to.

	      o $condition
		- An array whose keys are field names in the table $table_name, and whose values are the conditions that a row	must  meet  to	be
		updated.

	      o $options
		-  Any	number	of PGSQL_CONV_FORCE_NULL, PGSQL_DML_NO_CONV, PGSQL_DML_ESCAPE, PGSQL_DML_EXEC, PGSQL_DML_ASYNC or PGSQL_DML_STRING
		combined. If PGSQL_DML_STRING is part of the $options then query string is returned. When PGSQL_DML_NO_CONV or PGSQL_DML_ESCAPE is
		set, it does not call pg_convert(3) internally.

RETURN VALUES

	Returns TRUE on success or FALSE on failure. Returns string if PGSQL_DML_STRING is passed via $options.

EXAMPLES

       Example #1

	      pg_update(3) example

	      <?php
		$db = pg_connect('dbname=foo');
		$data = array('field1'=>'AA', 'field2'=>'BB');

		// This is safe, since $_POST is converted automatically
		$res = pg_update($db, 'post_log', $_POST, $data);
		if ($res) {
		    echo "Data is updated: $res
";
		} else {
		    echo "User must have sent wrong inputs
";
		}
	      ?>

CHANGELOG

       +-------------+---------------------------------------------------+
       |  Version    |							 |
       |	     |							 |
       |	     |			  Description			 |
       |	     |							 |
       +-------------+---------------------------------------------------+
       |   5.6.0     |							 |
       |	     |							 |
       |	     |	No  longer  experimental. Added PGSQL_DML_ESCAPE |
       |	     | constant, TRUE/ FALSE and NULL data type support. |
       |	     |							 |
       |5.5.3/5.4.19 |							 |
       |	     |							 |
       |	     |	Direct SQL injection to $table_name and Indirect |
       |	     | SQL injection to identifiers are fixed.		 |
       |	     |							 |
       +-------------+---------------------------------------------------+
SEE ALSO

       pg_convert(3).

PHP Documentation Group 													      PG_UPDATE(3)

Check Out this Related Man Page

OVRIMOS_RESULT_ALL(3)													     OVRIMOS_RESULT_ALL(3)

ovrimos_result_all - Prints the whole result set as an HTML table

SYNOPSIS

       int ovrimos_result_all (int  $result_id, [string  $format])

DESCRIPTION

	Prints the whole result set as an HTML table.

PARAMETERS

	      o $result_id
		- A result identifier, returned by ovrimos_execute(3) or ovrimos_exec(3).

	      o $format
		- Optional HTML attributes for the generated table element.

RETURN VALUES

	Returns the number of rows in the generated table.

EXAMPLES

	This will execute an SQL statement and print the result in an HTML table.

       Example #1

	      Prepare a statement, execute, and view the result

	      <?php
	      $conn = ovrimos_connect("db_host", "8001", "admin", "password");
	      if ($conn != 0) {
		  echo "Connection ok!";
		  $res = ovrimos_prepare($conn, "select table_id, table_name
						  from sys.tables where table_id = 7");
		  if ($res != 0) {
		      echo "Prepare ok!";
		      if (ovrimos_execute($res, array(3))) {
			  echo "Execute ok!
";
			  ovrimos_result_all($res);
		      } else {
			  echo "Execute not ok!";
		      }
		      ovrimos_free_result($res);
		  } else {
		      echo "Prepare not ok!
";
		  }
		  ovrimos_close($conn);
	      }
	      ?>

       Example #2

	      ovrimos_result_all(3) with meta-information

	      <?php
	      $conn = ovrimos_connect("db_host", "8001", "admin", "password");
	      if ($conn != 0) {
		  echo "Connection ok!";
		  $res = ovrimos_exec($conn, "select table_id, table_name
					       from sys.tables where table_id = 1");
		  if ($res != 0) {
		      echo "Statement ok! cursor=" . ovrimos_cursor($res) . "
";
		      $colnb = ovrimos_num_fields($res);
		      echo "Output columns=" . $colnb . "
";
		      for ($i=1; $i <= $colnb; $i++) {
			  $name = ovrimos_field_name($res, $i);
			  $type = ovrimos_field_type($res, $i);
			  $len = ovrimos_field_len($res, $i);
			  echo "Column " . $i . " name=" . $name . " type=" . $type . " len=" . $len . "
";
		      }
		      ovrimos_result_all($res);
		      ovrimos_free_result($res);
		  }
		  ovrimos_close($conn);
	      }
	      ?>

PHP Documentation Group 												     OVRIMOS_RESULT_ALL(3)

Linux and UNIX Man Pages

pg_update(3) [php man page]

Check Out this Related Man Page