Guest User

Untitled

a guest
May 26th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.98 KB | None | 0 0
  1. <?php
  2. ini_set('display_errors',1);
  3. error_reporting(E_STRICT | E_ALL);
  4.  
  5. $dbhost = 'orion.volt-host.com';
  6. $dbuser = '1845_hehu';
  7. $dbpass = 'struts';
  8. $dbname = '1845_hehu';
  9.  
  10. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  11. mysql_select_db($dbname);
  12.  
  13. set_time_limit(0);
  14. foreach (glob('*.ini') as $file) {
  15.     $record = parse_ini_file($file);
  16.     $fileinfo = pathinfo($file);
  17.     $record['user'] = $fileinfo['filename'];
  18.     $aValues = array();
  19.     foreach($record as $field => $value) {
  20.         $aValues[] = "'". mysql_real_escape_string($value) ."'";
  21.     }    
  22.     $sql = "INSERT INTO PlayerInfo
  23.                (".(implode(',',array_keys($record))).")
  24.            VALUES
  25.                (".(implode(',',$aValues)).")";
  26.     if (($result = mysql_query($sql)) === false) {
  27.         echo 'PlayerInfo: '.$record['user'].' not added';
  28.     }
  29.     else {
  30.         echo 'PlayerInfo: '.$record['user'].' added';
  31.     }    
  32. }
  33.  
  34.  
  35. var_dump($sql);
  36. ?>
Add Comment
Please, Sign In to add comment