Knowledgebase
[QODBC-ALL] How to use QODBC with PHP
Posted by Jack - QODBC Support on 02 March 2015 11:42 AM

How to use QODBC with PHP

Instructions about 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 64 bit application, then you need to use QRemote 64 bit DSN "QuickBooks Data 64-Bit QRemote"

Result in Web Browser:

http://support.flexquarters.com/esupport/newimages/QODBCPHP/step1.PNG

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).