PHP-Projekt/Testdatenbank

Aus Mikiwiki
Zur Navigation springen Zur Suche springen

Auf Rechner "kanzler".

Anlegen der Datenbank "md". 

$ mysql -u root -p
mysql> create database md;
mysql> quit

Anlegen Verzeichnis mit PHP-Skripten. 

$ cd /WWW
$ sudo mkdir md && sudo chown mik:mik md
database.md.base.inc.php
Erfordert server.mysql.inc.php
Bereitgestellte Variablen
  • $database
  • $connection
Verwendete Funktionen
  • mysqlconnection()
  • mysqldie()
<?php

### Name          database.md.base.inc.php
### Description   Standard variables and functions with database "md"

require("server.mysql.inc.php");

### VARIABLES ###

$database   = "md";
$connection = mysqlconnection("{$database}",
                              "database.{$database}.password.inc.php")
                or mysqldie("Unable to connect");
?>
database.md.password.inc.php
Diese Datei sollte später in ein anderes Verzeichnis verschoben werden, das mit ".htaccess" gegen allgemeines Herunterladen geschützt ist. Die include-Zeilen in den anderen Dateien müssen dann entsprechend angepasst werden.
Bereitgestellte Variablen
  • $mysqluser
  • $mysqlpassword
  • $mysqlserver
<?php

### Name          database.md.password.inc.php
### Description   

### VARIABLES ###

$mysqluser     = "root";        # MySQL user
$mysqlpassword = "xxxxxx";      # password
$mysqlserver   = "kanzler";     # name of host on which MySQL is running
?>
server.mysql.inc.php
Bereitgestellte Funktionen
  • mysqlconnection()
  • mysqldie()
  • mysqlinsert()
  • mysqlselect()
Verwendete Variablen
  • $mysqluser
  • $mysqlpassword
  • $mysqlserver
<?php

## Name          server.mysql.inc.php
## Description   Basic MySQL input and output functions


### FUNCTIONS ###

## Connecting with MySQL, activating database "md"; in case of a
## connection error, show a complete HTML document with a short error message
function mysqlconnection($mysqldatabase,$passwordfile) {
  ## In order to increase the security of this project, 
  ## move ...password.inc.php to another directory which is protected against
  ## general download by .htaccess and change the include line accordingly
  require($passwordfile);
  $connection = mysql_connect($mysqlserver, $mysqluser, $mysqlpassword);
  if ($connection) {
    mysql_select_db($mysqldatabase);
    return $connection;
  }
  else {
    echo "<html>";
    echo "<head>";
    echo "<title>No connection</title>";
    echo "</head>";
    echo "<body>";
    echo "<p>No connection to database</p>";
    echo "</body>";
    echo "</html>";
    exit();
  }
}

function mysqldie($errortext)
{
  $message = mysql_error();
  $number = mysql_errno();
  return  "[{$errortext}] ( {$number} : {$message} )<br />\n";
  exit;
}

function mysqlinsert($tarray) {
  ## number of insert fields
  $noif   = count($tarray["insert"]);
  $insert = "insert into {$tarray["t"]} (";
  for ($i = 0; $i < $noif; $i++) {
    $insert .= $tarray["fname"][$tarray["insert"][$i]];
    if ($i < $noif - 1) {
      $insert .= ",";
    }
  }
  $insert .= ") values (";
  for ($i = 0; $i < $noif; $i++) {
    $insert .= "'{$tarray["fvalue"][$tarray["insert"][$i]]}'";
    if ($i < $noif - 1) {
      $insert .= ",";
    }
  }
  $insert .= ")";
  return $insert;
}

function mysqlselect($resultfields,$tarray) {
  ## number of clauses
  $noc    = count($tarray["clause"]);
  ## number of select fields
  $nosf   = count($resultfields);
  $select = "select ";
  for ($i = 0; $i < $nosf; $i++) {
    $select .= $tarray["fname"][$resultfields[$i]];
    if ($i < $nosf - 1) {
      $select .= ",";
    }
  }
  $select .= " from {$tarray["t"]} where ";
  for ($i = 0; $i < $noc; $i++) {
    $select .= $tarray["fname"][$tarray["clause"][$i]];
    $select .= " = '{$tarray["fvalue"][$tarray["clause"][$i]]}'";
    if ($i < $noc - 1) {
      $select .= " and ";
    }
  }
  return $select;
}

?>

Apache-Errorlog unter "/var/log/apache2/error.log"

Von «https://mikiwiki.org/mikiwiki/index.php?title=PHP-Projekt/Testdatenbank&oldid=11870»