<?php
/* soak in the passed variable or set our own */
$format = strtolower($_GET['format']) == 'json' ? 'json' : 'xml'; //xml is the default
/* connect to the db */
$link = mysql_connect('localhost','envisiy9_update','T?pAT*{nC58E') or die('Cannot connect to the DB');
mysql_select_db('envisiy9_SiteCMS',$link) or die('Cannot select the DB');
/* grab the posts from the db */
$query = "SELECT * FROM artists";
$result = mysql_query($query,$link) or die('Errant query: '.$query);
/* create one master array of the records */
$posts = array();
if(mysql_num_rows($result)) {
while($post = mysql_fetch_assoc($result)) {
$posts[] = array('a_id'=>$post['a_id'],'artist_name'=>htmlentities($post['artist_name']));
}
}
/* output in necessary format */
if($format == 'json') {
header('Content-type: application/json');
echo json_encode(array('posts'=>$posts));
}
else {
//header('Content-type: text/xml');
echo '';
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 '';
}
/* disconnect from the db */
?>
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
web service 2:
<?php
$link = mysql_connect('localhost','root','') or die('Cannot connect to the DB');
mysql_select_db('angelfi4_cart',$link) or die('Cannot select the DB');
/* grab the posts from the db */
$query = "SELECT * FROM artists";
$result = mysql_query($query,$link) or die('Errant query: '.$query);
/* create one master array of the records */
$posts = array();
$arts =array();
if(mysql_num_rows($result)) {
while($post = mysql_fetch_assoc($result)) {
$query2 = "SELECT * FROM art where artist='".$post['a_id']."'";
$result2 = mysql_query($query2,$link) or die('Errant query: '.$query2);
while($art = mysql_fetch_assoc($result2)) {
$arts[] = array('image'=>'http://69.195.124.130/~envisiy9/manager/pictures/'.$art['image'],'price'=>htmlentities($art['price']),'title'=>htmlentities($art['title']),'dimensions'=>htmlentities($art['dimensions']));
}
$posts[] = array('a_id'=>$post['a_id'],'artist_name'=>htmlentities($post['artist_name']),'arts'=>$arts);
}
}
echo "<pre>";
print_r($posts);
//header('Content-type: application/json');
//echo json_encode(array('posts'=>$posts));
?>
