karimali831 Posted August 29, 2011 Share Posted August 29, 2011 Hi! For all my queries I use safe_query() and this function returns mysql_query() Now I want to count how many queries is being returned in this function... can someone modify the code and assign a variable to return max returns please? I would be grateful, thanks! // -- MYSQL QUERY FUNCTION -- // $_mysql_querys = array(); function safe_query($query="") { global $_mysql_querys; if(stristr(str_replace(' ', '', $query), "unionselect")===FALSE AND stristr(str_replace(' ', '', $query), "union(select")===FALSE){ $_mysql_querys[] = $query; if(empty($query)) return false; if(DEBUG == "OFF") $result = mysql_query($query) or die('Query failed!'); else { $result = mysql_query($query) or die('Query failed: ' .'<li>errorno='.mysql_errno() .'<li>error='.mysql_error() .'<li>query='.$query); } return $result; } else die(); } Link to comment https://forums.phpfreaks.com/topic/245964-counting-returns-on-mysql_query-or-function/ Share on other sites More sharing options...
AyKay47 Posted August 29, 2011 Share Posted August 29, 2011 else { $result = mysql_query($query) or die('Query failed: ' .'<li>errorno='.mysql_errno() .'<li>error='.mysql_error() .'<li>query='.$query); $num_rows = mysql_num_rows($result); } return $result.$num_rows;// display however you want Link to comment https://forums.phpfreaks.com/topic/245964-counting-returns-on-mysql_query-or-function/#findComment-1263213 Share on other sites More sharing options...
karimali831 Posted August 29, 2011 Author Share Posted August 29, 2011 What is wrong with me.. no idea why I didn't think of this thanks a lot! Link to comment https://forums.phpfreaks.com/topic/245964-counting-returns-on-mysql_query-or-function/#findComment-1263219 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.