Experimental Trap Results

  • strict warning: Declaration of views_handler_field_user_name::init() should be compatible with views_handler_field_user::init(&$view, $data) in /home/aubreymoore/guaminsects.net/anr/sites/all/modules/views/modules/user/views_handler_field_user_name.inc on line 61.
  • strict warning: Declaration of views_handler_argument_many_to_one::init() should be compatible with views_handler_argument::init(&$view, $options) in /home/aubreymoore/guaminsects.net/anr/sites/all/modules/views/handlers/views_handler_argument_many_to_one.inc on line 169.
This blog entry contains a PHP snippet which sends a query to the Guam Coconut Rhinoceros Beetle Database. The query returns the total number of beetles trapped in the current trap development experiment.
Legend
  • T - vaned bucket trap
  • SL - trap baited with standard pheromone lure
  • RL - trap baited with reduced release rate lure
  • UV - trap fitted with UV LEDs
connect_error) { trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR); } $sql = <<query($sql); if($rs === false) { trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR); } else { $rows_returned = $rs->num_rows; } // Build HTML table $out = ''; while ($field = $rs->fetch_field()) $out .= ""; while ($linea = $rs->fetch_assoc()) { $out .= ""; foreach ($linea as $valor_col) $out .= ''; $out .= ""; } $out .= "
".$field->name."
'.$valor_col.'
"; print($out); // Echo SQL print("
$sql"); ?>
Groups: