:: Forum >>

PHP/MS SQL 2005 - ODBC Connection


I have been looking at the example to connect to a MS SQL Database, but this is not using ODBC DSN.

Is someone able to give me a few pointer on how to change this to ODBC please?

For this line of code "while ($record = @mysql_fetch_row($dataset))", would the ODBC version use "odbc_fetch_into() "


$connection = @mysql_connect('localhost', 'user', 'password');
@mysql_select_db('database', $connection);
$query = 'SELECT * FROM myTable LIMIT 0,10';
$dataset = @mysql_query($query, $connection);

// print MySQL query results as 2D javascript array
function aw_cells($dataset){

$rows = array();
while ($record = @mysql_fetch_row($dataset)) {
$cols = array();
foreach ($record as $value) {
$cols[] = '"'.addslashes($value).'"';
$rows[] = "\t[".implode(",", $cols)."]";
echo "[\n".implode(",\n",$rows)."\n];\n";

// print MySQL field names as javascript array
function aw_headers($dataset){
while ($field = @mysql_fetch_field($dataset)) {
$cols[] = '"'.$field->name.'"';
echo "[".implode(",",$cols)."];\n";

<!-- include AW stylesheet and script -->
<link href="../../runtime/styles/xp/aw.css" rel="stylesheet" type="text/css" ></link>
<script src="../../runtime/lib/aw.js"></script>

// insert javascript arrays produced by PHP functions
var myHeaders = <?= aw_headers($dataset) ?>
var myCells = <?= aw_cells($dataset) ?>

// create grid control
var obj = new AW.UI.Grid;

// set grid text

// set number of columns/rows

// write grid to the page


Thank You
Tuesday, July 10, 2007

This topic is archived.

Back to support forum

Forum search