Exemple #1
0
//If don't received any paremeter, don't show anything
if (!isset($op)) die();
	
//********************************************
//Initializing objects and variables
//********************************************
$conn = new TConnection($servername, $databasename, $userid, $pwd);
$i = 1;

//Evaluate $op value
switch ($op)
{	
	case 0:	//Show recordset from first to last record
		//Execute sql
		$rs = $conn->Execute($sql);

		//Print query
		echo "<span style=\"font-family:Tahoma;font-size:12px;\">Query: $sql</span><br/><br/>";		

		//Create the DataGrid
		$datagrid = "<table border=\"1\" cellpadding=\"3\" cellspacing=\"0\">\n";

		//Create columns name
		$datagrid .= "<tr>\n";
		$datagrid .= "<td align=\"center\">#</td>\n";
		
		for ($x = 0; $x < sizeof($rs->fields); $x ++)
		{
			$datagrid .= "<td style=\"font-family:Tahoma;font-size:12px;\">" . $rs->fields[$x]->name . "</td>\n";
		}