join($table, $cond[, $type = ''[, $escape = NULL]]) Parameters: $table (string) – Table name to join $cond (string) – The JOIN ON condition $type (string) – The JOIN type $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds a JOIN clause to a query.

system_url() Returns: URL pointing at your CI system/ directory Return type: string This method retrieves the URL to your CodeIgniter system/ directory. Note This method is DEPRECATED because it encourages usage of insecure coding practices. Your system/ directory shouldn’t be publicly accessible.

next_row([$type = 'object']) Parameters: $type (string) – Type of the requested result - array, object, or class name Returns: Next row of result set, or NULL if it doesn’t exist Return type: mixed Returns the next row from the result set.

csv_from_result($query[, $delim = ', '[, $newline = "n"[, $enclosure = '"']]]) Parameters: $query (object) – A database result object $delim (string) – The CSV field delimiter to use $newline (string) – The newline character to use $enclosure (string) – The enclosure delimiter to use Returns: The generated CSV file as a string Return type: string Translates a database result object into a CSV document.

changedir($path[, $suppress_debug = FALSE]) Parameters: $path (string) – Directory path $suppress_debug (bool) – Whether to turn off debug messages for this command Returns: TRUE on success, FALSE on failure Return type: bool Changes the current working directory to the specified path. The $suppress_debug parameter is useful in case you want to use this method as an is_dir() alternative for FTP.

set_flashdata($data[, $value = NULL]) Parameters: $data (mixed) – An array of key/value pairs to set as flashdata, or the key for a single item $value (mixed) – The value to set for a specific session item, if $data is a key Return type: void Assigns data to the $_SESSION superglobal and marks it as “flashdata”. Note This is a legacy method kept only for backwards compatibility with older applications.

encode_from_legacy($string[, $legacy_mode = MCRYPT_MODE_ECB[, $key = '']]) Parameters: $string (string) – String to encrypt $legacy_mode (int) – Valid PHP MCrypt cipher constant $key (string) – Encryption key Returns: Newly encrypted string Return type: string Enables you to re-encode data that was originally encrypted with CodeIgniter 1.x to be compatible with the Encrypt library in CodeIgniter 2.x. It is only necessary to use this method if you have encrypted data stored permane

form_textarea([$data = ''[, $value = ''[, $extra = '']]]) Parameters: $data (array) – Field attributes data $value (string) – Field value $extra (mixed) – Extra attributes to be added to the tag either as an array or a literal string Returns: An HTML textarea tag Return type: string This function is identical in all respects to the form_input() function above except that it generates a “textarea” type. Note Instead of the maxlength and size attributes in the above example, you wi

get_instance() Returns: Reference to your controller’s instance Return type: CI_Controller

attachment_cid($filename) Parameters: $filename (string) – Existing attachment filename Returns: Attachment Content-ID or FALSE if not found Return type: string Sets and returns an attachment’s Content-ID, which enables your to embed an inline (picture) attachment into HTML. First parameter must be the already attached file name. $filename = '/img/photo1.jpg'; $this->email->attach($filename); foreach ($list as $address) { $this->email->to($address); $cid