function clearCurrentAuth($uid) { $sqlCommand = 'delete from currentAuth where userId=(select userId from uid where uid="' . $uid . '");'; odbcSqlQuery($sqlCommand, 1); }
<?php include 'odbc.php'; // insert one testuser (tester1) in table user $userId = uniqid(true, "FHS"); $name = "tester1"; $command = 'INSERT INTO user (userID , name) VALUES ("' . $userId . '" , "' . $name . '" );'; odbcSqlQuery($command, 1); // insert one test UID in table UID $uid = "04703d323b2480"; $command = 'INSERT INTO uid (uid , userId) VALUES ("' . $uid . '","' . $userId . '");'; odbcSqlQuery($command, 1); // insert one test pblickey in table publickey $pubkey = <<<EOF -----BEGIN RSA PUBLIC KEY----- MIICCAKCAgEAsryP0O+R7n4WlyviS3JXX2UY69tIy9UHSriODbusXr37FBXJLmRW BhDPYZCGk3cPyhBiujOFBjvWM6K7zQpjPA8jabbnGO2N79HyVFxzS2GWh/hCn/Hm ak5GYDFqp8xRwIZQB+NmQrw1K1rcQkeD0R/pkWYeq9u5gpafkNuonbUkk19DTcgQ iz0XHHICAvPPROMQjU8qLjZzxkDMSsCo5QWnMDzCTP/Hkw4vPNh0jjT3PR7a9YgA Mlg0LXV92KtVNuZZoa2oDjLxFc3UB5lsxI0DCIS1/hlBoBtNrR7Rm3ElHTh8XBPq 3Q89FheNW9VzvjB7akSUEPNPXqoJWdbeeYUNPZjbsiImuDyL+0yBMC+89OJmy5SN FQBslvM3hExp4X1Te6cnjWjd6QBP8hSEOcNP1BAj37XwNVtaGceFIapVTwAvPfvR pT0wuS3Ux1nGHBFbvCvU3kFKBEIszHcUbAb7lpZa5A8er4BWVZPLzYHTHHGhjjr6 8yhWwVBmrcg/iip3q9JpfA4JPUOrgKZmQmWTzlBouiZ2mMDNxRhGq3tcCIyRfFoZ aCUw1hXVdCY1s3LbT/X/KkEuCObLU+o/8UfuMLG1xV1W0oluJ+tVHhcdfbZq3Abx jHLiPQky/KNiefMIncoCSSjKzpHeGoQh7ZAwSKKJwUUzzK5iaNprWRECAQM= -----END RSA PUBLIC KEY----- EOF; $command = 'INSERT INTO publickey (publicKey , userId) VALUES ("' . $pubkey . '","' . $userId . '");'; odbcSqlQuery($command, 1);