AnsBix8 - Terminal

Path: / / home / omb / public_html / old

Editing: excel.php

<?php
	set_time_limit(60);
	include 'wp-load.php';

$posts = get_posts(array(
		'posts_per_page' => 2000,
		'offset' => 2000,
		'post_status' => 'publish',
		'category__not_in' => array(24)
	));

$fh = fopen('php://temp', 'rw');

foreach($posts as $p){
		$meta = get_post_meta($p->ID);
		$row = array(
			'title' => $p->post_title,
			'year' => (!empty($meta['release_date_value'])) ? $meta['release_date_value'][0] : '',
			'cast' => (!empty($meta['meta_cast_value'])) ? $meta['meta_cast_value'][0] : '',
			'director' => (!empty($meta['meta_director_value'])) ? $meta['meta_director_value'][0] : '',
			'plot' => (!empty($meta['meta_synopsis_value'])) ? $meta['meta_synopsis_value'][0] : '',
		);
		fputcsv($fh, $row);

}
	rewind($fh);
	$csv = stream_get_contents($fh);
	fclose($fh);

die($csv);

die('test ' . count($posts));
/*
	$conn = new mysqli('localhost', 'root', 'T4IZXVNpD!$z', 'omb_wp_onlinemoviesbox_com');
	// Check connection
	if ($conn->connect_error) {
	    die("Connection failed: " . $conn->connect_error);
	}

$sql = "SELECT DISTINCT p.ID, p.post_title, c.name genre FROM wp_onlinemoviesboxposts p LEFT JOIN wp_onlinemoviesboxterm_relationships r ON r.object_id = p.ID LEFT JOIN wp_onlinemoviesboxterms c ON c.term_id = r.term_taxonomy_id INNER JOIN wp_onlinemoviesboxterm_taxonomy tax ON (tax.taxonomy='category' AND tax.term_id = c.term_id)  WHERE post_type='post' AND post_status='publish' LIMIT 0, 3000";

$result = mysqli_query($conn, $sql);

$cnt = 0;
	while($row = mysqli_fetch_assoc($result)){
		print_r($row);
		$cnt++;
	}

die('test ' . $cnt);
*/
?>

[ CANCEL ]