Help needed PHP with Excel database
| From: | JDP | Date: | Sat, 31 May 2008 16:35:54 +0000 |
| Subject: | Help needed PHP with Excel database | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45020@lists.php.net to get a copy of this message | ||
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 ?