Reply to thread

Message

<blockquote data-quote="Marlboro20" data-source="post: 299647" data-attributes="member: 40837">Not an expert but shouldn't it be like this?[CODE]&lt;?php// Create connection$con=mysql_connect('HOST', 'USERNAME', 'PASSWORD')mysql_select_db('DBNAME', $con);// Check connectionif (!$con){&nbsp; &nbsp; echo &quot;Failed to connect to MySQL: &quot; . mysql_connect_error();}?&gt;&lt;center&gt;&lt;li class=&quot;active&quot;&gt;&lt;center&gt;User(s) Online : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo mysql_result(mysql_query(&quot;SELECT online_now FROM stats;&quot;),0); ?&gt;&lt;/span&gt; | Total Cloudflare Resolved : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo mysql_result(mysql_query(&quot;SELECT cloudflare_resolved FROM stats;&quot;),0); ?&gt;&lt;/span&gt; | Total Skype Resolved : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo mysql_result(mysql_query(&quot;SELECT skype_resolved FROM stats;&quot;),0); ?&gt;&lt;/span&gt; | Online Today : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo mysql_result(mysql_query(&quot;SELECT online_today FROM stats;&quot;),0); ?&gt;&lt;/span&gt; &lt;/center&gt;[/CODE]You could do something like this [PHP]&lt;?php// Create connection$connection = new mysqli('HOST', 'USERNAME', 'PASSWORD', 'DBNAME') or die(mysqli_connect_error());$stats = function($row) {&nbsp; &nbsp; global $connection;&nbsp;&nbsp; &nbsp; &nbsp; $query = mysqli_query($connection, 'SELECT ' . $row . ' FROM stats;');&nbsp; &nbsp; $array = $query-&gt;fetch_array(MYSQLI_NUM);&nbsp;&nbsp; &nbsp; &nbsp; return $array[0];};?&gt;&lt;center&gt;&lt;li class=&quot;active&quot;&gt;&lt;center&gt;User(s) Online : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo $stats('online_now'); ?&gt;&lt;/span&gt; | Total Cloudflare Resolved : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo $stats('cloadflare_resolved'); ?&gt;&lt;/span&gt; | Total Skype Resolved : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo $stats('skype_resolved'); ?&gt;&lt;/span&gt; | Online Today : &lt;span class=&quot;badge&quot;&gt;&lt;?php echo $stats('online_today'); ?&gt;&lt;/span&gt; &lt;/center&gt;[/PHP]</blockquote>

[QUOTE="Marlboro20, post: 299647, member: 40837"] Not an expert but shouldn't it be like this? [CODE] <?php // Create connection $con=mysql_connect('HOST', 'USERNAME', 'PASSWORD') mysql_select_db('DBNAME', $con); // Check connection if (!$con) { echo "Failed to connect to MySQL: " . mysql_connect_error(); } ?> <center><li class="active"><center>User(s) Online : <?php echo mysql_result(mysql_query("SELECT online_now FROM stats;"),0); ?> | Total Cloudflare Resolved : <?php echo mysql_result(mysql_query("SELECT cloudflare_resolved FROM stats;"),0); ?> | Total Skype Resolved : <?php echo mysql_result(mysql_query("SELECT skype_resolved FROM stats;"),0); ?> | Online Today : <?php echo mysql_result(mysql_query("SELECT online_today FROM stats;"),0); ?> </center> [/CODE] You could do something like this [PHP] <?php // Create connection $connection = new mysqli('HOST', 'USERNAME', 'PASSWORD', 'DBNAME') or die(mysqli_connect_error()); $stats = function($row) { global $connection; $query = mysqli_query($connection, 'SELECT ' . $row . ' FROM stats;'); $array = $query->fetch_array(MYSQLI_NUM); return $array[0]; }; ?> <center><li class="active"><center>User(s) Online : <?php echo $stats('online_now'); ?> | Total Cloudflare Resolved : <?php echo $stats('cloadflare_resolved'); ?> | Total Skype Resolved : <?php echo $stats('skype_resolved'); ?> | Online Today : <?php echo $stats('online_today'); ?> </center> [/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members