exec(" BEGIN TRANSACTION; INSERT INTO $name (id, folder, name, type, public) VALUES (NULL, $k, $folder_array[$i], '$type', '$public'); COMMIT; ")){ $primary_key_db = $db->query("SELECT id FROM $name WHERE name='$folder_array[$i]"); $primary_key_ar = $primary_key_db->fetchArray(SQLITE3_NUM); $primary_key = $primary_key_ar[0]; $k=$primary_key; } else { database_error(); } } else { $primary_key_db = $db->query("SELECT id FROM $name WHERE name='$pwd'"); $primary_key_ar = $primary_key_db->fetchArray(SQLITE3_NUM); $primary_key = $primary_key_ar[0]; if(db->exec(" BEGIN TRANSACTION; INSERT INTO $name (id, folder, name, type, public) VALUES (NULL, $primary_key, '$folder_array[$i]', '$type', '$public'); COMMIT; ")){ $pwd='$folder_array[$i]'; } else { database_error(); } } } echo "END"; } else { echo "Hallo $name
"; echo "END"; }