getDBSequence

  function getDBSequence() {
    $servername = "localhost";
    $username = "root";
    $password = "";
    $database = "Amacon";
    $sequence = -1;

    $conn = new mysqli($servername, $username, $password, $database);

    if ($conn->connect_error) {
       die("Connection failed: " . $conn->connect_error);
       return $sequence;
    }

    $sql = 'UPDATE sequence SET id=LAST_INSERT_ID(id+1);';
    $result = $conn->query($sql);
    if ( $result ){
       $sql ='SELECT LAST_INSERT_ID()';
       $result = $conn->query($sql);
       if ( $result ){
         while ( $row = $result->fetch_array() ) {
           $sequence = intval($row[0]) ;  // only one loop !
         } // while
       }  // if 
    }
    else {
      // die('SQL-Anweisung gescheitert');
      return $sequence;
    }
    return $sequence;
}



  function insertCustomerDB($customer) {
    $sql = 'INSERT INTO employee(PINDEX, CNR, LASTNAME, FIRSTNAME, STREET,  BIRTHDAY)' .
        ' VALUES(  ' . 
        ' ' . $customer->getpindex() . ', ' .
        ' ' . $customer->getcnr() . ', ' .
        ' ' . $customer->lastnamequoted() . ', ' .
        ' ' . $customer->firstnamequoted() . ', ' .
        ' ' . $customer->streetquoted() . ', ' .
        ' ' . $customer->birthdayquoted() . 
        ' )';

    $servername = "localhost";
    $username = "root";
    $password = "";
    $database = "Amacon";

    $conn = new mysqli($servername, $username, $password, $database);

    if ($conn->connect_error) {
       die("Connection failed: " . $conn->connect_error);
       return false;
    }
    $result = $conn->query($sql);
    return $result;

   } // insertCustomerDB