Advertisement
Guest User

Untitled

a guest
Oct 3rd, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. // config start
  2. $user = "raw_site"; // sql username
  3. $pass = "milano5"; //sql password
  4. $host = "localhost"; // sql host
  5. $datab = 'raw_site'; //sql db name
  6. $tablnam = 'user'; // sql user table name
  7. // config end
  8.  
  9. if(isset($_GET['dump'])){
  10. $con = mysql_connect($host, $user, $pass);
  11. mysql_select_db($datab);
  12. if (!$con)
  13. {
  14. die('Could not connect: ' . mysql_error());
  15. }
  16.  
  17.  
  18.  
  19. $rt = mysql_query("SELECT COUNT(*) AS userid FROM post WHERE dateline BETWEEN '1312416000' AND '1312505999'") or die(mysql_error());
  20.  
  21. $row = mysql_fetch_row($rt);
  22.  
  23. if($row)
  24. echo "<h1>Post count:</h1>" . $row[0] . " of 100 for today";
  25. mysql_close($con);
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement