'; #Get variablen in in normale schreiben $email = trim(mysqli_real_escape_string($con, $_GET['email'])); $key = trim(mysqli_real_escape_string($con, $_GET['key'])); #User aus datenbank lesen $result_verify_email = $con->query("select * from user where email = '$email' and isactive = 1"); #Prüfen ob user existiert if (mysqli_num_rows($result_verify_email) == 1) { echo ''; } else { #Prüfen ob variablen gesetz sind if (isset($email) && isset($key)) { #user aktivieren $Userid = $con->query("select UserID from user where email = '$email' and isactive = 1")->fetch_object()->Userid; $produkte = $con->query("Select ArtNr from produkte"); #Standard werte für Produkte auf 0 Setzen while($row = mysqli_fetch_array($produkte)) { $ArtNr = $row['ArtNr']; $sql = $con->query("insert into standard_bestellung (userid_fk,produktid_fk,Anzahl) VALUES ('$Userid','$ArtNr','0');"); } echo ''; } else { echo ''; } } echo '