<?php function mysql_error_show($sql = "", $file = __FILE__, $line = __LINE__) { global $project_vars; echo "There is a mysql error ... system exiting, contact system admin <a href=\"mailto:" . $project_vars['system_admin_email'] . "\">" . $project_vars['system_admin_name'] . "</a> for additional info."; if ($project_vars['show_mysql_error_file_line']) { echo "<br><br>Error is at FILE: " . $file . " at LINE: " . $line; } if ($project_vars['show_mysql_error_string']) { echo "<br><br>Mysql said: " . mysql_error(); } if ($project_vars['show_mysql_error_sql']) { echo "<br><br>The sql is: " . $sql; } exit; } // function to return the table name with proper prefix function get_table_name($table_name) { global $project_vars; return $project_vars['mysql_table_prefix'] . $table_name; } //echo $project_vars['mysql_db_host'].", ".$project_vars['mysql_db_user']." ,".$project_vars['mysql_db_pass']."<br>"; if ($myDB = @mysql_connect($project_vars['mysql_db_host'], $project_vars['mysql_db_user'], $project_vars['mysql_db_pass'])) { mysql_select_db($project_vars['mysql_db_name'], $myDB) or mysql_error_show('', __FILE__, __LINE__); } else { mysql_error_show(mysql_error(), __FILE__, __LINE__); } //mysql_query("SET NAMES utf8");
function get_counter($table, $conditions_field_values, $group) { $var = 0; $row = NULL; $rows = NULL; $sql = "SELECT COUNT(id) AS counter FROM " . get_table_name($table); if (count($conditions_field_values) > 0) { $sql .= " WHERE "; foreach ($conditions_field_values as $key => $val) { if ($j > 0) { $sql .= " AND "; } $sql .= $key . " = '" . addslashes($val) . "'"; $j++; } } //echo $sql."<br>"; $res = mysql_query($sql) or mysql_error_show($sql, __FILE__, __LINE__); while ($row = mysql_fetch_assoc($res)) { $row = array_map('stripslashes', $row); $rows[] = $row; } //print_r($row); return $rows; }