+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Utility code snippets - share yours (/showthread.php?tid=34522)
Utility code snippets - share yours - El Forum - 10-02-2010
[eluser]nuwanda[/eluser]
Hi, All
Thought I'd share two utility snippets I use. Nothing too original but they may help someone.
Feel free to share yours. The mod may sticky this.
This one gets a field (what) from (where) containing (where_value).
Code:
function get_what_where($what, $where, $where_value, $table){
$this->db->select($what);
$this->db->where($where,$where_value);
$query=$this->db->get($table);
if($query->num_rows==1){
return $query->row($what);
}else
return 0;
}
}This updates a field (what) with (what_value) from (where) containing (where_value).
Code:
function put_what_where($what,$what_value,$where,$where_value,$table){
$this->db->set($what,$what_value);
$this->db->where($where,$where_value);
if($this->db->update($table)){
return 1;
}
return 0;
}Both return either success or failure.
Utility code snippets - share yours - El Forum - 10-02-2010
[eluser]Vega[/eluser]
Heres one I wrote that tests for bad words in a string, (you need a table of bad words):
Code:
public function bad_words($str, $seperators = array('-', '_'))
{
$CI =& get_instance();
$haystack = strtolower(str_replace($seperators, '', $str));
$query = $CI->db->get('bad_words');
foreach ($query->result_array() as $row)
{
if (strpos($haystack, $row['word']) !== FALSE)
{
return FALSE;
}
}
return TRUE;
}