Return to Snippet

Revision: 20670
at November 21, 2009 17:56 by crewsd


Initial Code
<?php

if(isset($_GET['format']) && intval($_GET['num'])) {
	
	//Set our variables
	$format = strtolower($_GET['format']);
	$num = intval($_GET['num']);
	
	//Connect to the Database
	$con = mysql_connect('localhost', 'root', '') or die ('MySQL Error.');
	mysql_select_db('api', $con) or die('MySQL Error.');
	
	//Run our query
	$result = mysql_query('SELECT * FROM recipes ORDER BY `recipe_id` DESC LIMIT ' . $num, $con) or die('MySQL Error.');
	
	
	//Preapre our output
	if($format == 'json') {
		
		$recipes = array();
		while($recipe = mysql_fetch_array($result, MYSQL_ASSOC)) {
			$recipes[] = array('post'=>$recipe);
		}
		
		$output = json_encode(array('posts' => $recipes));
		
	} elseif($format == 'xml') {
		
		header('Content-type: text/xml');
		$output  = "<?xml version=\"1.0\"?>\n";
		$output .= "<recipes>\n";

		for($i = 0 ; $i < mysql_num_rows($result) ; $i++){
		    $row = mysql_fetch_assoc($result);
		    $output .= "<recipe> \n";
		    	$output .= "<recipe_id>" . $row['recipe_id'] . "</recipe_id> \n";
		    	$output .= "<recipe_name>" . $row['recipe_name'] . "</recipe_name> \n";
				$output .= "<recipe_poster>" . $row['recipe_poster'] . "</recipe_poster> \n";
				$output .= "<recipe_quick_info>" . $row['recipe_quick_info'] . "</recipe_quick_info> \n";
				$output .= "<recipe_link>" . $row['recipe_link'] . "</recipe_link> \n";
		    $output .= "</recipe> \n";
		}

		$output .= "</recipes>";
		
	} else {
		die('Improper response format.');
	}
	
	//Output the output.
	echo $output;

}

?>

Initial URL


Initial Description


Initial Title
API Article get.php

Initial Tags


Initial Language
PHP