Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('konfig.php');
- $db_selected = mysql_select_db(MYSQL_DATENBANK , $db_link);
- if (!$db_selected) {
- die ('Kann foo nicht benutzen : ' . mysql_error());
- }
- echo MYSQL_DATENBANK;
- // $sql="CREATE DATABASE ".MYSQL_DATENBANK." ";
- //echo "<p>";
- //echo "$sql";
- //echo '$sql';
- //echo "</p>";
- // $result=mysql_query("$sql")
- // or die ("Anfrage fehlgeschlagen:". mysql_error());
- /* CREATE TABLE `adressen` (
- `id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
- `geschlecht` CHAR(1) NOT NULL,
- `nachname` VARCHAR(150) NOT NULL,
- `vorname` VARCHAR(150) NULL,
- `akuerzel` VARCHAR(2) NOT NULL,
- `strasse` VARCHAR(150) NULL,
- `plz` INT(5) NOT NULL,
- `telefon` VARCHAR(20)NOT NULL,
- `email` VARCHAR(150)NOT NULL,
- `url` VARCHAR(150)NOT NULL
- )
- ENGINE= MYISAM ;
- ";
- $db_erg=mysql_query($sql) or die ("ANfrage fehlgeschlagen".mysql_error());
- */
- /* $sql="
- CREATE TABLE `orte` (
- `plz` INT (5) NOT NULL,
- `ort` VARCHAR(255) NOT NULL,
- PRIMARY KEY (`plz`)
- )ENGINE=MYISAM;
- ";
- $db_erg=mysql_query($sql) or die ("Anfrage 2 fehlgeschlagen".mysql_error());
- */
- //--------eintragen
- /* $plz=21031;
- $sql="
- INSERT INTO `adressen`
- (
- `id`,`geschlecht` ,`nachname`,`vorname`,`akuerzel`,`strasse`,`plz`, `telefon`, `email`, `url`
- )
- VALUES
- (
- NULL, 'm' , 'Davis', 'Marcel', 'm', '1n1strasse', '52694', '513264-5515425', 'marceldavis@web.de', '1n1.de'
- );
- ";
- */
- /* $db_erg=mysql_query($sql)
- or die("Anfrage fehlgeschlagen:".mysql_error());
- $sql="
- INSERT INTO `orte`
- (
- `plz`, `ort`
- )
- VALUES
- (
- '52694', 'Affenhausen'
- );
- ";
- $db_erg=mysql_query($sql)
- or die("Anfrage fehlgeschlagen:".mysql_error());
- //-------- */
- $plz="55555";
- $ort="gorillahausen";
- $sql = "SELECT * FROM `orte` WHERE plz=$plz";
- //echo "<p>.......... ". mysql_query($sql)." .......</p>";
- mysql_query($sql);
- $anzahl= mysql_num_rows(mysql_query($sql));
- echo "<p>$anzahl</p>";
- if ( $anzahl>=1)
- {
- echo "erfolg.";
- }
- else {
- mysql_query("INSERT INTO `orte`
- (`plz`, `ort`)
- VALUES
- ('$plz', '$ort')
- ") ;
- echo "negativ";
- }
- echo "<p>$plz $ort</p>";
- $sql="
- SELECT * FROM adressen
- LEFT JOIN orte ON adressen.plz = orte.plz
- " ;
- $db_erg=mysql_query($sql);
- if(!$db_erg)
- {
- die ('Ungültige Abfrage:|'.mysql_error());
- }
- ;
- echo '<table border="1">';
- while($zeile=mysql_fetch_array($db_erg, MYSQL_ASSOC))
- {
- echo "<tr>";
- echo "<td>".$zeile['id']."</td>";
- echo "<td>".$zeile['nachname']."</td>";
- echo "<td>".$zeile['vorname']."</td>";
- echo "<td>".$zeile['akuerzel']."</td>";
- echo "<td>".$zeile['strasse']."</td>";
- echo "<td>".$zeile['plz']."</td>";
- echo "<td>".$zeile['telefon']."</td>";
- echo "<td>".$zeile['email']."</td>";
- echo "<td>".$zeile['url']."</td>";
- echo "<td>".$zeile['ort']."</td>";
- echo "</tr>";
- print_r($zeile); echo "<br>";
- }
- mysql_free_result($db_erg);
- echo "</table>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement