Beseitige die in Beitrag 10 angeführten Probleme
Announcement
Collapse
No announcement yet.
Datenübergabe
Collapse
X
-
PHP]
<?php
$pilot_id=($_POST["Pilot"]);
$callsign=($_POST["Callsign"]);
$origin_id=($_POST["origin"]);
$destination_id=($_POST["destination"]);
$duration=($_POST["duration"]);
$date=($_POST["Datum"])
$verbindung=mysql_connect("rdbms.strato.de","U4022 17","1xxxxx");
mysql_select_db("DB4022217");
$daten= "insert into `reports` values ($pilot_id,$date,$time,$callsign,$orig in_id,$destination_id,$duration);
$ergebnis=mysql_query("DB402217",$daten,$verbindung);
$abfrage="selcet from reports";
$ergebnis2=mysql_query("DB402217",$abfrage,$verbindung);
echo "<table>
while(list($pilot_id,$date,$time,$callsign,$origin _id,$destination_id,$duration) =mysql_fetch_array($ergebnis2))
{
echo "<tr>
<td>$pilot_id</td>
<td>$date</td>
<td>$callsign</td>
<td>$origin_id</td>
<td>$destination_id</td>
<td>$duration</td>
</tr>
}
echo"</table>
mysql_close()
?>
[/php]Christian
Comment
-
Hi,
danke für die Hilfe
Script sieht jetzt so aus und Fehlermeldung kommt in Zeile 24
PHP Code:<?php
$pilot_id=($_POST["Pilot"]);
$callsign=($_POST["Callsign"]);
$origin_id=($_POST["origin"]);
$destination_id=($_POST["destination"]);
$duration=($_POST["duration"]);
$date=($_POST["Datum"]);
$verbindung=mysql_connect("rdbms.strato.de","U402217","1xxxxx");
mysql_select_db(DB402217);
$daten= "insert into `reports` values ('',$pilot_id,$date,$callsign,$orig in_id,$destination_id,$duration)";
$ergebnis=mysql_query("DB402217",$daten,$verbindung);
$abfrage="select from reports";
$ergebnis2=mysql_query("DB402217",$abfrage,$verbindung);
echo "<table border=1 bgcolor='FFCC33'>
<tr>
<td>Pilot</td>
<td>Datum</td>
<td>Callsign</td>
<td>Start</td>
<td>Landung</td>
<td>Flugzeit</td>
</tr>";
while(list($pilot_id,$date,$callsign,$origin _id,$destination_id,$duration) =mysql_fetch_array($ergebnis2))
{
echo "<tr>
<td>$pilot_id</td>
<td>$date</td>
<td>$callsign</td>
<td>$origin_id</td>
<td>$destination_id</td>
<td>$duration</td>
</tr>";
}
echo "</table>
mysql_close()
?>
Comment
-
Hi,
sorry war gestern nicht ganz so gut drauf
habe inzwischen umgebaut sieht jetzt so aus
PHP Code:<?php
$pilot_id=($_POST["Pilot"]);
$callsign=($_POST["Callsign"]);
$origin_id=($_POST["origin"]);
$destination_id=($_POST["destination"]);
$duration=($_POST["duration"]);
$date=($_POST["Datum"]);
$pilot_id=($_POST["Pilot_id"]);
@define ("MYSQL_CONNECT_INCLUDE", "connect_db.php"); // MySQL database connection (a sample file is included
include(MYSQL_CONNECT_INCLUDE);
$daten= "insert into `reports` values ($pilot_id,$date,$time,$callsign,$origin_id,$destination_id,$duration)";
mysql_close()
?>
Der Befehl über phpmyadmin in die Datenbank eingegeben sind wir nachfolgend aus:
PHP Code:INSERT INTO `reports` ( `report_id` , `pilot_id` , `date` , `time` , `callsign` , `origin_id` , `destination_id` , `registration` , `equipment` , `duration` , `fuel` , `distance` , `fsacars_rep_url` )
VALUES ("", $pilot_id, $date, "00:00:00", $callsign,$origin_id,$destination_id,$duration, "0", "0", '')";
Danke
Reiner
Comment
Comment