mirror of
https://gitlab.com/harald.mueller/aktuelle.kurse.git
synced 2024-10-18 17:35:03 +02:00
58 lines
1.3 KiB
PHP
58 lines
1.3 KiB
PHP
<?php
|
|
$server = "PHP"; //System DSN
|
|
$user = "Mvo";
|
|
$pass = "vom1";
|
|
$toReturn = "";
|
|
$Query = "Select GName, VName from tbl_test";
|
|
|
|
echo "Connecting1 SQL Server:\n";
|
|
echo "<br>";
|
|
|
|
//connect to database
|
|
$connectionstring = odbc_pconnect($server ,$user,$pass) or die("Datenbankverbindung ist fehlgeschlagen");
|
|
|
|
$result = odbc_exec($connectionstring,$Query );
|
|
echo(" Connect Result: $result");
|
|
while(odbc_fetch_row($result))
|
|
{
|
|
for($i=1;$i<=odbc_num_fields($result);$i++)
|
|
{
|
|
$Text = odbc_result($result,$i);
|
|
echo $Text;
|
|
}
|
|
echo "<br>";
|
|
}
|
|
|
|
echo "Return as Object:\n<br><br>";
|
|
$result = odbc_exec($connectionstring,$Query );
|
|
|
|
|
|
echo "<form action='select.htm'><p><select name='top5' size='3' <option>Heino</option>";
|
|
while(odbc_fetch_row($result))
|
|
{
|
|
$Vname=odbc_result($result,"VName"); // angenommen die Datenbank hat eine Spalte namens VName
|
|
$Nname=odbc_result($result,"GName"); // angenommen die Datenbank hat eine Spalte namens GName
|
|
echo ("<option>$Vname $Nname</option>");
|
|
|
|
}
|
|
|
|
echo("<option>Nina Hagen</option>
|
|
<option>Marianne Rosenberg</option>
|
|
</select>
|
|
</p>
|
|
</form>");
|
|
|
|
echo "<h1>Wählen Sie Ihren Favoriten!</h1>";
|
|
|
|
|
|
|
|
echo "Qery Run \n";
|
|
|
|
|
|
//disconnect from database
|
|
echo "Disconnecting SQL Server:";
|
|
odbc_close($connectionstring);
|
|
|
|
|
|
?>
|