mysqli_fetch_lengths(3) [php man page]

MYSQLI_FETCH_LENGTHS(3) 						 1						   MYSQLI_FETCH_LENGTHS(3)

mysqli_result::$lengths - Returns the lengths of the columns of the current row in the result set

       Object oriented style

SYNOPSIS

       array$mysqli_result->lengths ()

DESCRIPTION

       Procedural style
       array mysqli_fetch_lengths (mysqli_result  $result)

	The mysqli_fetch_lengths(3) function returns an array containing the lengths of every column of the current row within the result set.

PARAMETERS

	      o $
		result	 -Procedural   style   only:   A   result   set   identifier   returned   by  mysqli_query(3),	mysqli_store_result(3)	or
		mysqli_use_result(3).

RETURN VALUES

	An array of integers representing the size of each column (not including any terminating null characters).  FALSE if an error occurred.

       mysqli_fetch_lengths(3) is valid only for  the  current	row  of  the  result  set.  It	returns  FALSE	if  you  call  it  before  calling
       mysqli_fetch_row/array/object or after retrieving all rows in the result.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

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

	      $query = "SELECT * from Country ORDER BY Code LIMIT 1";

	      if ($result = $mysqli->query($query)) {

		  $row = $result->fetch_row();

		  /* display column lengths */
		  foreach ($result->lengths as $i => $val) {
		      printf("Field %2d has Length %2d
", $i+1, $val);
		  }
		  $result->close();
	      }

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

       Example #2

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

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

	      $query = "SELECT * from Country ORDER BY Code LIMIT 1";

	      if ($result = mysqli_query($link, $query)) {

		  $row = mysqli_fetch_row($result);

		  /* display column lengths */
		  foreach (mysqli_fetch_lengths($result) as $i => $val) {
		      printf("Field %2d has Length %2d
", $i+1, $val);
		  }
		  mysqli_free_result($result);
	      }

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

	      The above examples will output:

	      Field  1 has Length  3
	      Field  2 has Length  5
	      Field  3 has Length 13
	      Field  4 has Length  9
	      Field  5 has Length  6
	      Field  6 has Length  1
	      Field  7 has Length  6
	      Field  8 has Length  4
	      Field  9 has Length  6
	      Field 10 has Length  6
	      Field 11 has Length  5
	      Field 12 has Length 44
	      Field 13 has Length  7
	      Field 14 has Length  3
	      Field 15 has Length  2

PHP Documentation Group 												   MYSQLI_FETCH_LENGTHS(3)

MYSQLI_RESULT.FETCH_OBJECT(3)						 1					     MYSQLI_RESULT.FETCH_OBJECT(3)

mysqli_result::fetch_object - Returns the current row of a result set as an object

       Object oriented style

SYNOPSIS

       object mysqli_result::fetch_object ([string  $class_name = "stdClass"], [array  $params])

DESCRIPTION

       Procedural style
       object mysqli_fetch_object (mysqli_result  $result, [string  $class_name = "stdClass"], [array  $params])

	The  mysqli_fetch_object(3)  will return the current row result set as an object where the attributes of the object represent the names of
       the fields found within the result set.

	Note that mysqli_fetch_object(3) sets the properties of the object before calling the object constructor.

PARAMETERS

	      o $
		result	-Procedural  style  only:   A	result	 set   identifier   returned   by   mysqli_query(3),   mysqli_store_result(3)	or
		mysqli_use_result(3).

	      o $class_name
		- The name of the class to instantiate, set the properties of and return. If not specified, a stdClass object is returned.

	      o $params
		- An optional array of parameters to pass to the constructor for $class_name objects.

RETURN VALUES

	Returns an object with string properties that corresponds to the fetched row or NULL if there are no more rows in resultset.

       Note

	      Field names returned by this function are case-sensitive.

       Note

	      This function sets NULL fields to the PHP NULL value.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

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

	      $query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";

	      if ($result = $mysqli->query($query)) {

		  /* fetch object array */
		  while ($obj = $result->fetch_object()) {
		      printf ("%s (%s)
", $obj->Name, $obj->CountryCode);
		  }

		  /* free result set */
		  $result->close();
	      }

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

       Example #2

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

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

	      $query = "SELECT Name, CountryCode FROM City ORDER by ID DESC LIMIT 50,5";

	      if ($result = mysqli_query($link, $query)) {

		  /* fetch associative array */
		  while ($obj = mysqli_fetch_object($result)) {
		      printf ("%s (%s)
", $obj->Name, $obj->CountryCode);
		  }

		  /* free result set */
		  mysqli_free_result($result);
	      }

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

	      The above examples will output:

	      Pueblo (USA)
	      Arvada (USA)
	      Cape Coral (USA)
	      Green Bay (USA)
	      Santa Clara (USA)

SEE ALSO

       mysqli_fetch_array(3), mysqli_fetch_assoc(3), mysqli_fetch_row(3), mysqli_query(3), mysqli_data_seek(3).

PHP Documentation Group 											     MYSQLI_RESULT.FETCH_OBJECT(3)