Hi I am a PHP beginner and using "Namo Webeditor" trial version in
order
to access an Excel file via ODBC...and I get no result
Namo generates the following code:
=================================
<?
$a_startrow = $startrow;
$a_maxrows = $maxrows;
require('wed_php_odbc.inc');
?><html>
<head>
<title>Sans titre</title>
<meta name="generator" content="Namo WebEditor v6.0">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple"
alink="red">
<?
$w_disprows = 10;
$w_sqlstr = "SELECT Feuli1$_FilterDatabase.Country,
Feuli1$_FilterDatabase.Customer Name, Feuli1$_FilterDatabase.Model,
Feuli1$_FilterDatabase.Description, Feuli1$_FilterDatabase.Order
Number,
Feuli1$_FilterDatabase.Quantity FROM Feuli1$_FilterDatabase";
wed_read_list_process ("trydb", "", "", $w_sqlstr, $w_record,
$w_disprows, $a_startrow, $a_maxrows, $w_rows);
?><table border="1">
<tr>
<td width="160">Feuli1$_FilterDatabase.Country</td>
<td width="160">Feuli1$_FilterDatabase.Customer Name</td>
<td width="160">Feuli1$_FilterDatabase.Model</td>
<td width="160">Feuli1$_FilterDatabase.Description</td>
<td width="160">Feuli1$_FilterDatabase.Order Number</td>
<td width="160">Feuli1$_FilterDatabase.Quantity</td>
</tr>
<?
for ($w_i = 0; $w_i < $w_rows; $w_i++) {
$f_Feuli1__FilterDatabase_Country = $w_record[$w_i][0];
$f_Feuli1__FilterDatabase_Customer_Name = $w_record[$w_i][1];
$f_Feuli1__FilterDatabase_Model = $w_record[$w_i][2];
$f_Feuli1__FilterDatabase_Description = $w_record[$w_i][3];
$f_Feuli1__FilterDatabase_Order_Number = $w_record[$w_i][4];
$f_Feuli1__FilterDatabase_Quantity = $w_record[$w_i][5];
?> <tr>
<td width="162"><?
wed_write($f_Feuli1__FilterDatabase_Country);
?></td>
<td width="162"><?
wed_write($f_Feuli1__FilterDatabase_Customer_Name);
?></td>
<td width="162"><?
wed_write($f_Feuli1__FilterDatabase_Model);
?></td>
<td width="162"><?
wed_write($f_Feuli1__FilterDatabase_Description);
?></td>
<td width="162"><? /
wed_write($f_Feuli1__FilterDatabase_Order_Number);
?></td>
<td width="162"><?
wed_write($f_Feuli1__FilterDatabase_Quantity);
?></td>
</tr>
<?
}
?> <tr>
<td width="993" colspan="6"><?
wed_list_move_page(10,
$w_disprows, $a_startrow, $a_maxrows, "");
?></td>
</tr>
</table>
<p> </p>
</body>
</html>
=======================================
where wed_php_odbc.inc contains:
=======================================
function wed_read_list_process($servername, $userid, $passwd, $sqlstr,
&$record, $disprows, $startrow, &$maxrows, &$rows)
{
$connect = odbc_connect($servername, $userid, $passwd);
$cursor = odbc_exec($connect, $sqlstr);
// skip pre list
for ($i = 0; $i < $startrow; $i++) {
odbc_fetch_into($cursor, /*$i,*/ &$row);
}
// fetch list (max disprows rows)
for ($rows = 0; ($rows < $disprows) && odbc_fetch_into($cursor,
/*$startrow + $rows,*/ &$row); $rows++) {
$record[$rows] = $row;
}
// determine maxrows
if ($maxrows == 0) {
for ($maxrows = $startrow + $rows; odbc_fetch_into($cursor,
/*$maxrows,*/ &$row); $maxrows++) {
;
}
}
odbc_close($connect);
}
=======================================
and
=======================================
function wed_write($value)
{
if ($value != null) {
$length = strlen($value);
$pos1 = strpos($value, "#");
if ($pos1 !== FALSE) {
$pos2 = strpos($value, "#", $pos1+1);
if ($length == $pos2 + 1) {
$link_str = substr($value, $pos1 + 1, $pos2 - $pos1 - 1);
if ($pos1 == 0)
$text_str = substr($value, $pos1 + 1, $pos2 - $pos1 - 1);
else
$text_str = substr($value, 0, $pos1);
$value = sprintf("<a href=\"%s\">%s</a>", $link_str,
$text_str);
}
}
$w_value = str_replace("\n", "<br>", $value);
}
else {
$w_value = " ";
}
echo($w_value);
}
=======================================
I never get the expected value.
My excel file is :
=======================================
Customer Name Model Description Order Number Quantity
CustUK1 Pan1 Pan UK001 2
CustUK2 Fork1 Fork UK002 5
CustFR knife1 knife FR001 15
=======================================
and I get:
=======================================
Feuli1$_FilterDatabase.Country Feuli1$_FilterDatabase.Customer Name
Feuli1$_FilterDatabase.Model Feuli1$_FilterDatabase.Description
Feuli1$_FilterDatabase.Order Number Feuli1$_FilterDatabase.Quantity
[ ]
where Feuli1 is the name of the spreadsheet
=======================================
I am not sure that PHP connects to the file and read it althoough Namo
has regognized the name of the fields.
Anybody can help ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
