"Untitled Post" - Views: 248 · Hits: 248 - Type: Unlisted

<?php 
@ob_start(); 
/* require the user as the parameter */

$json = file_get_contents('php://input');
$obj = json_decode($json);


if(isset($_GET['user']) && intval($_GET['user'])) 
{
	//print "line 2";
	/* soak in the passed variable or set our own */
	$number_of_posts = isset($_GET['num']) ? intval($_GET['num']) : 10; //10 is the default
	$format = strtolower($_GET['format']) == 'json' ? 'json' : 'xml'; //xml is the default
	$user_id = intval($_GET['user']); //no default

	

		//print "line 3";

	/* connect to the db */
	$link = mysql_connect('mydatabasedomainname.1and1.com','mydatabaseusername','mydatabasepassword') or die('Cannot connect to the DB');
	mysql_select_db('mydatasename',$link) or die('Cannot select the DB');	
	

	 mysql_query("INSERT INTO `mydatasename`.`mydatabasetable` (obj) VALUES ('".$obj->{'searchText'}."')");

 
	
 
	/* grab the posts from the db */
	$result = mysql_query($query,$link) or die('Errant query:  '.$query);


	$posts = array();

	if(mysql_num_rows($result)) 
	{			
		while($post = mysql_fetch_assoc($result)) 
		{			 
			$posts[] = array('posts' =>$post);
		}
	}

	/* output in necessary format */
	if($format == 'json') 
	{
		header('Content-type: application/json');
		echo json_encode(array('posts'=>$posts));
		exit();
	}
	else 
	{
		header('Content-type: text/xml');
		echo '<posts>';
		foreach($posts as $index => $post) 
		{
			if(is_array($post)) 
			{
				foreach($post as $key => $value) 
				{
					echo '<',$key,'>';
					if(is_array($value)) 
					{
						foreach($value as $tag => $val) 
						{
							echo '<',$tag,'>',htmlentities($val),'</',$tag,'>';
						}
					}
					echo '</',$key,'>';
				}
			}
		}
		echo '</posts>';
	}

	/* disconnect from the db */
	@mysql_close($link);
}
?>