public function call_dbFunction_without_param($dbFunctionName) { $this->database = Mysql_Database::getInstance(); $query = "call {$dbFunctionName}();"; $result = $this->database->query($query); //print_r($result); return $result; }
public function user_comments_export($output) { fputcsv($output, array('User Email', 'User Comment', 'Comment Type', 'Created On')); $database = Mysql_Database::getInstance(); //$date = date('m/d/Y h:i:s a', time()); $rows = mysql_query('SELECT user_email,user_comment,comment_type,created_on FROM feedback_usercomments'); // loop over the rows, outputting them while ($row = mysql_fetch_assoc($rows)) { if ($row['comment_type'] == 1) { $row['comment_type'] = "Positive"; } else { $row['comment_type'] = "Negative"; } // print_r($row); fputcsv($output, $row); } // }