Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors',1);
- error_reporting(E_STRICT | E_ALL);
- $dbhost = 'orion.volt-host.com';
- $dbuser = '1845_hehu';
- $dbpass = 'struts';
- $dbname = '1845_hehu';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
- mysql_select_db($dbname);
- set_time_limit(0);
- foreach (glob('*.ini') as $file) {
- $record = parse_ini_file($file);
- $fileinfo = pathinfo($file);
- $record['user'] = $fileinfo['filename'];
- $aValues = array();
- foreach($record as $field => $value) {
- $aValues[] = "'". mysql_real_escape_string($value) ."'";
- }
- $sql = "INSERT INTO PlayerInfo
- (".(implode(',',array_keys($record))).")
- VALUES
- (".(implode(',',$aValues)).")";
- if (($result = mysql_query($sql)) === false) {
- echo 'PlayerInfo: '.$record['user'].' not added';
- }
- else {
- echo 'PlayerInfo: '.$record['user'].' added';
- }
- }
- var_dump($sql);
- ?>
Add Comment
Please, Sign In to add comment