valentina_fetch_assoc()

array valentina_fetch_assoc ( resource result )

Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. valentina_fetch_assoc() is equivalent to calling valentina_fetch_array() with VALENTINA_ASSOC for the optional second parameter. It only returns an associative array.

Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.

<?php
 
$conn = valentina_connect("localhost", "val_user", "val_password");
 
if (!$conn) {
   echo "Unable to connect to DB: " . valentina_error();
   exit;
}
 
if (!valentina_select_db("mydbname")) {
   echo "Unable to select mydbname: " . valentina_error();
   exit;
}
 
$sql = "SELECT userid, fullname, userstatus 
       FROM  sometable
       WHERE  userstatus = 1";
 
$result = valentina_query($sql);
 
if (!$result) {
   echo "Could not successfully run query ($sql) from DB: " . valentina_error();
   exit;
}
 
if (valentina_num_rows($result) == 0) {
   echo "No rows found, nothing to print so am exiting";
   exit;
}
 
// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
//      then create $userid, $fullname, and $userstatus
while ($row = valentina_fetch_assoc($result)) {
   echo $row["userid"];
   echo $row["fullname"];
   echo $row["userstatus"];
}
 
valentina_free_result($result);
 
?> 

Performance: An important thing to note is that using valentina_fetch_assoc() is not significantly slower than using valentina_fetch_row(), while it provides a significant added value.

Note: Field names returned by this function are case-sensitive.

Note: This function sets NULL fields to PHP NULL value.

valentina_fetch_row()

valentina_fetch_array()

valentina_data_seek()

valentina_query()

valentina_error()