Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Checks through a db looking for posts table and creates a text file with all the wget commands to retrieve the images of the site. To run just load the php file, enter the form fields and then after it has created the txt file run is 'bash wp_posts.txt' at the terminal.
<!doctype html>
<meta charset="utf-8" />
<title>Search for all images on WordPress and download to directory via WGET task list</title>
<h1>Search for all images on WordPress and download to directory via WGET task list</h1>
$db = 'information_schema';
if(isset($_POST['database']) && !empty($_POST['destination']) ){
$db = $_POST['database'];
$database = array('mysql' => array(
'host' => '',
'username' => 'root',
'password' => '',
'db' => $db
$pdo = new PDO("mysql:host=".$database['mysql']['host'].";dbname=".$database['mysql']['db'].";charset=utf8"
, $database['mysql']['username'] , $database['mysql']['password']);
if(!isset($_POST['database']) || empty($_POST['destination']) || empty($_POST['domain']) || empty($_POST['upload']) ) {
$select = $pdo->prepare("select schema_name from information_schema.schemata");
$result = $select->fetchAll();
<form action="" method="POST">
<p><label>Select Database</label>
<select name="database">
<?php foreach ($result as $row) { ?>
<option value="<?php echo $row['schema_name'] ?>"><?php echo $row['schema_name'] ?></option>
<?php } ?>
<p><label>source domain</label>
<input type="text" name="domain" /><br />
<small>input your domain like without any protocol or slashes</small>
<p><label>db table prefix</label>
<input type="text" name="prefix" value="wp_"/><br />
<small>like wp_ but the one you have</small>
<p><label>uploads directory</label>
<input type="text" name="upload" /><br />
<small>where the wp-content is. i.e.</small>
<p><label>destination directory (wp-content)</label>
<input type="text" name="destination" /><br />
<small>go to terminal and type 'pwd', copy the response in here</small>
<input type="submit" />
<?php } else {
$result = $pdo->query("SHOW TABLES FROM {$_POST['database']} WHERE
`Tables_in_{$_POST['database']}` LIKE '{$_POST['prefix']}%_posts'
OR `Tables_in_{$_POST['database']}` LIKE '{$_POST['prefix']}posts';");
$array_of_tables = $result->fetchAll();
foreach($array_of_tables as $table){
$t = $table[0];
$select = "SELECT guid FROM {$t} WHERE post_type='attachment' AND guid LIKE '%{$_POST['domain']}%' ";
$loopresult = $pdo->query($select);
if($loopresult!= false && $loopresult->rowCount() > 0) {
$output = array();
$values = $loopresult->fetchAll();
foreach ($values as $row){
$output[] = "wget ". $row[0]." -P " . str_replace($_POST['upload'], $_POST['destination'],dirname($row[0]) ) ;
file_put_contents($t.'.txt', implode("\n", $output) . "\n", FILE_APPEND);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.