Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function Update($table, $object, $where)
- {
- $sets = array();
- foreach ($object as $key => $value)
- {
- $key = mysql_real_escape_string($key . '');
- if ($value === null)
- {
- $sets[] = "$key=NULL";
- }
- else
- {
- $value = mysql_real_escape_string($value . '');
- $sets[] = " $key = $value ";
- }
- }
- $sets_s = implode(',', $sets);
- $query = "UPDATE $table SET $sets_s WHERE $where";
- $result = mysql_query($query);
- if (!$result)
- die(mysql_error());
- return mysql_affected_rows();
- }
- public function createComment($content, $id)
- {
- if($content == '')
- return false;
- date_default_timezone_set('Europe/Kiev');
- $msql = M_MSQL::Instance();
- $obj = array('comment_content'=>$content, 'id_theme'=>$id);
- $msql->Insert('comment', $obj);
- $obj = array('dt_of_last_comment'=>date('D j M, Y H:i:s'),'how_many_comments'=>" how_many_comments + 1");
- $where = "theme_id={$id}";
- $msql->Update('theme', $obj, $where);
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment