Advertisement
Guest User

Untitled

a guest
May 20th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.64 KB | None | 0 0
  1. <?php
  2.  
  3. $host = "localhost";
  4. $mysql_user = " ";
  5. $mysql_pass = " ";
  6. $mysql_db_name = " ";
  7. $tbl_name = " ";
  8.  
  9. $count = 0;
  10. $local_time = date('Y-m-d');
  11.  
  12. mysql_connect($host,$mysql_user,$mysql_pass) OR die("Kan inte ansluta till databasen");
  13. mysql_select_db($mysql_db_name) OR die("Hittar inte databasen");
  14.  
  15. $sql = "SELECT * FROM $tbl_name";
  16. $result = mysql_query($sql);
  17.  
  18. if ($result)
  19. {
  20.   while($rows=mysql_fetch_array($result))
  21.   {
  22.     if($rows['time'] == $local_time);
  23.     {
  24.       echo "Jaaaa tiden är stämmer: $count gång(er)"
  25.       $count = $count++;
  26.     }
  27.     else{} //inget.
  28.   }
  29. }
  30. else
  31. {
  32.   echo "Fel i SQL frågan";
  33. }
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement