Hallo zusammen,
ich schon wieder...
Ich sitze an einer SQL-Updateabfrage. Wenn ich keine Bedingung angebe, dann wird die ganze Datenbank geupdatet. Wenn ich die Bedingung drin stehen habe, dann passiert gar nichts... Sory ich bekomme es nicht richtig eingerückt...
Hier die Funktion:
firstname und lastname sind die Datenbankspalten und personFirstname und personLastname sind Objekte.
JavaScript
function updateCustomer(){
if(database){
var url = document.URL;
var person = url.substring(url.lastIndexOf("#")+1);
var personFirstname = person.split("_", 1);
var personLastname = person.split("_").slice(-1);
$(".nav--img.detailProfile.save").on("click", function(){
var firstnameProfile = $(".personal-item__field.firstname.detailProfile").val();
var firstnameAttribute = $(".personal-item__field.firstname.detailProfile");
var lastname = $(".personal-item__field.lastname.detailProfile").val();
var mail = $(".personal-item__field.email.detailProfile").val();
var phonenumber = $(".personal-item__field.phonenumber.detailProfile").val();
var brand = $(".car-item__field.brand.detailProfile").val();
var brandAttribute = $(".car-item__field.brand.detailProfile");
var model = $(".car-item__field.model.detailProfile").val();
var modelAttribute = $(".car-item__field.model.detailProfile");
var buildingyear = $(".car-item__field.builiding.year.detailProfile").val();
var buildingmonth = $(".car-item__field.builiding.month.detailProfile").val();
var buildingday = $(".car-item__field.builiding.day.detailProfile").val();
var kbanumberfirst = $(".car-item__field.kba.number.first.detailProfile").val();
var kbanumberlast = $(".car-item__field.kba.number.last.detailProfile").val();
var chassiscode = $(".car-item__field.chassis.code.detailProfile").val();
var motorcode = $(".car-item__field.motor.code.detailProfile").val();
var transmissioncode = $(".car-item__field.transmission.code.detailProfile").val();
var tuvmonth = $(".car-item__field.tuvmonth.detailProfile").val();
var tuvyear = $(".car-item__field.tuvyear.detailProfile").val();
var oiloldmonth = $(".car-item__field.oiloldmonth.detailProfile").val();
var oiloldyear = $(".car-item__field.oiloldyear.detailProfile").val();
var oiloldkilometer = $(".car-item__field.oilold.kilometer.detailProfile").val();
var oilnewmonth = $(".car-item__field.oilnewmonth.detailProfile").val();
var oilnewyear = $(".car-item__field.oilnewyear.detailProfile").val();
var oilnewkilometer = $(".car-item__field.oilnew.kilometer.detailProfile").val();
var timingbeltmonth = $(".car-item__field.timingbeltmonth.detailProfile").val();
var timingebltyear = $(".car-item__field.timingebltyear.detailProfile").val();
var timingebltkilometer = $(".car-item__field.timingbelt.kilometer.detailProfile").val();
var airfiltermonth = $(".car-item__field.airfiltermonth.detailProfile").val();
var airfilteryear = $(".car-item__field.airfilteryear.detailProfile").val();
var airfilterkilometer = $(".car-item__field.airfilter.kilometer.detailProfile").val();
var interiormonth = $(".car-item__field.interiormonth.detailProfile").val();
var interioryear = $(".car-item__field.interioryear.detailProfile").val();
var interiorkilometer = $(".car-item__field.interior.kilometer.detailProfile").val();
var fuelfiltermonth = $(".car-item__field.fuelfiltermonth.detailProfile").val();
var fuelfilteryear = $(".car-item__field.fuelfilteryear.detailProfile").val();
var fuelfilterkilometer = $(".car-item__field.fuelfilter.kilometer.detailProfile").val();
var transmissionfiltermonth = $(".car-item__field.transmissionfiltermonth.detailProfile").val();
var transmissionfilteryear = $(".car-item__field.transmissionfilteryear.detailProfile").val();
var transmissionfilterkilometer = $(".car-item__field.transmissionfilter.kilometer.detailProfile").val();
var notes = $(".item__field--notes.detailProfile").val();
if
(
firstnameProfile !== "" && firstnameProfile !== firstnameAttribute.attr("rel") &&
brand !== "" && brandAttribute !== brandAttribute.attr("rel") && model !== "" &&
modelAttribute !== modelAttribute.attr("rel")
)
{
alert
(
firstnameProfile +"!=="+ "" +"&&"+ firstnameProfile +"!=="+ firstnameAttribute.attr("rel") +"&&"+
brand +"!=="+ "" +"&&"+ brandAttribute +"!=="+ brandAttribute.attr("rel") +"&&"+ model +"!=="+ ""
+"&&"+ modelAttribute +"!=="+ modelAttribute.attr("rel")
);
database.transaction(function(transaction){
transaction.executeSql
("UPDATE customerprofile SET lastname=?, mail=?, phonenumber=?, "+
"brand=?, model=?, buildingday=?, buildingmonth=?, buildingyear=?, kbanumberfirst=?, kbanumberlast=?, " +
"chassiscode=?, motorcode=?, transmissioncode=?, tuvmonth=?, tuvyear=?, oiloldmonth=?, oiloldyear=?, " +
"oiloldkilometer=?, oilnewmonth=?, oilnewyear=?, oilnewkilometer=?, timingbeltmonth=?, " +
"timingebltyear=?, timingebltkilometer=?, airfiltermonth=?, airfilteryear=?, " +
"airfilterkilometer=?, interiormonth=?, interioryear=?, interiorkilometer=?, " +
"fuelfiltermonth=?, fuelfilteryear=?, fuelfilterkilometer=?, transmissionfiltermonth=?, " +
"transmissionfilteryear=?, transmissionfilterkilometer=?, notes=? WHERE firstname=personFirstname, lastname=personLastname",
[
lastname,
mail,
phonenumber,
brand,
model,
buildingday,
buildingmonth,
buildingyear,
kbanumberfirst,
kbanumberlast,
chassiscode,
motorcode,
transmissioncode,
tuvmonth,
tuvyear,
oiloldmonth,
oiloldyear,
oiloldkilometer,
oilnewmonth,
oilnewyear,
oilnewkilometer,
timingbeltmonth,
timingebltyear,
timingebltkilometer,
airfiltermonth,
airfilteryear,
airfilterkilometer,
interiormonth,
interioryear,
interiorkilometer,
fuelfiltermonth,
fuelfilteryear,
fuelfilterkilometer,
transmissionfiltermonth,
transmissionfilteryear,
transmissionfilterkilometer,
notes
],
updateSuccess, error);
});
}
else
{
alert("Bitte fülle alle markierten Felder mit einem gültigen Wert aus!")
$(".personal-item__field.firstname.detailProfile, .car-item__field.brand.detailProfile, .car-item__field.model.detailProfile").addClass("is-error"); $(".personal-item__field.is-required, .car-item__field.is-required").val($(".personal-item__field.is-required, .car-item__field.is-required").data("rel"));
}
});
}
else
{
alert("database does not exist");
}
}
Alles anzeigen