note 6106 modified in function.odbc-connect by irchtml
| From: | irchtml@php.net | Date: | Tue, 02 Mar 2004 11:19:44 +0000 |
| Subject: | note 6106 modified in function.odbc-connect by irchtml | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-66086@lists.php.net to get a copy of this message | ||
i'm using Apache/1.3.12 (Win32) with php4 module to get data from sql server7.0 via odbc.. and
it's works ! Thanks very much.. Hope this script help the others as i were helped =)
<?php
define (NL,"\n");
$cx=odbc_pconnect("php","sa","","");
$cur=odbc_exec($cx,"select id,nama from php");
echo "DATA FROM SQL SERVER WITH PHP4".NL;
echo "<table border=1 align=center>".NL;
echo
"<tr><td>ID</td>".NL."<td>Pass</td></tr>";
while(odbc_fetch_row($cur)){
echo "<tr>".NL;
$id=odbc_result($cur,1);
$pass=odbc_result($cur,2);
echo "<td>".NL;
echo "$id".NL;
echo "</td>".NL;
echo "<td>".NL;
echo "$pass".NL;
echo "</td>".NL;
echo "</tr>".NL;
echo "</td>".NL;
}
echo "</table>".NL;
?>
«IO»
--was--
i'm using Apache/1.3.12 (Win32) with php4 module to get data from sql server7.0 via odbc.. and
it's works ! Thanks very much.. Hope this script help the others as i were helped =)
<pre>
<?php
define (NL,"\n");
$cx=odbc_pconnect("php","sa","","");
$cur=odbc_exec($cx,"select id,nama from php");
echo "DATA FROM SQL SERVER WITH PHP4".NL;
echo "<table border=1 align=center>".NL;
echo
"<tr><td>ID</td>".NL."<td>Pass</td></tr>";
while(odbc_fetch_row($cur)){
echo "<tr>".NL;
$id=odbc_result($cur,1);
$pass=odbc_result($cur,2);
echo "<td>".NL;
echo "$id".NL;
echo "</td>".NL;
echo "<td>".NL;
echo "$pass".NL;
echo "</td>".NL;
echo "</tr>".NL;
echo "</td>".NL;
}
echo "</table>".NL;
?>
</pre>
«IO»
http://www.php.net/manual/en/function.odbc-connect.php