Another PHP question functions and arrays
Ok here is the problem. I am doing a var_dump at the end to make sure I have the correct values in the array; which I do... I get this: array(2) { [0]=> string(3) "232" [1]=> string(3) "132" }
So I should be able to do a return statment and this values should be brough back, right? Wrong. I do another var_dump in the script that requested the function after the function is excuted and I get the same values. Now how do I get the data out of that array?
Here is the code:
global $link;
$query1 = "SELECT count(user_expirydate) FROM users WHERE user_expirydate >= curdate()";
$query2 = "SELECT count(user_expirydate) FROM users WHERE user_expirydate < curdate()";
for($i=0; $i <= 1; $i++){
$query_array = array($query1, $query2);
$QUERY_quickstats = $query_array[$i];
$infoquery_results = mysql_query($QUERY_quickstats, $link) or die("MySQL query infoquery failed. Error if any: ".mysql_error());
$infoquery_results = mysql_fetch_array($infoquery_results); $active_details[$i] = $infoquery_results["count(user_expirydate)"];
}
var_dump($active_details);
return array (0, 1, 2);
}
<?php
CURRENT_DATE();
QUICK_STATS_QUERY();
list ($quick_stats_values) = QUICK_STATS_QUERY();
print <<< END
<table border="0" width="100%">
<tr>
<td width="30%" valign="top"><b>Quick Totals:<br>
</b>Active Accounts: {$quick_stats_values[0]}<br>
Expired Accounts: {$quick_stats_values[1]}<br>
Suspended Accounts: 000
<p><b>Last 7 days:<br>
</b>New Accounts: 000<br>
Renewed Accounts: 000<br>
Expired Accounts: 000</p>
</td>
<td width="50%" valign="top">
<h3>Administration Panel</h3>
</td>
</tr>
</table>
END;
?>
P.S. Believe it or not but there is more knowledge and wealth at these fourms then most PHP fourms I've been to. You guys are great and I appreciate every last bit of help you guys willingly offer.
So I should be able to do a return statment and this values should be brough back, right? Wrong. I do another var_dump in the script that requested the function after the function is excuted and I get the same values. Now how do I get the data out of that array?
Here is the code:
Code:
function QUICK_STATS_QUERY(){ global $link;
$query1 = "SELECT count(user_expirydate) FROM users WHERE user_expirydate >= curdate()";
$query2 = "SELECT count(user_expirydate) FROM users WHERE user_expirydate < curdate()";
for($i=0; $i <= 1; $i++){
$query_array = array($query1, $query2);
$QUERY_quickstats = $query_array[$i];
$infoquery_results = mysql_query($QUERY_quickstats, $link) or die("MySQL query infoquery failed. Error if any: ".mysql_error());
$infoquery_results = mysql_fetch_array($infoquery_results); $active_details[$i] = $infoquery_results["count(user_expirydate)"];
}
var_dump($active_details);
return array (0, 1, 2);
}
<?php
CURRENT_DATE();
QUICK_STATS_QUERY();
list ($quick_stats_values) = QUICK_STATS_QUERY();
print <<< END
<table border="0" width="100%">
<tr>
<td width="30%" valign="top"><b>Quick Totals:<br>
</b>Active Accounts: {$quick_stats_values[0]}<br>
Expired Accounts: {$quick_stats_values[1]}<br>
Suspended Accounts: 000
<p><b>Last 7 days:<br>
</b>New Accounts: 000<br>
Renewed Accounts: 000<br>
Expired Accounts: 000</p>
</td>
<td width="50%" valign="top">
<h3>Administration Panel</h3>
</td>
</tr>
</table>
END;
?>
Code:
P.S. Believe it or not but there is more knowledge and wealth at these fourms then most PHP fourms I've been to. You guys are great and I appreciate every last bit of help you guys willingly offer.
Another PHP question functions and arrays