cubrid_fetch_assoc(3) [php man page]

CUBRID_FETCH_ASSOC(3)							 1						     CUBRID_FETCH_ASSOC(3)

cubrid_fetch_assoc - Return the associative array that corresponds to the fetched row

SYNOPSIS

       array cubrid_fetch_assoc (resource  $result, [int  $type])

DESCRIPTION

	This  function	returns  the  associative  array,  that corresponds to the fetched row, and then moves the internal data pointer ahead, or
       returns FALSE when the end is reached.

PARAMETERS

	      o $result
		-$result comes from a call to cubrid_execute(3)

	      o $type
		-Type can only be CUBRID_LOB, this parameter will be used only when you need to operate the lob object.

RETURN VALUES

	Associative array, when process is successful.

       FALSE, when there are no more rows; NULL, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_fetch_assoc(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");
	      $req = cubrid_execute($conn, "SELECT name,area,seats,address FROM stadium WHERE nation_code='GRE' AND seats > 10000");

	      printf("%-40s %-10s %-6s %-20s
", "name", "area", "seats", "address");
	      while ($row = cubrid_fetch_assoc($req)) {
		  printf("%-40s %-10s %-6s %-20s
",
		      $row["name"], $row["area"], $row["seats"], $row["address"]);
	      }

	      // if you want to operate LOB object, you can use cubrid_fetch_assoc($req, CUBRID_LOB)

	      cubrid_close_request($req);

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      name				       area	  seats  address
	      Panathinaiko Stadium		       86300.00   50000  Athens, Greece
	      Olympic Stadium			       54700.00   13000  Athens, Greece
	      Olympic Indoor Hall		       34100.00   18800  Athens, Greece
	      Olympic Hall			       52400.00   21000  Athens, Greece
	      Olympic Aquatic Centre		       42500.00   11500  Athens, Greece
	      Markopoulo Olympic Equestrian Centre     64000.00   15000  Markopoulo, Athens, Greece
	      Faliro Coastal Zone Olympic Complex      34650.00   12171  Faliro, Athens, Greece
	      Athens Olympic Stadium		       120400.00  71030  Maroussi, Athens, Greece
	      Ano Liossia			       34000.00   12000  Ano Liosia, Athens, Greece

SEE ALSO

       cubrid_execute(3), cubrid_fetch(3), cubrid_fetch_row(3), cubrid_fetch_array(3), cubrid_fetch_object(3).

PHP Documentation Group 												     CUBRID_FETCH_ASSOC(3)

CUBRID_PREPARE(3)							 1							 CUBRID_PREPARE(3)

cubrid_prepare - Prepare a SQL statement for execution

SYNOPSIS

       resource cubrid_prepare (resource  $conn_identifier, string  $prepare_stmt, [int  $option])

DESCRIPTION

	The  cubrid_prepare(3)	function  is  a sort of API which represents SQL statements compiled previously to a given connection handle. This
       pre-compiled SQL statement will be included in the cubrid_prepare(3).

	Accordingly, you can use this statement effectively to execute several times repeatedly or to process long data. Only a  single  statement
       can  be used and a parameter may put a question mark (?) to appropriate area in the SQL statement. Add a parameter when you bind a value in
       the VALUES clause of INSERT statement or in the WHERE clause. Note that it  is  allowed	to  bind  a  value  to	a  MARK(?)  by	using  the
       cubrid_bind(3) function only.

PARAMETERS

	      o $conn_identifier
		-Connection identifier.

	      o $prepare_stmt
		-Prepare query.

	      o $option
		-OID return option CUBRID_INCLUDE_OID.

RETURN VALUES

	Request identifier, if process is successful;

       FALSE, if process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_prepare(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");

	      $sql = <<<EOD
	      SELECT g.event_code, e.name
	      FROM game g
	      JOIN event e ON g.event_code=e.code
	      WHERE host_year = ? AND event_code NOT IN (SELECT event_code FROM game WHERE host_year=?) GROUP BY event_code;
	      EOD;

	      $req = cubrid_prepare($conn, $sql);

	      cubrid_bind($req, 1, 2004);
	      cubrid_bind($req, 2, 2000);
	      cubrid_execute($req);

	      $row_num = cubrid_num_rows($req);
	      printf("There are %d event that exits in 2004 olympic but not in 2000. For example:

", $row_num);

	      printf("%-15s %s
", "Event_code", "Event_name");
	      printf("----------------------------
");

	      $row = cubrid_fetch_assoc($req);
	      printf("%-15d %s
", $row["event_code"], $row["name"]);
	      $row = cubrid_fetch_assoc($req);
	      printf("%-15d %s
", $row["event_code"], $row["name"]);

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      There are 27 event that exits in 2004 olympic but not in 2000. For example:

	      Event_code      Event_name
	      ----------------------------
	      20063	      +91kg
	      20070	      64kg

SEE ALSO

       cubrid_execute(3), cubrid_bind(3).

PHP Documentation Group 													 CUBRID_PREPARE(3)