PHP – MySQL Processes Information

The given PHP example helps you to get the info of all mysql processes.

Code Example:
<?php
$server = "localhost";
$username = "root";
$password = "";
 
$conn =  mysql_connect($server, $username, $password) or die("Couldn't connect to MySQL" . mysql_error());
$processes = mysql_list_processes();
echo "<table>";
echo "<tr><th>ID</th><th>User</th><th>Host</th><th>DB</th>
  <th>Command</th><th>Time</th><th>State</th><th>Info</th>
  </tr>";

while ($row = mysql_fetch_row($processes)) {
  list($id,$user,$host,$db,$command,$time,$state,$info) = $row;
  echo "<tr><td>$id</td><td>$user</td>
	 <td>$host</td><td>$db</td><td>$command</td>
	 <td>$time</td><td>$state</td><td>$info</td>
	 </tr>";
}
echo "</table>";
mysql_close($conn);
?>

Post to Twitter Post to Digg Post to Facebook Post to Google Buzz Send Gmail

9 Comments

  1. avatarNora Godley

    Hello There,

    Are you using WordPress/Woocommerce or maybe do you actually project to make use of it someday ? We offer around 2500 premium plugins and additionally themes free to get : http://ezurl.xyz/1mjOO

    Thanks,

    Nora

  2. avatarAlan Wagner

    Hi fellow entrepreneur,

    Did you know that 95% of people who try forex trading fail?

    Yep. It’s the horrible truth. The main reasons why they fail are:

    – They learn the free stuff straight off Google.
    – They don’t know how to manage their risk.
    – They expect a get rich quick ‘overnight success’

    The amazing news is I’ve created a brand new masterclass video which shows you exactly how to solve all these problems – fast, easy and most importantly – for FREE!

    Click Here Right Now To See It –> https://bit.ly/fasttrackforexonline-webinar

    I’ll see you over there.

    Thanks,

    Hither Mann
    Founder & CEO Fortune Academy

    P.S. No business should ever put all their eggs in one basket. This training will open your eyes to what’s possible in the world of FX trading and I’m sure you will never look back.

  3. avatarDanielle Kieran

    hi there
    here is the your quote on the Country targeted organic website traffic:

    https://hyperlabs.co/quote/

    thanks and regards
    Mike
    Hyperlabs LTF

  4. avatarKali Wink

    How does free traffic for your site sound? Too good to be true, probably some catch to it is what you’re thinking right? Nope, no catch or cost at all. I’m just trying to get my site out there and help out lots of good people like yourself. I want to show you real quick how you can leverage these top 5 sites to get free traffic back to your site. Check it out: http://bit.ly/5-ways-to-advertise-free

  5. avatarLindsey Perrier

    Now you can get thousands of high quality niche targeted website visitors for less than the price of a few clicks on Google. Find out more here: https://bit.ly/get-more-web-traffic-now

  6. avatarJohn Mathews

    With the current pandemic and the unknown timeline, until things return to what they were, every business needs to get serious and double down on digital marketing.

    With that in mind, the company I work at is offering a special digital marketing bundle that includes marketing explainer videos + landing pages + professional content and graphics to boost your digital presence and increase your online footprint.

    No one knows how long this corona lockdown will last – its time to jump on the digital marketing bandwagon.

    –John Mathews

  7. avatarOdette Dunford

    Since everyone needs traffic to their websites, Google, YouTube, Facebook, and LinkedIn are among the top 20 most visited sites in the world. There are so many other sites that you can get traffic to your site from that most marketers haven’t even considered. Here are 5 examples of high traffic sites that you can take advantage of and drive tons of free traffic back to your site.https://is.gd/cBZZxx

  8. avatarJerrell Dickey

    Good job on the new site! Now go ahead and submit it to our free directory here https://1mdr.short.gy/submit-your-site

  9. avatarBryant Daddario

    I was wondering if you wanted to submit your new site to our free business directory? https://1mdr.short.gy/submit-your-site

Leave a Comment

Your email address will not be published. Required fields are marked *