How to use QODBC with PHP
Instructions for using QODBC with PHP:
Using PHP, whether it's an internal Intranet or on the World Wide Web, requires the Server Edition of QODBC. QuickBooks must be running with the company file open.
Download Sample
Sample Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>QODBC PHP Script To Display SQL Results</title>
</head>
<body topmargin="3" leftmargin="3" marginheight="0" marginwidth="0" bgcolor="#ffffff" link="#000066" vlink="#000000" alink="#0000ff" text="#000000">
<table border="0" border="0" bgcolor="lightgreen" bordercolor="black" cellpadding="0" cellspacing="0">
<tr>
<td>
<table border="2" bordercolor="black" bgcolor="white" cellpadding="5" cellspacing="0">
<thead>
<caption align="top">QODBC PHP Script To Display SQL Results</caption>
<tr>
<th>Row</th>
<?php
set_time_limit(120);
#Connect to a System DSN "QuickBooks Data" with no user or password
$oConnect = odbc_connect("QuickBooks Data QRemote", "", "");
#Set the SQL Statement
$sSQL = "SELECT Top 10 Name,FullName FROM Customer";
#Perform the query
$oResult = odbc_exec($oConnect, $sSQL);
$lFldCnt = 0;
$lFieldCount = odbc_num_fields($oResult);
while ($lFldCnt < $lFieldCount) {
$lFldCnt++;
$sFieldName = odbc_field_name($oResult, $lFldCnt);
print(" <th>$sFieldName</th>\n");
}
?>
</tr>
</thead>
<tbody>
<?php
$lRecCnt = 0;
#Fetch the data from the database
while(odbc_fetch_row($oResult)) {
$lRecCnt++;
print(" <tr>\n");
print(" <td>$lRecCnt</td>\n");
$lFldCnt = 0;
$lFieldCount = odbc_num_fields($oResult);
while ($lFldCnt < $lFieldCount) {
$lFldCnt++;
$sFieldValue = trim(odbc_result($oResult, $lFldCnt));
If ($sFieldValue == "") {
print(" <td> </td>\n");
}
else {
print(" <td valign=\"Top\">$sFieldValue</td>\n");
}
}
print(" </tr>\n");
}
#Close the connection
odbc_close($oConnect);
?>
</tbody>
<tfoot>
<?php
print(" <caption align=\"bottom\">Results of: $sSQL</caption>");
?>
</tfoot>
</table>
</td>
</tr>
</table>
</body>
</html>
Please refer: How to configure QRemote
Please Note: If you have the 64-bit application, then you need to use QRemote 64-bit DSN "QuickBooks Data 64-bit QRemote"
Result in Web Browser:
| 
(1 vote(s))
Helpful
Not helpful