All pastes #897465 Raw Edit

PHP data loader

public php v1 · immutable
·published 2008-02-09 16:10 UTC
rendered paste body
// Data.php<?phprequire_once(dirname(__FILE__)."/config.php");$link = mysql_connect(DBHOST,DBUSER,DBPASS);mysql_select_db(DBNAME,$link);if(isset($_POST['node'])) {	$node = $_POST['node'];	$result= array();	$res = mysql_query("select id, name `text` from folder where parent_folder=$node");	if($res){		if(mysql_num_rows($res)>0){			while($row = mysql_fetch_assoc($res)){				$result[]=array(					'id'=>$row['id'],					'text'=>$row['text'],					'leaf'=>false					);			}		}	}	$res = mysql_query("select id, name `text` from link where parent_folder=$node");	if($res){		if(mysql_num_rows($res)>0){			while($row = mysql_fetch_assoc($res)){				$result[]=array(					'id'=>$row['id'],					'text'=>$row['text'],					'leaf'=>true					);			}		}	}	echo json_encode($result);}else{	echo "[]";}?>