Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
$csvfile = "1','Birne','grün\n2','Erdbeere','rot";
$zeile = explode("\n",$csvfile);
// Ergebnis:
// Array
// (
// [0] => 1','Birne','grün
// [1] => 2','Erdbeere','rot
// )
foreach($zeile as $felder)
{
$feld = explode("','",$felder);
$sql="UPDATE obst SET Sorte='$feld[1]', Farbe='$feld[2]' WHERE ID='$feld[0]'";
// SQL QUERY ..
}
foreach($zeile as $felder)
{
$feld = explode("','",$felder);
$sql="UPDATE obst SET Farbe='$feld[2]' WHERE ID='$feld[0]'";
// SQL QUERY ..
}
CREATE TRIGGER TRG_STAGE
BEFORE INSERT ON stage_table FOR EACH ROW
BEGIN
INSERT INTO
target_table (id, field1, field2)
VALUES (NEW.id, NEW.field1, NEW.field2)
ON DUPLICATE KEY UPDATE field2 = NEW.field2;
END;