|
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
|
|